# Airtable

Push submissions into an Airtable base with typed field mapping. Each submission becomes a new record, and past submissions can be copied in when you connect.

## What you get

- One record per submission
- Each field mapped to a column of a matching type
- Metadata columns, including a link to the submission PDF
- An optional rich-text body built from the answers
- Past submissions copied in when you connect
- Mappings that keep working when you rename a column

## Connect Airtable

1. **Open Integrations**

   Click **Integrations** (plug icon) in the form's top bar, then pick Airtable.

2. **Account and table**

   Pick a connected Airtable account, or click **Connect Airtable account** and choose the bases Formstep may use. Then pick the base and table.

3. **Fields**

   Match each form field to a column. Only columns of a compatible type are listed. You can also write a rich-text body.

4. **Turn it on**

   Under **More options**, turn on **Export existing submissions** to copy past responses. Click **Turn on Airtable**, then **Send test** to write a placeholder record.

## Column types

| Form field | Compatible Airtable columns |
| - | - |
| Short / long text | Single line text, Long text, Rich text |
| Email | Email, Single line text, Long text, Rich text |
| Phone | Phone, Single line text, Long text, Rich text |
| URL | URL, Single line text, Long text, Rich text |
| Number | Number, Currency, Percent, Rating, Duration, Single line text, Long text, Rich text |
| Rating / Scale | Rating, Number, Single line text, Long text, Rich text |
| Date | Date, Date & time, Single line text, Long text, Rich text |
| Time | Single line text, Long text, Rich text |
| Toggle switch | Checkbox, Single line text, Long text, Rich text |
| Radio / Dropdown (single) | Single select, Multi-select, Single line text, Long text, Rich text |
| Checkboxes (multi) | Multi-select, Single line text, Long text, Rich text |
| File upload | Attachments, URL, Single line text, Long text, Rich text |
| Signature | URL, Single line text, Long text, Rich text |
| Picture choice | Multi-select, Single select, Single line text, Long text, Rich text |
| Payment | Currency, Number, Single line text, Long text, Rich text |
| Matrix / Ranking | Single line text, Long text, Rich text |

When an answer matches no select option, Formstep creates the option.

You cannot map read-only columns: formula, rollup, count, lookup, linked record, collaborator, created/modified time, created/modified by, auto-number, button, and synced-source columns.

## Repeating groups

Map a [repeating group](https://formstep.io/docs/building-forms/repeating-groups/) in either or both ways:

- The whole group maps to one field. Every item shows as numbered, labeled rows, like “1. Full name: Jane Appleseed, Age: 34, 2. Full name: Marcus Lee, Age: 29”.

- Each member field maps to its own field. The values from every item join with `· `, so the Full name field reads “Jane Appleseed · Marcus Lee”.

## Rich-text body

You can write the content of a Rich text, Long text, or Single line text column in the template editor. Type **@** to insert an answer or metadata, such as PDF Link. Rich text columns keep the formatting. Other columns get plain Markdown.

You can use headings (H1-H4), **bold**, _italic_, ~~strikethrough~~, `inline code`, links, and lists. Images and embeds are not supported.

## Test event

**Send test** writes a record of placeholder values. Select columns get the question’s first option, so no new options are created. Delete the test record when you are done.

## Backfill existing submissions

Past submissions are copied in the background. The integration shows the progress.

## Unfinished drafts

On Pro and Business, Airtable can also add [unfinished drafts](https://formstep.io/docs/submissions-analytics/partial-submissions/#unfinished-drafts), set under **More options** › **Unfinished drafts**. To tell them apart, map Submission status to a single-select or text column: it reads “Partial”, “Completed” or “Updated”.

## Column changes in Airtable

- Rename a column: the mapping updates on the next submission.
- Delete a column: Formstep drops it from the mapping and syncs the other fields.
- Change a column to an incompatible type: that value fails to sync. Open the integration and map the field again.

## When something goes wrong

- If a column is missing from the list, check that you gave Formstep access to the base and that the column type can be written (see [Column types](#column-types)).

- If the integration shows **Connection expired**, for example because you revoked access in Airtable, click **Reconnect**.

- When Airtable is busy, Formstep slows down and retries on its own. For retries and pausing, see [Health and monitoring](https://formstep.io/docs/integrations/health-monitoring/).

## FAQ

**What access does Formstep need?**

It reads and writes records, reads the structure of your bases, and reads your email to know which account is connected. You sign in with Airtable, so there are no keys to manage.

**Can other workspace members see my Airtable connection?**

Yes. Airtable accounts are connected to the workspace. Any member can use any connected account in an integration.

**Can I connect multiple Airtable accounts?**

Yes. The workspace owner connects more accounts, from Integrations or during setup. Each form picks one account.

**What happens if I delete the Airtable table?**

The next submission fails with a “not found” error and the integration stops. You cannot change the base or table later. Delete the integration and create a new one for the new table.

**How do I remove the integration?**

Open Integrations, pick Airtable under **On this form**, and choose **Delete integration** in the ⋯ menu. To also revoke Formstep’s access, remove Formstep in your Airtable account settings.

## Next steps

[Notion](https://formstep.io/docs/integrations/notion/) — Add each submission to a Notion database

[Google Sheets](https://formstep.io/docs/integrations/google-sheets/) — Add each submission to a spreadsheet as a row

[Repeating groups](https://formstep.io/docs/building-forms/repeating-groups/) — Let respondents add as many items as they need

[Health and monitoring](https://formstep.io/docs/integrations/health-monitoring/) — Retries, pausing and reconnecting