Available on: Personal, Professional, Business plans
Airtable is a service that lets you create online spreadsheets with the power of databases. Airtable allows you to create, share and organize your spreadsheets with your team using database features like column data types, links between tables, collaboration, sorting, and views that can be published on external websites.
Form Setup
Before using the Airtable Plugin you must create a form to collect new submissions. Any HTML form will work.
The Airtable Plugin is quite simple. You can use any field in your form and there are no required or special fields.
To use a form to populate your spreadsheet, just be sure that form field names match the spreadsheet's column names.
If you have a form like this:
<form action="http://formspree.io/hash-id" method="POST">
<input type="text" name="name">
<input type="email" name="email">
<input type="text" name="comments">
<input type="submit" value="Send">
</form>You'll need to setup the airtable columns with the same names as those fields like this:
Any other field that is present in form but not in table won't be persisted at Airtable.
Connecting to Airtable
Note: If you're using the Formspree CLI please instead refer to our article Sending submissions to Airtable to connect to Airtable.
Once you've created and configured a form that, you can connect to Airtable using the Airtable Plugin. First go to the Workflow (or Plugins) tab of your form. Then click the Airtable Plugin button.
You will be redirect to connect to your Airtable account. Select the bases that you want to send submissions to. Click Grant Access.
After that you'll be prompted to Airtable settings. At this moment you'll be able to see your bases.
Selecting a base, tables list will be loaded. Then select a table.
By checking Sync existing submissions, all your form's existing submissions will be persisted to the selected table.
Finally, click connect to enable the Airtable Plugin.
In the future, if you'd like to change the base/table or disable the plugin entirely, you can do so by clicking on the Airtable button again to adjust its settings.