Update record - Automate.ax

airtable.updateRecord changes one record. Merge mode changes only supplied fields. Replace mode can clear omitted writable fields.

Example

automations/update-airtable-record.automation.ts

import { automation, onDashboardRun } from "automate.ax"
import { airtable } from "automate.ax/airtable"

export default automation("Qualify an Airtable lead", () => {
  onDashboardRun({ title: "Qualify an Airtable lead" })
  airtable.updateRecord({
    baseId: "appCRM",
    table: "Leads",
    recordId: "rec123",
    fields: { Status: "Qualified" },
  })
})

Inputs

Input	Type	Required	Default	Description
`baseId`	`string`	Yes	None	Stable Airtable base ID.
`table`	`string`	Yes	None	Table name or stable ID.
`recordId`	`string`	Yes	None	Stable ID of the record to update.
`fields`	`Record<string, JsonValue>`	Yes	None	New values keyed by field name or ID.
`mode`	`"merge" \| "replace"`	No	`"merge"`	Preserve or replace omitted writable fields.
`typecast`	`boolean`	No	`false`	Ask Airtable to coerce string values.
`returnFieldsByFieldId`	`boolean`	No	`false`	Key returned fields by stable IDs.
Second argument: `{ account }`	`string \| IntegrationAccountReference<"airtable">`	No	Project default	Connected Airtable account.

Output

Returns the updated AirtableRecord with id, createdTime, and fields.

mode: "replace" can clear writable fields you omit. Use merge mode unless replacing the record’s field set is intentional.