How to create Airtable records with any form
Tips & Tricks

How to create Airtable records with any form

A step-by-step guide to creating Airtable records with the form of your choice.

Looking for a way to collect information with a form and have it land directly in your Airtable base?

Airtable's native form builder is the easiest way to create beautiful forms that integrate with the design of your base. And it’s easy to connect virtually any platform to Airtable to save submitted form data in your base just the way you like.

Let’s take a look at your options:

Create an Airtable form
Connect a Typeform
Connect a JotForm
Connect another form service using Zapier

Create an Airtable form

The quickest way to collect information using forms is to create them directly in Airtable.

Each question and answer in an Airtable form comes directly from fields in your base and you can hide the ones you don’t need. You can change the field names to more detailed questions, add descriptions, receive email notifications when new responses come in, and—if you have a pro account—you can customize the look and feel as well.

You can also offer multiple choices and limit available selections based on criteria of your choosing, which gives you the ability to create your own simple booking system and more.

You don’t have to integrate anything to add an Airtable form that works with a table already in your base. Simply access the view selector, like you would to create a new grid (or other) view, and choose Form instead. You can make and adjustments you like and use it immediately by grabbing a link or embed code to add to your site.

If you want to learn more about creating forms within Airtable, check out our guide.

Connect a Typeform

If you have a Typeform Pro account, you can send responses from any form you create directly to Airtable.

Once you’ve created the form you want to connect, just follow these steps:

  1. From your Typeform Workspace, open the form you want to connect and click on the Connect Panel. Locate Airtable from the available options and click the Connect button.
  2. Typeform will prompt you to log into Airtable. Once you do, it’ll ask you for your Airtable API key, which you can generate on your Airtable account page (or access the existing key if you’ve generated one already). Back in Typeform, paste the key into the box requesting it and click Continue.
  3. Now that you’ve linked everything together, go ahead and choose the base and table you want to use with your form. Once you choose a base, you’ll be prompted to choose a table from that base.
  4. With your selections made, you just have to link up the questions in your form with the Airtable fields that you want to store the responses. Check out this page if you want to know which fields can link up with specific types of questions. If you realize you forgot to add a question to your form, you can click the +Add Another button to add more and immediately connect them to your Airtable fields. When you’ve got everything set up just the way you want, click Continue.
  5. If everything looks good, you’ll see the Activate Integration button. Click it and you’re all done.

If you head back to the Connect Panel in Typeform, you should see the new integration you just set up. If you ever want to turn it off and on, just click the toggle switch. It’s always a good idea to test your integration when you’ve finished, too, just in case you connect the wrong question to the wrong field without realizing it or to immediately discover if something doesn’t work the way you expect. You can easily do this by filling out the form you just linked and checking the results in your Airtable base.

Connect a JotForm

Any JotForm account—free or otherwise—can integrate with Airtable.

While many Airtable integrations connect one form to one table in one base, JotForm can send responses from any number of forms to any number of tables in the same base or different bases.

The video below, created by JotForm, walks through setting up this integration:

If you prefer written steps, however, just follow these:

  1. Open the form you want to connect to Airtable in the JotForms Form Builder, then click the Settings tab. Click on the Integrations option, search for Airtable, and select it from the results.
  2. JotForms will ask you for your Airtable API key, which you can generate on your Airtable account page (or access the existing key if you’ve generated one already). Paste it into JotForm and click the Authenticate button.
  3. Once your list of bases and tables appears, choose the base and table you want to connect to your form.
  4. A list of questions/inputs in your form and fields in your table will appear. Connect the form inputs to the appropriate Airtable fields and click the Save button once finished.
  5. If you wish, you can add additional form destinations if you wish by repeating steps three and four. This way you can direct some responses to one table and other responses to another. If you have a table with linked records, you may find this feature useful. You can also send responses to tables in separate bases as well.
  6. When you’ve completed your setup, click the Finish button to turn the integration on.

To test the integration, click the Publish tab and then the form’s URL to try it out. Once you’ve submitted a sample response, check all of the connected tables in Airtable to make sure everything shows up exactly as you expect.

Connect another form service using Zapier

If you prefer another form creation app that Zapier supports, you can connect it to Airtable to store responses similarly to how you can with Typeform and Jotform. Depending on the platform you choose, and the features you need with Zapier, you may or may not require paid accounts to set up these integrations. While it helps to check in advance so you don’t run into any unexpected roadblocks, the setup process remains essentially the same in either scenario.

First, if you haven’t connected Airtable and Zapier already, you should follow these instructions to do so. You will also need to connect your chosen form service to Zapier in a similar fashion. Once you’ve set up both, create a new zap and follow these new instructions to connect your form to a table in any of your Airtable bases:

  1. In Zapier, choose the form service you want to use as your zap’s trigger. If you have multiple options, you want to find the one that triggers when new responses to your form are submitted.
  2. If you have a paid Zapier account and want to add any interim actions (e.g. data formatting) or paths (conditional logic) you should add them now and save your final action for Airtable. If you don’t have any interim actions to set up, you can skip this step.
  3. For the final step in your zap, choose Airtable and select Create a new record as its action. Zapier will ask you to select a base and a table from that base. Make your choices and continue on.
  4. Zapier will provide a template with all of the your Airtable fields. For each empty field you want to fill in with submitted form data, click the button at the right end of each field to choose the data source you want to use. Once you’ve made your selections, save the template and finish your zap.

Once you’ve completed your zap, you only need to turn it on. After you do, you should submit a sample response through the form you connected to make sure everything shows up in Airtable as expected.

More for the record