update_field_config
Update the configuration of any Airtable field, including computed and non-computed types. Supports formula, rollup, lookup, select, number, date, and more, with options to add choices without removing existing ones.
Instructions
Update the configuration of any field — computed OR non-computed. Works for formula, rollup, lookup, count, singleSelect, multipleSelects, number, date, text, and all other field types.
COMMON typeOptions by fieldType:
formula: { formulaText: "IF({Field}, 1, 0)" } rollup: { relationColumnId: "fldLINK", foreignTableRollupColumnId: "fldTARGET", formulaText: "SUM(values)" } (formulaText is REQUIRED; old keys fieldIdInLinkedTable/recordLinkFieldId auto-translated) lookup: { relationColumnId: "fldLINK", foreignTableRollupColumnId: "fldTARGET" } (old keys fieldIdInLinkedTable/recordLinkFieldId auto-translated) count: { recordLinkFieldId: "fldXXX" } singleSelect: { choices: [{ name: "Option A", color: "blue" }], default: "selXXX" } multipleSelects: { choices: [{ name: "PC", color: "blue" }, { name: "Xbox", color: "cyan" }], default: ["selXXX"] } number: { format: "integer"|"decimal"|"currency"|"percentV2", precision: 2, symbol: "$", negative: false } text / multilineText / checkbox: omit typeOptions entirely — passing {} causes a 422
SELECT CHOICES:
Pass choices as array [{ name, color? }] or object { selXXX: { name, color? } }.
Color names (confirmed): "blue", "cyan", "teal", "green", "yellow", "orange", "red", "pink", "purple", "gray".
"default" = pre-selected value: string ID for singleSelect, array of IDs for multipleSelects.
ADDING TO AN EXISTING SELECT FIELD (merge, not replace): Choices not in the list are DELETED. To add without losing existing choices:
Call get_table_schema — each existing choice has { id, name, color }
Pass the full list: existing entries WITH their id, new entries WITHOUT: { choices: [{ id: "selXXXXXXXXXXXXXX", name: "Existing" }, { name: "New Choice", color: "pink" }] }
REPLACING ALL CHOICES: just pass the new choices without any IDs.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| appId | Yes | The Airtable base/application ID | |
| fieldId | Yes | The field/column ID (e.g. "fldXXX") | |
| fieldType | Yes | The field type: "formula", "rollup", "lookup", "count", "singleSelect", "multipleSelects", "number", "date", "text", etc. | |
| typeOptions | Yes | Type-specific options — see tool description for shapes per fieldType. | |
| debug | No | When true, include raw Airtable response in output for diagnostics |