airtable-mcp-server
by domdomegg
create_field
Create a new field in a table
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| baseId | Yes | ||
| nested | Yes | ||
| tableId | Yes |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"baseId": {
"type": "string"
},
"nested": {
"additionalProperties": false,
"properties": {
"field": {
"allOf": [
{
"properties": {
"description": {
"type": "string"
},
"name": {
"type": "string"
}
},
"required": [
"name"
],
"type": "object"
},
{
"anyOf": [
{
"additionalProperties": false,
"properties": {
"type": {
"const": "autoNumber",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"type": {
"const": "barcode",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"type": {
"const": "button",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"description": "Bases on a free or plus plan are limited to using the `'check'` icon and `'greenBright'` color.",
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"color": {
"description": "The color of the checkbox.",
"enum": [
"greenBright",
"tealBright",
"cyanBright",
"blueBright",
"purpleBright",
"pinkBright",
"redBright",
"orangeBright",
"yellowBright",
"grayBright"
],
"type": "string"
},
"icon": {
"description": "The icon name of the checkbox.",
"enum": [
"check",
"xCheckbox",
"star",
"heart",
"thumbsUp",
"flag",
"dot"
],
"type": "string"
}
},
"required": [
"color",
"icon"
],
"type": "object"
},
"type": {
"const": "checkbox",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"type": {
"const": "createdBy",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"result": {
"anyOf": [
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"dateFormat": {
"additionalProperties": false,
"properties": {
"format": {
"description": "`format` is always provided when reading.\n(`l` for local, `LL` for friendly, `M/D/YYYY` for us, `D/M/YYYY` for european, `YYYY-MM-DD` for iso)",
"enum": [
"l",
"LL",
"M/D/YYYY",
"D/M/YYYY",
"YYYY-MM-DD"
],
"type": "string"
},
"name": {
"enum": [
"local",
"friendly",
"us",
"european",
"iso"
],
"type": "string"
}
},
"required": [
"format",
"name"
],
"type": "object"
}
},
"required": [
"dateFormat"
],
"type": "object"
},
"type": {
"const": "date",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"dateFormat": {
"additionalProperties": false,
"properties": {
"format": {
"description": "`format` is always provided when reading.\n(`l` for local, `LL` for friendly, `M/D/YYYY` for us, `D/M/YYYY` for european, `YYYY-MM-DD` for iso)",
"enum": [
"l",
"LL",
"M/D/YYYY",
"D/M/YYYY",
"YYYY-MM-DD"
],
"type": "string"
},
"name": {
"enum": [
"local",
"friendly",
"us",
"european",
"iso"
],
"type": "string"
}
},
"required": [
"format",
"name"
],
"type": "object"
},
"timeFormat": {
"additionalProperties": false,
"properties": {
"format": {
"enum": [
"h:mma",
"HH:mm"
],
"type": "string"
},
"name": {
"enum": [
"12hour",
"24hour"
],
"type": "string"
}
},
"required": [
"format",
"name"
],
"type": "object"
},
"timeZone": {}
},
"required": [
"dateFormat",
"timeFormat"
],
"type": "object"
},
"type": {
"const": "dateTime",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
}
],
"description": "This will always be a `date` or `dateTime` field config."
}
},
"type": "object"
},
"type": {
"const": "createdTime",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"isValid": {
"description": "`false` when recordLinkFieldId is null, e.g. the referenced column was deleted.",
"type": "boolean"
},
"recordLinkFieldId": {
"type": [
"string",
"null"
]
}
},
"required": [
"isValid"
],
"type": "object"
},
"type": {
"const": "count",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"isValid": {
"description": "False if this formula/field configuation has an error",
"type": "boolean"
},
"referencedFieldIds": {
"anyOf": [
{
"items": {
"type": "string"
},
"type": "array"
},
{
"type": "null"
}
],
"description": "The fields to check the last modified time of"
},
"result": {
"anyOf": [
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"dateFormat": {
"additionalProperties": false,
"properties": {
"format": {
"description": "`format` is always provided when reading.\n(`l` for local, `LL` for friendly, `M/D/YYYY` for us, `D/M/YYYY` for european, `YYYY-MM-DD` for iso)",
"enum": [
"l",
"LL",
"M/D/YYYY",
"D/M/YYYY",
"YYYY-MM-DD"
],
"type": "string"
},
"name": {
"enum": [
"local",
"friendly",
"us",
"european",
"iso"
],
"type": "string"
}
},
"required": [
"format",
"name"
],
"type": "object"
}
},
"required": [
"dateFormat"
],
"type": "object"
},
"type": {
"const": "date",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"dateFormat": {
"additionalProperties": false,
"properties": {
"format": {
"description": "`format` is always provided when reading.\n(`l` for local, `LL` for friendly, `M/D/YYYY` for us, `D/M/YYYY` for european, `YYYY-MM-DD` for iso)",
"enum": [
"l",
"LL",
"M/D/YYYY",
"D/M/YYYY",
"YYYY-MM-DD"
],
"type": "string"
},
"name": {
"enum": [
"local",
"friendly",
"us",
"european",
"iso"
],
"type": "string"
}
},
"required": [
"format",
"name"
],
"type": "object"
},
"timeFormat": {
"additionalProperties": false,
"properties": {
"format": {
"enum": [
"h:mma",
"HH:mm"
],
"type": "string"
},
"name": {
"enum": [
"12hour",
"24hour"
],
"type": "string"
}
},
"required": [
"format",
"name"
],
"type": "object"
},
"timeZone": {}
},
"required": [
"dateFormat",
"timeFormat"
],
"type": "object"
},
"type": {
"const": "dateTime",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"type": "null"
}
],
"description": "This will always be a `date` or `dateTime` field config."
}
},
"required": [
"isValid",
"referencedFieldIds",
"result"
],
"type": "object"
},
"type": {
"const": "lastModifiedTime",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"type": {
"const": "lastModifiedBy",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"fieldIdInLinkedTable": {
"description": "The field in the linked table that this field is looking up.",
"type": [
"string",
"null"
]
},
"isValid": {
"description": "Is the field currently valid (e.g. false if the linked record field has\nbeen deleted)",
"type": "boolean"
},
"recordLinkFieldId": {
"description": "The linked record field in the current table.",
"type": [
"string",
"null"
]
},
"result": {
"anyOf": [
{},
{
"type": "null"
}
],
"description": "The field type and options inside of the linked table. See other field\ntype configs on this page for the possible values. Can be null if invalid."
}
},
"required": [
"fieldIdInLinkedTable",
"isValid",
"recordLinkFieldId"
],
"type": "object"
},
"type": {
"const": "lookup",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"precision": {
"description": "Indicates the number of digits shown to the right of the decimal point for this field. (0-8 inclusive)",
"type": "number"
}
},
"required": [
"precision"
],
"type": "object"
},
"type": {
"const": "number",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"precision": {
"description": "Indicates the number of digits shown to the right of the decimal point for this field. (0-8 inclusive)",
"type": "number"
}
},
"required": [
"precision"
],
"type": "object"
},
"type": {
"const": "percent",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"precision": {
"description": "Indicates the number of digits shown to the right of the decimal point for this field. (0-7 inclusive)",
"type": "number"
},
"symbol": {
"description": "Currency symbol to use.",
"type": "string"
}
},
"required": [
"precision",
"symbol"
],
"type": "object"
},
"type": {
"const": "currency",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"durationFormat": {
"enum": [
"h:mm",
"h:mm:ss",
"h:mm:ss.S",
"h:mm:ss.SS",
"h:mm:ss.SSS"
],
"type": "string"
}
},
"required": [
"durationFormat"
],
"type": "object"
},
"type": {
"const": "duration",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"type": {
"const": "multilineText",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"type": {
"const": "phoneNumber",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"description": "Bases on a free or plus plan are limited to using the 'star' icon and 'yellowBright' color.",
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"color": {
"description": "The color of selected icons.",
"enum": [
"yellowBright",
"orangeBright",
"redBright",
"pinkBright",
"purpleBright",
"blueBright",
"cyanBright",
"tealBright",
"greenBright",
"grayBright"
],
"type": "string"
},
"icon": {
"description": "The icon name used to display the rating.",
"enum": [
"star",
"heart",
"thumbsUp",
"flag",
"dot"
],
"type": "string"
},
"max": {
"description": "The maximum value for the rating, from 1 to 10 inclusive.",
"type": "number"
}
},
"required": [
"color",
"icon",
"max"
],
"type": "object"
},
"type": {
"const": "rating",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"type": {
"const": "richText",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"fieldIdInLinkedTable": {
"description": "The id of the field in the linked table",
"type": "string"
},
"isValid": {
"type": "boolean"
},
"recordLinkFieldId": {
"description": "The linked field id",
"type": "string"
},
"referencedFieldIds": {
"description": "The ids of any fields referenced in the rollup formula",
"items": {
"type": "string"
},
"type": "array"
},
"result": {
"anyOf": [
{},
{
"type": "null"
}
],
"description": "The resulting field type and options for the rollup. See other field\ntype configs on this page for the possible values. Can be null if invalid."
}
},
"type": "object"
},
"type": {
"const": "rollup",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"type": {
"const": "singleLineText",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"type": {
"const": "email",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"type": {
"const": "url",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"choices": {
"items": {
"additionalProperties": false,
"properties": {
"color": {
"description": "Optional when the select field is configured to not use colors.\n\nAllowed values: \"blueLight2\", \"cyanLight2\", \"tealLight2\", \"greenLight2\", \"yellowLight2\", \"orangeLight2\", \"redLight2\", \"pinkLight2\", \"purpleLight2\", \"grayLight2\", \"blueLight1\", \"cyanLight1\", \"tealLight1\", \"greenLight1\", \"yellowLight1\", \"orangeLight1\", \"redLight1\", \"pinkLight1\", \"purpleLight1\", \"grayLight1\", \"blueBright\", \"cyanBright\", \"tealBright\", \"greenBright\", \"yellowBright\", \"orangeBright\", \"redBright\", \"pinkBright\", \"purpleBright\", \"grayBright\", \"blueDark1\", \"cyanDark1\", \"tealDark1\", \"greenDark1\", \"yellowDark1\", \"orangeDark1\", \"redDark1\", \"pinkDark1\", \"purpleDark1\", \"grayDark1\"",
"type": "string"
},
"id": {
"type": "string"
},
"name": {
"type": "string"
}
},
"required": [
"id",
"name"
],
"type": "object"
},
"type": "array"
}
},
"required": [
"choices"
],
"type": "object"
},
"type": {
"const": "externalSyncSource",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"prompt": {
"description": "The prompt that is used to generate the results in the AI field, additional object\ntypes may be added in the future. Currently, this is an array of strings or objects that identify any fields interpolated into the prompt.\n\nThe prompt will not currently be provided if this field config is within another\nfields configuration (like a lookup field)",
"items": {
"anyOf": [
{
"type": "string"
},
{
"additionalProperties": false,
"properties": {
"field": {
"additionalProperties": false,
"properties": {
"fieldId": {
"type": "string"
}
},
"required": [
"fieldId"
],
"type": "object"
}
},
"required": [
"field"
],
"type": "object"
}
]
},
"type": "array"
},
"referencedFieldIds": {
"description": "The other fields in the record that are used in the ai field\n\nThe referencedFieldIds will not currently be provided if this field config is within another\nfields configuration (like a lookup field)",
"items": {
"type": "string"
},
"type": "array"
}
},
"type": "object"
},
"type": {
"const": "aiText",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"description": "Creating \"multipleRecordLinks\" fields is supported but updating options for\nexisting \"multipleRecordLinks\" fields is not supported.",
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"linkedTableId": {
"description": "The ID of the table this field links to",
"type": "string"
},
"viewIdForRecordSelection": {
"description": "The ID of the view in the linked table\nto use when showing a list of records to select from",
"type": "string"
}
},
"required": [
"linkedTableId"
],
"type": "object"
},
"type": {
"const": "multipleRecordLinks",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"choices": {
"items": {
"additionalProperties": false,
"properties": {
"color": {
"description": "Optional when creating an option.",
"type": "string"
},
"id": {
"description": "This is not specified when creating new options, useful when specifing existing\noptions (for example: reordering options, keeping old options and adding new ones, etc)",
"type": "string"
},
"name": {
"type": "string"
}
},
"required": [
"name"
],
"type": "object"
},
"type": "array"
}
},
"required": [
"choices"
],
"type": "object"
},
"type": {
"const": "singleSelect",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"choices": {
"items": {
"additionalProperties": false,
"properties": {
"color": {
"description": "Optional when creating an option.",
"type": "string"
},
"id": {
"description": "This is not specified when creating new options, useful when specifing existing\noptions (for example: reordering options, keeping old options and adding new ones, etc)",
"type": "string"
},
"name": {
"type": "string"
}
},
"required": [
"name"
],
"type": "object"
},
"type": "array"
}
},
"required": [
"choices"
],
"type": "object"
},
"type": {
"const": "multipleSelects",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": {},
"type": "object"
},
"type": {
"const": "singleCollaborator",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": {},
"type": "object"
},
"type": {
"const": "multipleCollaborators",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"dateFormat": {
"additionalProperties": false,
"properties": {
"format": {
"description": "Format is optional when writing, but it must match\nthe corresponding name if provided.\n\n(`l` for local, `LL` for friendly, `M/D/YYYY` for us, `D/M/YYYY` for european, `YYYY-MM-DD` for iso)",
"enum": [
"l",
"LL",
"M/D/YYYY",
"D/M/YYYY",
"YYYY-MM-DD"
],
"type": "string"
},
"name": {
"enum": [
"local",
"friendly",
"us",
"european",
"iso"
],
"type": "string"
}
},
"required": [
"name"
],
"type": "object"
}
},
"required": [
"dateFormat"
],
"type": "object"
},
"type": {
"const": "date",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"dateFormat": {
"additionalProperties": false,
"properties": {
"format": {
"description": "Format is optional when writing, but it must match\nthe corresponding name if provided.\n\n(`l` for local, `LL` for friendly, `M/D/YYYY` for us, `D/M/YYYY` for european, `YYYY-MM-DD` for iso)",
"enum": [
"l",
"LL",
"M/D/YYYY",
"D/M/YYYY",
"YYYY-MM-DD"
],
"type": "string"
},
"name": {
"enum": [
"local",
"friendly",
"us",
"european",
"iso"
],
"type": "string"
}
},
"required": [
"name"
],
"type": "object"
},
"timeFormat": {
"additionalProperties": false,
"properties": {
"format": {
"enum": [
"h:mma",
"HH:mm"
],
"type": "string"
},
"name": {
"enum": [
"12hour",
"24hour"
],
"type": "string"
}
},
"required": [
"name"
],
"type": "object"
},
"timeZone": {}
},
"required": [
"dateFormat",
"timeFormat"
],
"type": "object"
},
"type": {
"const": "dateTime",
"type": "string"
}
},
"required": [
"options",
"type"
],
"type": "object"
},
{
"additionalProperties": false,
"properties": {
"options": {
"additionalProperties": false,
"properties": {
"isReversed": {
"type": "boolean"
}
},
"required": [
"isReversed"
],
"type": "object"
},
"type": {
"const": "multipleAttachments",
"type": "string"
}
},
"required": [
"type"
],
"type": "object"
}
]
}
]
}
},
"required": [
"field"
],
"type": "object"
},
"tableId": {
"type": "string"
}
},
"required": [
"baseId",
"tableId",
"nested"
],
"type": "object"
}