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.
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="test" name="comments">
<input type="submit" value="Send">
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
Once you've created and configured a form that, you can connect to Airtable using the Airtable Plugin. First go to the Plugins tab of your form. Then click the Airtable Plugin button.
You'll be asked to insert an API Key to connect your account. To get this key, log in to Airtable and go to your account settings. On the Account Overview page, you'll see a section called API. If you have problems with that see the official documentation.
Copy and paste the key to Formspree clicking in this input. After that click Connect.
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.