Skip to main content

Airtable

Use Airtable when a team already manages structured data in bases and wants a generated app on top of that workflow.

Example app: assignment manager​

Build an assignment management app using React, NestJS, and Airtable.
Users can create, read, update, and delete assignments.
Include dashboard statistics, a Kanban board, deadline calendar, search, and filters.
Use Airtable as the data source and keep the token on the server.

Prepare the base​

  1. Identify the base, table, and view the app should use.
  2. Confirm field names and field types.
  3. Create a personal access token or approved service token.
  4. Give the token only the scopes and bases it needs.
  5. Store the token server-side.
Airtable home page with sample base
Start with a clear base and table structure.
Airtable token creation screen
Create a scoped token for the app.
Airtable access scope selection screen
Limit token access to the required base and operations.
AIRTABLE_TOKEN=
AIRTABLE_BASE_ID=
AIRTABLE_TABLE_NAME=
AIRTABLE_VIEW_NAME=

Suggested table structure​

FieldAirtable type
TitleSingle line text
SubjectSingle line text
DueDateDate
PrioritySingle select: Low, Medium, High, Urgent
StatusSingle select: Not Started, In Progress, Done
DescriptionLong text
CreatedAtCreated time

Column names should match exactly when the generated app maps fields by name.

Prompt Cocoding AI​

Connect the project dashboard to Airtable.
Use AIRTABLE_TOKEN and AIRTABLE_BASE_ID on the server.
Read from the Projects table and show status, owner, due date, and priority.
Add a sync error message when Airtable is unavailable.

Test Airtable access​

  1. Add a safe test row in Airtable.
  2. Refresh the Cocoding AI preview.
  3. Confirm the row appears with the correct fields.
  4. Update a non-sensitive field.
  5. Confirm Airtable receives the update if write access is enabled.
Generated StudyFlow dashboard backed by Airtable data
A generated Airtable app can show dashboard totals and deadline summaries.
Generated assignment creation form for an Airtable-backed app
Forms should map clearly to Airtable field names and field types.

Token setup​

  1. Create a personal access token.
  2. Select data.records:read.
  3. Add data.records:write only when the app needs to create or update records.
  4. Limit access to the required base.
  5. Copy the base ID from Airtable API docs or the base URL.
  6. Store the token as AIRTABLE_TOKEN.

Troubleshooting​

SymptomLikely causeWhat to check
Empty tableWrong base, table, or viewConfirm AIRTABLE_BASE_ID, table name, and view.
Permission deniedToken scope too narrowAdd only the required base and read/write scope.
Field missingField name mismatchCopy exact Airtable field names into the prompt.
Slow syncLarge base or broad viewUse filtered views and pagination.