create_field
Add custom fields to Airtable tables, including computed fields like formulas, rollups, lookups, and counts that extend beyond official API capabilities.
Instructions
Create a new field in an Airtable table. Supports all field types including computed fields (formula, rollup, lookup, count) that are not available via the official API.
FIELD TYPES (fieldType parameter): Canonical (internal-API names): "text", "multilineText", "number", "checkbox", "date", "singleSelect", "multipleSelects", "rating", "formula", "rollup", "lookup", "count" Friendly aliases (auto-normalized to internal shape): "url" → type: "text" with typeOptions.validatorName = "url" "email" → type: "text" with typeOptions.validatorName = "email" "phone" / "phoneNumber" → type: "text" with typeOptions.validatorName = "phoneNumber" "dateTime" → type: "date" with typeOptions: { isDateTime: true, dateFormat, timeFormat, timeZone, shouldDisplayTimeZone }
TYPE OPTIONS by fieldType: formula: { formulaText: "..." } rollup: { fieldIdInLinkedTable, recordLinkFieldId, resultType, referencedFieldIds } lookup: { recordLinkFieldId, fieldIdInLinkedTable } count: { recordLinkFieldId } number (integer): { format: "integer", negative: false } number (currency): { format: "currency", symbol: "$", precision: 2, negative: false } number (percent): { format: "percentV2", precision: 2, negative: false } date / dateTime: { dateFormat: "Local"|"us"|"european"|"iso"|"friendly", timeFormat: "12hour"|"24hour", timeZone: "UTC"|"client"|, shouldDisplayTimeZone: true|false, isDateTime: true (auto for dateTime) } singleSelect: { choices: [{ name: "Option A", color: "blueLight2" }] }
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| appId | Yes | The Airtable base/application ID | |
| tableId | Yes | The table ID to create the field in (e.g. "tblXXX") | |
| name | Yes | Name for the new field | |
| fieldType | Yes | The field type. Canonical or friendly alias — see tool description for full list. | |
| typeOptions | No | Type-specific config. See tool description for shape per fieldType. | |
| description | No | Optional field description | |
| insertAfterFieldId | No | Optional: field ID to insert after. Omit to append at end. | |
| debug | No | When true, include raw Airtable response in output for diagnostics |