JotForm User Guide / Advanced Features /

How to integrate JotForm with Airtable

How to integrate JotForm with Airtable

Airtable combines two of the most powerful business tools in productivity;  spreadsheets and databases, to provide an incredibly flexible way of organizing your data. Whatever you want to do with your data or information, chances are you can do it with Airtable.

The Airtable Integration on JotForm allows you to seamlessly send your data to Airtable, making it possible to manage your form data in Airtable.

The integration is pretty simple to set up, and you can do it in three simple steps:

1. On the builder, locate the Airtable Integration from the settings menu - go ahead and paste in your Airtable API Key. This guide will help you locate your Airtable API Key:


2. Select which of your bases you would like to connect to, then select one of the tables within that base:


3. Map the fields on your Table with the fields on your form and click 'save' to complete the Integration:


You can create multiple connections to various Airtable bases and tables with the same integration:


That's It!
Your form data will be sent to Airtable every time your form is submitted. If a form submission does not have any data on it, nothing will be sent over.

Have you tried this yet? How did it go?
Please let us know by leaving a comment below.

Send Comment

9 Comments...

  • ohioalumni

    This integration was released prematurely. It should just work....

  • Matt Tobias

    With the airtable integration can attachments also sync over.

    Thanks

  • CAPITALPV

    It seems that the integration is possible only for basic information. Is there any chance to connect direclty (without Zapier) multiple choice questions or conditional questions?

  • shahargurari

    Is there an option to use data from Air-table sheet in the questioner?
    I mean to use relevant information about person and present it on the form I send to him and to add his answers to other sheet on Airtable? Maybe it can be done via API??

  • allialosa

    I'm super excited about this integration, but it looks like mapping to linked record fields in Airtable isn't supported - none of my linked record fields show up in the list of choices. Would love confirmation if that's correct or not. :)

  • Magdalena_info

    For the life of me I can't figure out why a NUMBER value from JotForm will not work with Airtable's number nor rating fields. This is discouraging since column types are particularly beneficial for Blocks visualizations. I would like to use Card Forms to collect cancellation feedback efficiently and map it to my base. Looks like Zapier will still be a requirement for the time being until all the column types are supported natively by JotForm.

  • Liendo_Omar

    Integration works well, except that only data is transferred to one of the tables, and not the second table that i created relatsionships for.

    Example:
    "JotForm1" mapped fields to "Player Info" table = Works!
    "JotForm1" mapped fields to "Player Payment" table (second table) = Nothing shows up!

    Any ideas as to why the second table does not populate the data, even though all fields have been mapped successfully?

  • jotformAcademic

    This is great. However, will there be options to also include some of the meta data that is currently included in the google sheets integration including: The Submission ID, the IP address, the Edit Submission Link, The Submission Date/Time? Also, will there be a way to attach a copy of the Submission PDF? I know that form uploads are direct links, but the link to the Submission PDF isn't and that has caused us issues in the past trying to attach it to AirTable.

  • pwall05

    Everything looks good, except nothing shows up on the Airtable end. Are there any additional resources? Settings perhaps? Or something on the Airtables end I need to change?