Airtable
Connect a FormDB form to Airtable so each submission becomes a record, using an existing table or one that FormDB creates for the form.
This page shows how to send submissions to Airtable. Each submission becomes a new record (a row) in a table you choose, or in a table FormDB creates for the form.
Paid plans: Integrations are available on Starter, Growth and Business.
Connect
You need the admin or owner role.
- Open the form and go to the Integrations tab.
- In the Airtable card, click Connect.
- Approve the request in Airtable.
- Back in FormDB, the card shows Needs setup. Choose a Base.
- Choose a Table. Pick an existing table, or pick Create a new table for this form.
The integration starts working once a table is chosen. The card then shows which base and table it is sending to.
Finish the Airtable step within 10 minutes, signed in to FormDB with the same account. Otherwise click Connect again.
What FormDB can access
FormDB asks Airtable for permission to create records and to read and change the structure of bases, which it needs for listing your tables and creating a new one. The Base picker lists the bases where you have creator, editor or owner permission.
Option 1: let FormDB create the table
Choosing Create a new table for this form adds a table named <form name> submissions to the base, with these columns:
Column | Airtable field type |
|---|---|
| Single line text |
| Date and time (UTC) |
One column per builder field, named with the field's name | See below |
Builder field types become Airtable field types as follows:
Builder field | Airtable field type |
|---|---|
URL | URL |
Phone | Phone number |
Long text, File upload, Checkboxes | Long text |
Everything else | Single line text |
If the form has no fields in the form builder, FormDB creates a single long-text column named Data in addition to Submission ID and Submitted at. Each submission is written into it as JSON.
For the tidiest result, define your fields in the builder before creating the table.
Option 2: use an existing table
Pick one of your tables. FormDB does not change its columns. For each submission:
- A field is written to the column with the same name. Upper and lower case are ignored, so
emailfills a column calledEmail. Submission IDandSubmitted atare filled in if columns with those names exist.- Fields that have no matching column are written together as JSON into a column named
Data, if the table has one. If there is noDatacolumn, those fields are left out.
To capture everything, add a long-text column named Data to your table.
How values are written
- Airtable converts values to fit each column's type. For example, a new value in a single-select column is added as a new option.
- File fields are written as download links in text form, not as Airtable attachments. The links expire after 7 days. To get a file later, open the submission in FormDB. See File uploads.
Pause, test and disconnect
- Pause: use the switch at the top of the card. It appears after a table is chosen. Submissions received while paused are not sent later.
- Send latest submission: writes the form's most recent submission as a new record, as a test.
- Disconnect: removes the integration from the form. Records already created stay in Airtable.
To send to a different table, choose another one in the Table picker. The change is saved immediately.
What is not sent
- Submissions that arrived before you connected. Only new submissions create records.
- Submissions flagged as spam.
- Later changes. Deleting a submission in FormDB does not delete its Airtable record.
When a record does not appear
Check the Recent deliveries card at the bottom of the Integrations tab.
- Retrying: a temporary problem. FormDB tries up to 6 times over about 15 minutes.
- Failed: hover over the status to see the reason.
Reason | What to do |
|---|---|
"Choose an Airtable base and table" | Select a base and table in the card. |
"The Airtable table no longer exists." | The table was deleted. Choose another table. |
"Airtable access expired. Reconnect Airtable." | Click Disconnect, then Connect, and choose the base and table again. |
A failed delivery never affects the submission itself. It remains in your FormDB inbox.
Next steps
- Notion: send submissions to a Notion database.
- Google Sheets: send submissions to a spreadsheet.
- Webhooks: retries and the delivery log in detail.
Ready to try it? Create a free account and send your first submission.