Update record - Automate.ax

updateRecord changes one record. Merge mode touches only supplied fields; replace mode replaces its writable field set and can clear omitted values.

Example

automations/update-airtable-record.automation.ts

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

export default automation("Qualify an Airtable lead", () => {
  onHttpRequest({ scope: "automation" })
  updateRecord({
    base: "CRM",
    table: "Leads",
    recordId: "rec123",
    fields: { Status: "Qualified" },
  })
})

Inputs

Input	Type	Required	Default	Description
`base`	`string`	Yes	—	Exact base name or stable ID.
`table`	`string`	Yes	—	Table name or stable ID.
`recordId`	`string`	Yes	—	Stable ID of the record to update.
`fields`	`Record<string, JsonValue>`	Yes	—	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.
`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.

⌘I