Skip to content

Airtable integration

Add every Formkove submission to an Airtable table as a new record. You choose which form field goes into which column. This is a Pro and Agency feature. Free accounts can use it on their first 50 submissions.

Formkove connects with an Airtable personal access token.

  1. Open airtable.com/create/tokens and click Create token
  2. Add two scopes: data.records:write and schema.bases:read
  3. Under Access, add the base you want to send submissions to
  4. Create the token and copy it

The token only works on the bases you added, so you can keep it to one base.

  1. Open app.formkove.com and select your form
  2. Go to Integrations and click Connect Airtable
  3. Paste the token and click Continue
  4. Pick the base, then the table
  5. Map the fields (see below), optionally add a label and routing rules, then click Connect Airtable
  6. On the Connections tab, click Send test to add a sample record

The token is stored encrypted and is never shown again.

Formkove lists the columns of the table. For each one, pick what goes in it:

  • A form field, like name or email. Formkove lists the fields from your recent submissions. If the form has none yet, pick Other field… and type the field name as it appears in your form’s name attribute
  • A Formkove value: Submitted at, Submission ID, Form name, Sentiment, Tags, Spam score or File links
  • A fixed value that is the same on every record, like Website
  • Don’t send, to leave the column empty

Columns with the same name as a form field are filled in for you, so Full Name matches full_name. Columns Airtable fills itself (formulas, rollups, lookups, created time, autonumbers) are listed but can’t be mapped. Attachment, linked record and collaborator columns can’t be mapped yet.

To change it later, open Integrations → Connections and click Edit mapping. New columns you added in Airtable show up there.

  • Airtable converts the text it gets, so numbers, dates, checkboxes and emails land in the right type of column
  • Submitted at is in UTC
  • Sentiment, Tags and Spam score are only filled in when AI is on for the form
  • Spam isn’t sent to Airtable

Select columns: if a submitted value isn’t one of the column’s options, Airtable adds it as a new option when the token’s owner can change the base. If they can’t, Airtable refuses it, and Formkove saves the record without its select columns. The delivery history then says “Saved without select fields”. To keep the options fixed, send select values from a <select> in your form with the same options.

Test records leave select columns empty (unless you set a fixed value), so a test never adds an option.

Problem Fix
No new records Check the connection is enabled and has no routing rule that filters it out, then look at Integrations → Delivery history
“Airtable rejected the token” The token was deleted or expired. Delete the connection and connect again with a new token
“The token can’t write to this table” Give the token the data.records:write scope and add the base under Access
“Table or field not found” The table or a mapped column was deleted or renamed in Airtable. Click Edit mapping and save it again
“Airtable refused a field or value” A value doesn’t fit its column. Check the column types and click Edit mapping
“used up its monthly API calls” Your Airtable plan’s API limit for the month is reached. It resets next month, or upgrade the Airtable plan
A base is missing from the list Add the base to the token under Access. Only bases you can edit are listed

Deleting the connection keeps the table and its records in Airtable. To revoke Formkove’s access, delete the token in Airtable.