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.

  1. Open the form and go to the Integrations tab.
  2. In the Airtable card, click Connect.
  3. Approve the request in Airtable.
  4. Back in FormDB, the card shows Needs setup. Choose a Base.
  5. 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

Submission ID

Single line text

Submitted at

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

Email

Email

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 email fills a column called Email.
  • Submission ID and Submitted at are 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 no Data column, 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.