Airtable
Add each submission to an Airtable table as a new record. Map fields to columns, write a rich-text body, and copy past responses in too.
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, 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 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, 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).
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.
FAQ
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.
Yes. Airtable accounts are connected to the workspace. Any member can use any connected account in an integration.
Yes. The workspace owner connects more accounts, from Integrations or during setup. Each form picks one account.
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.
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.