Can I use Airtable and Zapier to create a form where people can submit their own art and only reference themselves in the "people" CMS category without affecting others' submissions?Is it possible to create a form using Airtable and Zapier where people can submit multiple pieces of art in one form?

Published on
September 23, 2023

Yes, it is possible to create a form using Airtable and Zapier where people can submit multiple pieces of art in one form. Here's how you can achieve that:

  1. Set up your Airtable base:
  • Create a table in Airtable to store the art submissions. You can define the fields based on the required information for each submission, such as name, email, artwork title, description, and image.
  • Add a field to reference the individual submitting the art. This can be a single select field called "People" where each person's name or identifier can be chosen.
  1. Set up the form:
  • In Airtable, go to the "Forms" tab in your base and create a new form.
  • Customize the form by adding the relevant fields for the art submission, such as name, email, artwork title, description, and the ability to upload images.
  • Ensure that the "People" field is set to "single select" or "dropdown" so that users can only reference themselves in the form.
  1. Configure the Zapier integration:
  • Create a new Zap in Zapier and choose Airtable as your trigger app.
  • Select the "New Form Response" trigger and connect it to your Airtable account and the specific base and form you created.
  • Once set up, test the trigger to ensure that Zapier is able to capture form responses.
  1. Set up the action step:
  • Choose the action app you want to use to process the form submissions. This could be an email service like Gmail or Mailchimp, a file storage service like Dropbox or Google Drive, or any other relevant app for your specific use case.
  • Configure the action step based on your desired outcome. For example, you can send an email confirmation to the submitter and attach the artwork, or save the submission details and image to a specific folder.
  1. Customize the Zap settings:
  • Customize any additional settings in the Zap, such as mapping the form fields to the action app fields or adding filters if necessary.
  • Test the entire Zap to make sure it's working as expected.

With this setup, people will be able to submit multiple pieces of art using the form, and each submission will reference only themselves in the "People" CMS category. The Zap will trigger whenever a new form response is received, and you can configure actions to suit your specific needs.

Additional Questions:

  1. How do I create a form in Airtable?
  2. Can I use Zapier to integrate Airtable with other apps?
  3. What types of actions can I perform in Zapier when integrating Airtable?