[Airtable] Create/Update record
The Airtable Create/Update Record block writes data to a specified table within an Airtable base.
Create or update records in an Airtable table
The Airtable Create/Update Record block writes data to a specified table within an Airtable base. It connects to Airtable via an OAuth connection and targets a specific base and table using their respective IDs. Depending on whether a record ID is provided, the block either creates a new record or updates an existing one, with field values supplied as a key-value map keyed by field ID.
When updating an existing record, the block accepts an update mode that controls how unspecified fields are handled. Setting the mode to 'onlySpecified' leaves any fields not included in the request unchanged, while 'all' clears fields that are not explicitly provided. The block returns the record ID of the created or updated record, which can be stored in a workflow variable for use in downstream steps.
This block fits into workflows that need to write structured data back to Airtable, such as logging form submissions, syncing AI-generated outputs to a database, updating task statuses, or maintaining records as part of a multi-step automation. It pairs naturally with blocks that retrieve or process data before persisting results.
What you can build
Real-world workflows powered by the [Airtable] Create/Update record block.
Log Form Submissions
Capture user-submitted form data from an AI app and write each submission as a new Airtable record for tracking and review.
Sync AI Outputs to Database
After an AI block generates a summary or classification, store the result directly in an Airtable table by creating or updating the corresponding record.
Update Task or Project Status
Modify an existing Airtable record's status field when a workflow step completes, keeping project management tables current.
Build CRM Lead Records
Create a new Airtable record for each lead captured through an AI-powered intake workflow, populating contact and qualification fields automatically.
Track Inventory or Assets
Update quantity or status fields on existing Airtable inventory records when an AI workflow processes a transaction or change event.
Append Content Moderation Results
After an AI block evaluates user-generated content, write the moderation outcome and confidence data to an Airtable record for audit logging.
Ready to add [Airtable] Create/Update record to your workflow?
Get Started FreeCommon questions about [Airtable] Create/Update record
What parameters are required to use this block?
The block requires a valid Airtable OAuth connection ID, a base ID identifying the Airtable base, a table ID identifying the target table, and a recordData object containing the field values to write, keyed by field ID. A record ID is optional — omitting it creates a new record, while providing one updates the existing record.
What does the block return?
The block outputs a single field, recordId, which is the Airtable record ID of the record that was created or updated. This value can be stored in a workflow variable using the destinationVar parameter for use in subsequent blocks.
What is the difference between the 'onlySpecified' and 'all' update modes?
When updateMode is set to 'onlySpecified', only the fields included in the recordData object are modified and all other fields on the record remain unchanged. When set to 'all', any fields not included in the recordData object are cleared on the existing record.
What kinds of workflows commonly use this block?
This block is used in workflows that need to persist data to Airtable, such as logging AI-generated outputs, syncing form submissions, updating task or project statuses, and maintaining records as part of multi-step automations. It is often placed after blocks that generate, transform, or retrieve data.
Can this block handle array-type fields like attachments?
Yes. Fields that accept multiple values, such as multipleAttachments, can be populated by passing an array of values in the recordData object for the corresponding field ID.
Related capabilities
[Notion] Create Page
Create a new page in Notion as a child of an existing page.
[Notion] Update Page
Update the content of an existing Notion page.
[Coda] Create/Update page
Create a new page or update an existing page in a Coda document.
[Coda] Get table rows
Fetch rows from a Coda table with optional pagination.
[Coda] Create/Update row
Create a new row or update an existing row in a Coda table.
[Coda] Get page
Export and read the contents of a page from a Coda document.
Add [Airtable] Create/Update record to your workflow
Build powerful AI workflows with drag-and-drop blocks. No coding required.