Airtable – Base and Table

Estimated reading time: 23 min

What your automation will do…

A connection to your Airtable account is needed so we can sync it with our platform.
Refer to Airtable – create a connection.

You can include between 1 and 255 Methods to build complex Flows.

BASE Copy Link

List Bases Copy Link

This Method is used to retrieve a list of Airtable bases that your token has access to. You’ll get a maximum of 1000 bases per request.
● If there are more than 1000 bases, the response will include an offset (like a marker to the next page).
● To get the next batch of bases, you need to send another request and include that offset in the parameter.

For more detail, see Airtable API reference List Bases

Configuration Table:

Input Options (Field Mapping):

Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
Default Value: Select value from a defined list or specify a fixed attribute.
Manual input: Set a custom value by using the Lightning Bold feature.

Name*	List Bases
Connection*	Select your connection or create one.

MAP FIELDS + Add Field ↓
Additional fields to configure the Method.

Offset:

Provide the offset of the next page (If there are more than 1000 bases, the response will include an offset).

(*) required field

Response sample

{
  "bases": [
    {
      "id": "appLkNDICXNqxSDhG",
      "name": "Apartment Hunting",
      "permissionLevel": "create"
    },
    {
      "id": "appSW9R5uCNmRmfl6",
      "name": "Project Tracker",
      "permissionLevel": "edit"
    }
  ],
  "offset": "itr23sEjsdfEr3282/appSW9R5uCNmRmfl6"
}

Expand

Get Base Schema Copy Link

This Method is used to get the schema of the tables in the specified base.

See Airtable Get base schema API reference.

Configuration Table:

Input Options (Field Mapping):

Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
Default Value: Select value from a defined list or specify a fixed attribute.
Manual input: Set a custom value by using the Lightning Bold feature.

Name*	Get Base Schema
Connection*	Select your connection or create one.

MAP FIELDS

Base ID*:

Select the base to get it schema, or manually enter the base ID.

if not Found Consider as:

Success – When the record is not found during execution, the system does not treat this as an error. Instead, it considers the operation successful and continues with the workflow.

Failed – Wiresk treats this as an error or failure. The workflow stops or takes a predefined failure action.

(*) required field

Response sample

[
  {
    “id”: “tblpUYR0cC8wsrxMp”,
    “name”: “Automations”,
    “primaryFieldId”: “fld4SHGX8YARleMcD”,
    “fields”: [
      {
        “type”: “singleLineText”,
        “id”: “fld4SHGX8YARleMcD”,
        “name”: “Automation Name”
      },
      {
        “type”: “multilineText”,
        “id”: “fldP7anb8dszEdnBU”,
        “name”: “Description”
      },
      {
        “type”: “date”,
        “options”: {
          “dateFormat”: {
            “name”: “local”,
            “format”: “l”
          }
        },
        “id”: “fld7LuI8utyH8VSm6”,
        “name”: “Creation Date”
      },
      {
        “type”: “date”,
        “options”: {
          “dateFormat”: {
            “name”: “local”,
            “format”: “l”
          }
        },
        “id”: “fldRTyFBldy8c77xU”,
        “name”: “Last Modified Date”
      },
      {
        “type”: “singleSelect”,
        “options”: {
          “choices”: [
            {
              “id”: “seliJOUzjQjHrw2th”,
              “name”: “Active”,
              “color”: “blueLight2”
            },
            {
              “id”: “selc9840CILWeYuUe”,
              “name”: “Inactive”,
              “color”: “cyanLight2”
            },
            {
              “id”: “selVIFLvsLYgBoKVu”,
              “name”: “Pending”,
              “color”: “tealLight2”
            },
            {
              “id”: “sel9Z8AEeDicwiPEv”,
              “name”: “Archived”,
              “color”: “greenLight2”
            }
          ]
        },
        “id”: “fldoKq3ypcOCNSdQx”,
        “name”: “Status”
      },
      {
        “type”: “singleLineText”,
        “id”: “fldU2797U8rIOiQLD”,
        “name”: “Owner”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblXfPs6khqGmXp1R”,
          “isReversed”: false,
          “prefersSingleRecordLink”: false,
          “inverseLinkFieldId”: “fldla8YmS0aL0xCe9”
        },
        “id”: “fldynOvosb0WIHccg”,
        “name”: “Related Performance Metrics”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblkbmJM75Qs8SyUO”,
          “isReversed”: false,
          “prefersSingleRecordLink”: false,
          “inverseLinkFieldId”: “fldEw4nfdPuW32ciR”
        },
        “id”: “fldhOO2xJv5Xvd3Tn”,
        “name”: “Associated Task Data”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tbl9uOSNFMyvQY3GE”,
          “isReversed”: false,
          “prefersSingleRecordLink”: false,
          “inverseLinkFieldId”: “fldfX2t8WpxdjU1RR”
        },
        “id”: “fld2xcsO4F5PoAeGO”,
        “name”: “Linked Scripts”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblzlQNEtFOFJ0mRi”,
          “isReversed”: false,
          “prefersSingleRecordLink”: false,
          “inverseLinkFieldId”: “fldu6RbzOk0JvsGRj”
        },
        “id”: “fldJsazUK7hTDU7Sh”,
        “name”: “Test Results”
      },
      {
        “type”: “rollup”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldynOvosb0WIHccg”,
          “fieldIdInLinkedTable”: “fldChXehJna5hnHLE”,
          “referencedFieldIds”: [],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fldSCZgMZgPmuVBNy”,
        “name”: “Total Execution Time”
      },
      {
        “type”: “rollup”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldynOvosb0WIHccg”,
          “fieldIdInLinkedTable”: “fldlOOAa3vmfM6axa”,
          “referencedFieldIds”: [],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fld7yo2Kit4Kwa5Oj”,
        “name”: “Average Success Rate”
      },
      {
        “type”: “rollup”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldynOvosb0WIHccg”,
          “fieldIdInLinkedTable”: “fldvvcOVKrK0lYro8”,
          “referencedFieldIds”: [],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fld4JjKnr1rxfzRhQ”,
        “name”: “Total Error Count”
      }
    ],
    “views”: [
      {
        “id”: “viwWHdR2wfZ7zknY5”,
        “name”: “Grid view”,
        “type”: “grid”
      }
    ]
  },
  {
    “id”: “tbl9uOSNFMyvQY3GE”,
    “name”: “Scripts”,
    “primaryFieldId”: “fld5arY6icZ2OVJPA”,
    “fields”: [
      {
        “type”: “singleLineText”,
        “id”: “fld5arY6icZ2OVJPA”,
        “name”: “Script Name”
      },
      {
        “type”: “multilineText”,
        “id”: “fldxcpYZgyQo2widX”,
        “name”: “Description”
      },
      {
        “type”: “date”,
        “options”: {
          “dateFormat”: {
            “name”: “local”,
            “format”: “l”
          }
        },
        “id”: “fldhvAhSmy5bDknmZ”,
        “name”: “Creation Date”
      },
      {
        “type”: “date”,
        “options”: {
          “dateFormat”: {
            “name”: “local”,
            “format”: “l”
          }
        },
        “id”: “fldk7OkzzaRQJ0dHv”,
        “name”: “Last Modified”
      },
      {
        “type”: “singleLineText”,
        “id”: “fldOtGm4lSvUIvvnQ”,
        “name”: “Version”
      },
      {
        “type”: “singleLineText”,
        “id”: “fldNdtxyEA9D1J3XF”,
        “name”: “Author”
      },
      {
        “type”: “singleSelect”,
        “options”: {
          “choices”: [
            {
              “id”: “selSKZIaTXDtLAWmB”,
              “name”: “Draft”,
              “color”: “blueLight2”
            },
            {
              “id”: “selexLuqfEROpoZeq”,
              “name”: “In Review”,
              “color”: “cyanLight2”
            },
            {
              “id”: “selR0ZcelUrWXM1UJ”,
              “name”: “Approved”,
              “color”: “tealLight2”
            },
            {
              “id”: “selME7OUQGoZWXx3m”,
              “name”: “Rejected”,
              “color”: “greenLight2”
            }
          ]
        },
        “id”: “fldGqoYEMLrqkTYuH”,
        “name”: “Status”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblkbmJM75Qs8SyUO”,
          “isReversed”: false,
          “prefersSingleRecordLink”: false,
          “inverseLinkFieldId”: “fld43NvfzjiopAoT8”
        },
        “id”: “fldIptEJ1uEhSlvIc”,
        “name”: “Associated Tasks”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblzlQNEtFOFJ0mRi”,
          “isReversed”: false,
          “prefersSingleRecordLink”: false,
          “inverseLinkFieldId”: “fldkymOXhHiooZY4H”
        },
        “id”: “fldvjyJqW13bflJH6”,
        “name”: “Test Results”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblXfPs6khqGmXp1R”,
          “isReversed”: false,
          “prefersSingleRecordLink”: true,
          “inverseLinkFieldId”: “fld7glKKURgHbPb75”
        },
        “id”: “fldzg5NokRBlP7iiC”,
        “name”: “Performance Metrics”
      },
      {
        “type”: “multipleAttachments”,
        “options”: {
          “isReversed”: true
        },
        “id”: “fldIhz5le8zEQkSYm”,
        “name”: “Script File”
      },
      {
        “type”: “count”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldIptEJ1uEhSlvIc”
        },
        “id”: “fld6d5gMU3vGNHWGK”,
        “name”: “Total Associated Tasks”
      },
      {
        “type”: “count”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldvjyJqW13bflJH6”
        },
        “id”: “fldLw0WCyVQpr58Bv”,
        “name”: “Total Test Results”
      },
      {
        “type”: “rollup”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldzg5NokRBlP7iiC”,
          “fieldIdInLinkedTable”: “fldChXehJna5hnHLE”,
          “referencedFieldIds”: [],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fldE8tlxN7Na0BOr6”,
        “name”: “Average Execution Time”
      },
      {
        “type”: “multipleLookupValues”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldzg5NokRBlP7iiC”,
          “fieldIdInLinkedTable”: “fldlOOAa3vmfM6axa”,
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fld0yb7B9c1POSmMX”,
        “name”: “Success Rate”
      },
      {
        “type”: “multipleLookupValues”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldzg5NokRBlP7iiC”,
          “fieldIdInLinkedTable”: “fldvvcOVKrK0lYro8”,
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fldT4ahHwk6tdCaWs”,
        “name”: “Error Count”
      },
      {
        “type”: “formula”,
        “options”: {
          “isValid”: true,
          “formula”: “CONCATENATE({fldGqoYEMLrqkTYuH}, \” – \”, {fldOtGm4lSvUIvvnQ})”,
          “referencedFieldIds”: [
            “fldGqoYEMLrqkTYuH”,
            “fldOtGm4lSvUIvvnQ”
          ],
          “result”: {
            “type”: “singleLineText”
          }
        },
        “id”: “fldnudwsPNseyrgEQ”,
        “name”: “Script Status Summary”
      },
      {
        “type”: “formula”,
        “options”: {
          “isValid”: true,
          “formula”: “DATETIME_DIFF(TODAY(), {fldk7OkzzaRQJ0dHv}, ‘days’)”,
          “referencedFieldIds”: [
            “fldk7OkzzaRQJ0dHv”
          ],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fldYIXgt1hH6lWDbH”,
        “name”: “Days Since Last Modified”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblpUYR0cC8wsrxMp”,
          “isReversed”: false,
          “prefersSingleRecordLink”: false,
          “inverseLinkFieldId”: “fld2xcsO4F5PoAeGO”
        },
        “id”: “fldfX2t8WpxdjU1RR”,
        “name”: “Automations”
      }
    ],
    “views”: [
      {
        “id”: “viwTWTpb0pYPDtq3n”,
        “name”: “Grid view”,
        “type”: “grid”
      }
    ]
  },
  {
    “id”: “tblXfPs6khqGmXp1R”,
    “name”: “PerformanceMetrics”,
    “primaryFieldId”: “fldqks0DdcmAdH7BU”,
    “fields”: [
      {
        “type”: “singleLineText”,
        “id”: “fldqks0DdcmAdH7BU”,
        “name”: “Workflow Name”
      },
      {
        “type”: “number”,
        “options”: {
          “precision”: 2
        },
        “id”: “fldChXehJna5hnHLE”,
        “name”: “Execution Time”
      },
      {
        “type”: “number”,
        “options”: {
          “precision”: 2
        },
        “id”: “fldlOOAa3vmfM6axa”,
        “name”: “Success Rate”
      },
      {
        “type”: “number”,
        “options”: {
          “precision”: 0
        },
        “id”: “fldvvcOVKrK0lYro8”,
        “name”: “Error Count”
      },
      {
        “type”: “date”,
        “options”: {
          “dateFormat”: {
            “name”: “local”,
            “format”: “l”
          }
        },
        “id”: “fldzDLgBQVeZaWbc6”,
        “name”: “Date Recorded”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tbl9uOSNFMyvQY3GE”,
          “isReversed”: false,
          “prefersSingleRecordLink”: true,
          “inverseLinkFieldId”: “fldzg5NokRBlP7iiC”
        },
        “id”: “fld7glKKURgHbPb75”,
        “name”: “Automation Script”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblzlQNEtFOFJ0mRi”,
          “isReversed”: false,
          “prefersSingleRecordLink”: true,
          “inverseLinkFieldId”: “fldYUYX0CrKgwUwPR”
        },
        “id”: “fldJtDniNxwCa2n0F”,
        “name”: “Test Result”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblkbmJM75Qs8SyUO”,
          “isReversed”: false,
          “prefersSingleRecordLink”: false,
          “inverseLinkFieldId”: “fldRMtArQcqP0Y1HQ”
        },
        “id”: “fldjbjPh6ZOmvG08y”,
        “name”: “Task Data Collected”
      },
      {
        “type”: “singleSelect”,
        “options”: {
          “choices”: [
            {
              “id”: “selrm2VyW5BvUT57z”,
              “name”: “Active”,
              “color”: “blueLight2”
            },
            {
              “id”: “selogPRz5XMxWNHXX”,
              “name”: “Inactive”,
              “color”: “cyanLight2”
            },
            {
              “id”: “selbhwj5x1U57d4W1”,
              “name”: “Pending”,
              “color”: “tealLight2”
            }
          ]
        },
        “id”: “fldTxjXmZUGn8KW2K”,
        “name”: “Automation Status”
      },
      {
        “type”: “rollup”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldjbjPh6ZOmvG08y”,
          “fieldIdInLinkedTable”: “fldIbg0O12vBWJ7wY”,
          “referencedFieldIds”: [],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fldSYyUfY7151bXRn”,
        “name”: “Average Task Duration”
      },
      {
        “type”: “count”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldjbjPh6ZOmvG08y”
        },
        “id”: “fldHIScefZXiNGmc2”,
        “name”: “Total Tasks”
      },
      {
        “type”: “formula”,
        “options”: {
          “isValid”: true,
          “formula”: “IF({fldHIScefZXiNGmc2} > 0, {fldvvcOVKrK0lYro8} / {fldHIScefZXiNGmc2}, 0)”,
          “referencedFieldIds”: [
            “fldHIScefZXiNGmc2”,
            “fldvvcOVKrK0lYro8”
          ],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fldFIXqTSc5hI13Zp”,
        “name”: “Error Rate”
      },
      {
        “type”: “multipleLookupValues”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fld7glKKURgHbPb75”,
          “fieldIdInLinkedTable”: “fldGqoYEMLrqkTYuH”,
          “result”: {
            “type”: “singleLineText”
          }
        },
        “id”: “fldL6TUwCJuT2NKRp”,
        “name”: “Script Status”
      },
      {
        “type”: “multipleLookupValues”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldJtDniNxwCa2n0F”,
          “fieldIdInLinkedTable”: “fldJTUDNzm97xWETS”,
          “result”: {
            “type”: “singleLineText”
          }
        },
        “id”: “fldagWC3nlePcWH0R”,
        “name”: “Test Pass Rate”
      },
      {
        “type”: “formula”,
        “options”: {
          “isValid”: true,
          “formula”: “IF({fldChXehJna5hnHLE} > 0, {fldlOOAa3vmfM6axa} / {fldChXehJna5hnHLE}, 0)”,
          “referencedFieldIds”: [
            “fldChXehJna5hnHLE”,
            “fldlOOAa3vmfM6axa”
          ],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fldsy66rQYJxAGNqM”,
        “name”: “Automation Efficiency”
      },
      {
        “type”: “multipleLookupValues”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldJtDniNxwCa2n0F”,
          “fieldIdInLinkedTable”: “fldjLtsIUDDEStmoj”,
          “result”: {
            “type”: “date”,
            “options”: {
              “dateFormat”: {
                “name”: “us”,
                “format”: “M/D/YYYY”
              }
            }
          }
        },
        “id”: “fldtqgBdhtS5u6Fcy”,
        “name”: “Last Test Date”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblpUYR0cC8wsrxMp”,
          “isReversed”: false,
          “prefersSingleRecordLink”: false,
          “inverseLinkFieldId”: “fldynOvosb0WIHccg”
        },
        “id”: “fldla8YmS0aL0xCe9”,
        “name”: “Automations”
      }
    ],
    “views”: [
      {
        “id”: “viwby5fFuc5NJ0Ylm”,
        “name”: “Grid view”,
        “type”: “grid”
      }
    ]
  },
  {
    “id”: “tblkbmJM75Qs8SyUO”,
    “name”: “TaskData”,
    “primaryFieldId”: “fldEwhCps8mPK84gb”,
    “fields”: [
      {
        “type”: “singleLineText”,
        “id”: “fldEwhCps8mPK84gb”,
        “name”: “Task ID”
      },
      {
        “type”: “singleLineText”,
        “id”: “fldmKwah5glKaDJBA”,
        “name”: “Task Name”
      },
      {
        “type”: “date”,
        “options”: {
          “dateFormat”: {
            “name”: “local”,
            “format”: “l”
          }
        },
        “id”: “fld0IdhpLQ2B5hy9g”,
        “name”: “Execution Date”
      },
      {
        “type”: “number”,
        “options”: {
          “precision”: 0
        },
        “id”: “fldIbg0O12vBWJ7wY”,
        “name”: “Duration (Minutes)”
      },
      {
        “type”: “singleSelect”,
        “options”: {
          “choices”: [
            {
              “id”: “selPMI1conagUkQJh”,
              “name”: “Pending”,
              “color”: “blueLight2”
            },
            {
              “id”: “selD1eZLdzrMM3WuC”,
              “name”: “In Progress”,
              “color”: “cyanLight2”
            },
            {
              “id”: “sell117fmXiWjYq9A”,
              “name”: “Completed”,
              “color”: “tealLight2”
            },
            {
              “id”: “seleKZXMZx46HJd9V”,
              “name”: “Failed”,
              “color”: “greenLight2”
            }
          ]
        },
        “id”: “fldPj1tUZHJTGZTjZ”,
        “name”: “Status”
      },
      {
        “type”: “singleLineText”,
        “id”: “fldTNtbY1esva3d9T”,
        “name”: “Assigned To”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tbl9uOSNFMyvQY3GE”,
          “isReversed”: false,
          “prefersSingleRecordLink”: true,
          “inverseLinkFieldId”: “fldIptEJ1uEhSlvIc”
        },
        “id”: “fld43NvfzjiopAoT8”,
        “name”: “Automation Script”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblXfPs6khqGmXp1R”,
          “isReversed”: false,
          “prefersSingleRecordLink”: true,
          “inverseLinkFieldId”: “fldjbjPh6ZOmvG08y”
        },
        “id”: “fldRMtArQcqP0Y1HQ”,
        “name”: “Performance Metrics”
      },
      {
        “type”: “multilineText”,
        “id”: “fldVstYXDaxP1TTFa”,
        “name”: “Notes”
      },
      {
        “type”: “multipleAttachments”,
        “options”: {
          “isReversed”: true
        },
        “id”: “fldw6oyk27msmpY82”,
        “name”: “Attachments”
      },
      {
        “type”: “rollup”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldRMtArQcqP0Y1HQ”,
          “fieldIdInLinkedTable”: “fldChXehJna5hnHLE”,
          “referencedFieldIds”: [],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fld3ZUwLHhGAHYufT”,
        “name”: “Total Execution Time”
      },
      {
        “type”: “rollup”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldRMtArQcqP0Y1HQ”,
          “fieldIdInLinkedTable”: “fldlOOAa3vmfM6axa”,
          “referencedFieldIds”: [],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fldZX7R2bwDBTrDwJ”,
        “name”: “Average Success Rate”
      },
      {
        “type”: “rollup”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldRMtArQcqP0Y1HQ”,
          “fieldIdInLinkedTable”: “fldvvcOVKrK0lYro8”,
          “referencedFieldIds”: [],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fld8nRE8hYOH31MBe”,
        “name”: “Total Error Count”
      },
      {
        “type”: “formula”,
        “options”: {
          “isValid”: true,
          “formula”: “IF({fldPj1tUZHJTGZTjZ} = ‘Completed’, ‘Yes’, ‘No’)”,
          “referencedFieldIds”: [
            “fldPj1tUZHJTGZTjZ”
          ],
          “result”: {
            “type”: “singleLineText”
          }
        },
        “id”: “fldoDg8GotBAeOthm”,
        “name”: “Task Completion Status”
      },
      {
        “type”: “multipleLookupValues”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldEw4nfdPuW32ciR”,
          “fieldIdInLinkedTable”: “fld4SHGX8YARleMcD”,
          “result”: {
            “type”: “singleLineText”
          }
        },
        “id”: “fldMYr6Puj9PQJMGl”,
        “name”: “Related Automation Name”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblpUYR0cC8wsrxMp”,
          “isReversed”: false,
          “prefersSingleRecordLink”: false,
          “inverseLinkFieldId”: “fldhOO2xJv5Xvd3Tn”
        },
        “id”: “fldEw4nfdPuW32ciR”,
        “name”: “Automations”
      },
      {
        “type”: “multipleLookupValues”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fld43NvfzjiopAoT8”,
          “fieldIdInLinkedTable”: “fldOtGm4lSvUIvvnQ”,
          “result”: {
            “type”: “singleLineText”
          }
        },
        “id”: “fldzBXapPcelfaTFT”,
        “name”: “Script Version”
      },
      {
        “type”: “formula”,
        “options”: {
          “isValid”: true,
          “formula”: “DATETIME_DIFF(TODAY(), {fld0IdhpLQ2B5hy9g}, ‘days’)”,
          “referencedFieldIds”: [
            “fld0IdhpLQ2B5hy9g”
          ],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fld3kBOMGjRQeJuTD”,
        “name”: “Days Since Execution”
      }
    ],
    “views”: [
      {
        “id”: “viwlV299uXWkz6gYL”,
        “name”: “Grid view”,
        “type”: “grid”
      }
    ]
  },
  {
    “id”: “tblzlQNEtFOFJ0mRi”,
    “name”: “TestResults”,
    “primaryFieldId”: “fldiQhlLQVjbmgYTd”,
    “fields”: [
      {
        “type”: “singleLineText”,
        “id”: “fldiQhlLQVjbmgYTd”,
        “name”: “Test Name”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tbl9uOSNFMyvQY3GE”,
          “isReversed”: false,
          “prefersSingleRecordLink”: true,
          “inverseLinkFieldId”: “fldvjyJqW13bflJH6”
        },
        “id”: “fldkymOXhHiooZY4H”,
        “name”: “Script Under Test”
      },
      {
        “type”: “date”,
        “options”: {
          “dateFormat”: {
            “name”: “local”,
            “format”: “l”
          }
        },
        “id”: “fldjLtsIUDDEStmoj”,
        “name”: “Test Date”
      },
      {
        “type”: “singleLineText”,
        “id”: “fldyFnW6GN9Qmj7Xc”,
        “name”: “Tester Name”
      },
      {
        “type”: “singleSelect”,
        “options”: {
          “choices”: [
            {
              “id”: “selCF2ShsW2QPhj7H”,
              “name”: “Pass”,
              “color”: “blueLight2”
            },
            {
              “id”: “selB1giKOpZ5KUc3z”,
              “name”: “Fail”,
              “color”: “cyanLight2”
            },
            {
              “id”: “selKYl3LAtuIXMHUs”,
              “name”: “Inconclusive”,
              “color”: “tealLight2”
            }
          ]
        },
        “id”: “fldJTUDNzm97xWETS”,
        “name”: “Test Result”
      },
      {
        “type”: “multilineText”,
        “id”: “fldZPoSeUy0b59dPl”,
        “name”: “Comments”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblXfPs6khqGmXp1R”,
          “isReversed”: false,
          “prefersSingleRecordLink”: false,
          “inverseLinkFieldId”: “fldJtDniNxwCa2n0F”
        },
        “id”: “fldYUYX0CrKgwUwPR”,
        “name”: “Related Performance Metrics”
      },
      {
        “type”: “multipleAttachments”,
        “options”: {
          “isReversed”: true
        },
        “id”: “fldcC4gh4t27TKaT2”,
        “name”: “Attachments”
      },
      {
        “type”: “count”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldYUYX0CrKgwUwPR”
        },
        “id”: “fldist4pUFV8Vg8vh”,
        “name”: “Total Related Metrics”
      },
      {
        “type”: “rollup”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldYUYX0CrKgwUwPR”,
          “fieldIdInLinkedTable”: “fldChXehJna5hnHLE”,
          “referencedFieldIds”: [],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fldGr1QNWDy6X1q1C”,
        “name”: “Average Execution Time”
      },
      {
        “type”: “rollup”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldYUYX0CrKgwUwPR”,
          “fieldIdInLinkedTable”: “fldlOOAa3vmfM6axa”,
          “referencedFieldIds”: [],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fldfscAlCr8V2e4ld”,
        “name”: “Success Rate Summary”
      },
      {
        “type”: “rollup”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldYUYX0CrKgwUwPR”,
          “fieldIdInLinkedTable”: “fldvvcOVKrK0lYro8”,
          “referencedFieldIds”: [],
          “result”: {
            “type”: “number”,
            “options”: {
              “precision”: 0
            }
          }
        },
        “id”: “fldl6YmKynPybC7ie”,
        “name”: “Error Count Summary”
      },
      {
        “type”: “multipleLookupValues”,
        “options”: {
          “isValid”: true,
          “recordLinkFieldId”: “fldYUYX0CrKgwUwPR”,
          “fieldIdInLinkedTable”: “fldTxjXmZUGn8KW2K”,
          “result”: {
            “type”: “singleLineText”
          }
        },
        “id”: “flddZtGtQgppO5Usd”,
        “name”: “Automation Status Overview”
      },
      {
        “type”: “formula”,
        “options”: {
          “isValid”: true,
          “formula”: “IF({fldJTUDNzm97xWETS} = ‘Pass’, ‘Successful’, IF({fldJTUDNzm97xWETS} = ‘Fail’, ‘Needs Improvement’, ‘Review Required’))”,
          “referencedFieldIds”: [
            “fldJTUDNzm97xWETS”
          ],
          “result”: {
            “type”: “singleLineText”
          }
        },
        “id”: “flda1lpoQRxOTfAYi”,
        “name”: “Test Result Summary”
      },
      {
        “type”: “multipleRecordLinks”,
        “options”: {
          “linkedTableId”: “tblpUYR0cC8wsrxMp”,
          “isReversed”: false,
          “prefersSingleRecordLink”: false,
          “inverseLinkFieldId”: “fldJsazUK7hTDU7Sh”
        },
        “id”: “fldu6RbzOk0JvsGRj”,
        “name”: “Automations”
      }
    ],
    “views”: [
      {
        “id”: “viwOpBoKFroOnG1e9”,
        “name”: “Grid view”,
        “type”: “grid”
      }
    ]
  }
]

Copy

[
  {
    "id": "tblpUYR0cC8wsrxMp",
    "name": "Automations",
    "primaryFieldId": "fld4SHGX8YARleMcD",
    "fields": [
      {
        "type": "singleLineText",
        "id": "fld4SHGX8YARleMcD",
        "name": "Automation Name"
      },
      {
        "type": "multilineText",
        "id": "fldP7anb8dszEdnBU",
        "name": "Description"
      },
      {
        "type": "date",
        "options": {
          "dateFormat": {
            "name": "local",
            "format": "l"
          }
        },
        "id": "fld7LuI8utyH8VSm6",
        "name": "Creation Date"
      },
      {
        "type": "date",
        "options": {
          "dateFormat": {
            "name": "local",
            "format": "l"
          }
        },
        "id": "fldRTyFBldy8c77xU",
        "name": "Last Modified Date"
      },
      {
        "type": "singleSelect",
        "options": {
          "choices": [
            {
              "id": "seliJOUzjQjHrw2th",
              "name": "Active",
              "color": "blueLight2"
            },
            {
              "id": "selc9840CILWeYuUe",
              "name": "Inactive",
              "color": "cyanLight2"
            },
            {
              "id": "selVIFLvsLYgBoKVu",
              "name": "Pending",
              "color": "tealLight2"
            },
            {
              "id": "sel9Z8AEeDicwiPEv",
              "name": "Archived",
              "color": "greenLight2"
            }
          ]
        },
        "id": "fldoKq3ypcOCNSdQx",
        "name": "Status"
      },
      {
        "type": "singleLineText",
        "id": "fldU2797U8rIOiQLD",
        "name": "Owner"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblXfPs6khqGmXp1R",
          "isReversed": false,
          "prefersSingleRecordLink": false,
          "inverseLinkFieldId": "fldla8YmS0aL0xCe9"
        },
        "id": "fldynOvosb0WIHccg",
        "name": "Related Performance Metrics"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblkbmJM75Qs8SyUO",
          "isReversed": false,
          "prefersSingleRecordLink": false,
          "inverseLinkFieldId": "fldEw4nfdPuW32ciR"
        },
        "id": "fldhOO2xJv5Xvd3Tn",
        "name": "Associated Task Data"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tbl9uOSNFMyvQY3GE",
          "isReversed": false,
          "prefersSingleRecordLink": false,
          "inverseLinkFieldId": "fldfX2t8WpxdjU1RR"
        },
        "id": "fld2xcsO4F5PoAeGO",
        "name": "Linked Scripts"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblzlQNEtFOFJ0mRi",
          "isReversed": false,
          "prefersSingleRecordLink": false,
          "inverseLinkFieldId": "fldu6RbzOk0JvsGRj"
        },
        "id": "fldJsazUK7hTDU7Sh",
        "name": "Test Results"
      },
      {
        "type": "rollup",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldynOvosb0WIHccg",
          "fieldIdInLinkedTable": "fldChXehJna5hnHLE",
          "referencedFieldIds": [],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fldSCZgMZgPmuVBNy",
        "name": "Total Execution Time"
      },
      {
        "type": "rollup",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldynOvosb0WIHccg",
          "fieldIdInLinkedTable": "fldlOOAa3vmfM6axa",
          "referencedFieldIds": [],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fld7yo2Kit4Kwa5Oj",
        "name": "Average Success Rate"
      },
      {
        "type": "rollup",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldynOvosb0WIHccg",
          "fieldIdInLinkedTable": "fldvvcOVKrK0lYro8",
          "referencedFieldIds": [],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fld4JjKnr1rxfzRhQ",
        "name": "Total Error Count"
      }
    ],
    "views": [
      {
        "id": "viwWHdR2wfZ7zknY5",
        "name": "Grid view",
        "type": "grid"
      }
    ]
  },
  {
    "id": "tbl9uOSNFMyvQY3GE",
    "name": "Scripts",
    "primaryFieldId": "fld5arY6icZ2OVJPA",
    "fields": [
      {
        "type": "singleLineText",
        "id": "fld5arY6icZ2OVJPA",
        "name": "Script Name"
      },
      {
        "type": "multilineText",
        "id": "fldxcpYZgyQo2widX",
        "name": "Description"
      },
      {
        "type": "date",
        "options": {
          "dateFormat": {
            "name": "local",
            "format": "l"
          }
        },
        "id": "fldhvAhSmy5bDknmZ",
        "name": "Creation Date"
      },
      {
        "type": "date",
        "options": {
          "dateFormat": {
            "name": "local",
            "format": "l"
          }
        },
        "id": "fldk7OkzzaRQJ0dHv",
        "name": "Last Modified"
      },
      {
        "type": "singleLineText",
        "id": "fldOtGm4lSvUIvvnQ",
        "name": "Version"
      },
      {
        "type": "singleLineText",
        "id": "fldNdtxyEA9D1J3XF",
        "name": "Author"
      },
      {
        "type": "singleSelect",
        "options": {
          "choices": [
            {
              "id": "selSKZIaTXDtLAWmB",
              "name": "Draft",
              "color": "blueLight2"
            },
            {
              "id": "selexLuqfEROpoZeq",
              "name": "In Review",
              "color": "cyanLight2"
            },
            {
              "id": "selR0ZcelUrWXM1UJ",
              "name": "Approved",
              "color": "tealLight2"
            },
            {
              "id": "selME7OUQGoZWXx3m",
              "name": "Rejected",
              "color": "greenLight2"
            }
          ]
        },
        "id": "fldGqoYEMLrqkTYuH",
        "name": "Status"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblkbmJM75Qs8SyUO",
          "isReversed": false,
          "prefersSingleRecordLink": false,
          "inverseLinkFieldId": "fld43NvfzjiopAoT8"
        },
        "id": "fldIptEJ1uEhSlvIc",
        "name": "Associated Tasks"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblzlQNEtFOFJ0mRi",
          "isReversed": false,
          "prefersSingleRecordLink": false,
          "inverseLinkFieldId": "fldkymOXhHiooZY4H"
        },
        "id": "fldvjyJqW13bflJH6",
        "name": "Test Results"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblXfPs6khqGmXp1R",
          "isReversed": false,
          "prefersSingleRecordLink": true,
          "inverseLinkFieldId": "fld7glKKURgHbPb75"
        },
        "id": "fldzg5NokRBlP7iiC",
        "name": "Performance Metrics"
      },
      {
        "type": "multipleAttachments",
        "options": {
          "isReversed": true
        },
        "id": "fldIhz5le8zEQkSYm",
        "name": "Script File"
      },
      {
        "type": "count",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldIptEJ1uEhSlvIc"
        },
        "id": "fld6d5gMU3vGNHWGK",
        "name": "Total Associated Tasks"
      },
      {
        "type": "count",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldvjyJqW13bflJH6"
        },
        "id": "fldLw0WCyVQpr58Bv",
        "name": "Total Test Results"
      },
      {
        "type": "rollup",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldzg5NokRBlP7iiC",
          "fieldIdInLinkedTable": "fldChXehJna5hnHLE",
          "referencedFieldIds": [],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fldE8tlxN7Na0BOr6",
        "name": "Average Execution Time"
      },
      {
        "type": "multipleLookupValues",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldzg5NokRBlP7iiC",
          "fieldIdInLinkedTable": "fldlOOAa3vmfM6axa",
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fld0yb7B9c1POSmMX",
        "name": "Success Rate"
      },
      {
        "type": "multipleLookupValues",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldzg5NokRBlP7iiC",
          "fieldIdInLinkedTable": "fldvvcOVKrK0lYro8",
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fldT4ahHwk6tdCaWs",
        "name": "Error Count"
      },
      {
        "type": "formula",
        "options": {
          "isValid": true,
          "formula": "CONCATENATE({fldGqoYEMLrqkTYuH}, \" - \", {fldOtGm4lSvUIvvnQ})",
          "referencedFieldIds": [
            "fldGqoYEMLrqkTYuH",
            "fldOtGm4lSvUIvvnQ"
          ],
          "result": {
            "type": "singleLineText"
          }
        },
        "id": "fldnudwsPNseyrgEQ",
        "name": "Script Status Summary"
      },
      {
        "type": "formula",
        "options": {
          "isValid": true,
          "formula": "DATETIME_DIFF(TODAY(), {fldk7OkzzaRQJ0dHv}, 'days')",
          "referencedFieldIds": [
            "fldk7OkzzaRQJ0dHv"
          ],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fldYIXgt1hH6lWDbH",
        "name": "Days Since Last Modified"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblpUYR0cC8wsrxMp",
          "isReversed": false,
          "prefersSingleRecordLink": false,
          "inverseLinkFieldId": "fld2xcsO4F5PoAeGO"
        },
        "id": "fldfX2t8WpxdjU1RR",
        "name": "Automations"
      }
    ],
    "views": [
      {
        "id": "viwTWTpb0pYPDtq3n",
        "name": "Grid view",
        "type": "grid"
      }
    ]
  },
  {
    "id": "tblXfPs6khqGmXp1R",
    "name": "PerformanceMetrics",
    "primaryFieldId": "fldqks0DdcmAdH7BU",
    "fields": [
      {
        "type": "singleLineText",
        "id": "fldqks0DdcmAdH7BU",
        "name": "Workflow Name"
      },
      {
        "type": "number",
        "options": {
          "precision": 2
        },
        "id": "fldChXehJna5hnHLE",
        "name": "Execution Time"
      },
      {
        "type": "number",
        "options": {
          "precision": 2
        },
        "id": "fldlOOAa3vmfM6axa",
        "name": "Success Rate"
      },
      {
        "type": "number",
        "options": {
          "precision": 0
        },
        "id": "fldvvcOVKrK0lYro8",
        "name": "Error Count"
      },
      {
        "type": "date",
        "options": {
          "dateFormat": {
            "name": "local",
            "format": "l"
          }
        },
        "id": "fldzDLgBQVeZaWbc6",
        "name": "Date Recorded"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tbl9uOSNFMyvQY3GE",
          "isReversed": false,
          "prefersSingleRecordLink": true,
          "inverseLinkFieldId": "fldzg5NokRBlP7iiC"
        },
        "id": "fld7glKKURgHbPb75",
        "name": "Automation Script"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblzlQNEtFOFJ0mRi",
          "isReversed": false,
          "prefersSingleRecordLink": true,
          "inverseLinkFieldId": "fldYUYX0CrKgwUwPR"
        },
        "id": "fldJtDniNxwCa2n0F",
        "name": "Test Result"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblkbmJM75Qs8SyUO",
          "isReversed": false,
          "prefersSingleRecordLink": false,
          "inverseLinkFieldId": "fldRMtArQcqP0Y1HQ"
        },
        "id": "fldjbjPh6ZOmvG08y",
        "name": "Task Data Collected"
      },
      {
        "type": "singleSelect",
        "options": {
          "choices": [
            {
              "id": "selrm2VyW5BvUT57z",
              "name": "Active",
              "color": "blueLight2"
            },
            {
              "id": "selogPRz5XMxWNHXX",
              "name": "Inactive",
              "color": "cyanLight2"
            },
            {
              "id": "selbhwj5x1U57d4W1",
              "name": "Pending",
              "color": "tealLight2"
            }
          ]
        },
        "id": "fldTxjXmZUGn8KW2K",
        "name": "Automation Status"
      },
      {
        "type": "rollup",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldjbjPh6ZOmvG08y",
          "fieldIdInLinkedTable": "fldIbg0O12vBWJ7wY",
          "referencedFieldIds": [],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fldSYyUfY7151bXRn",
        "name": "Average Task Duration"
      },
      {
        "type": "count",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldjbjPh6ZOmvG08y"
        },
        "id": "fldHIScefZXiNGmc2",
        "name": "Total Tasks"
      },
      {
        "type": "formula",
        "options": {
          "isValid": true,
          "formula": "IF({fldHIScefZXiNGmc2} > 0, {fldvvcOVKrK0lYro8} / {fldHIScefZXiNGmc2}, 0)",
          "referencedFieldIds": [
            "fldHIScefZXiNGmc2",
            "fldvvcOVKrK0lYro8"
          ],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fldFIXqTSc5hI13Zp",
        "name": "Error Rate"
      },
      {
        "type": "multipleLookupValues",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fld7glKKURgHbPb75",
          "fieldIdInLinkedTable": "fldGqoYEMLrqkTYuH",
          "result": {
            "type": "singleLineText"
          }
        },
        "id": "fldL6TUwCJuT2NKRp",
        "name": "Script Status"
      },
      {
        "type": "multipleLookupValues",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldJtDniNxwCa2n0F",
          "fieldIdInLinkedTable": "fldJTUDNzm97xWETS",
          "result": {
            "type": "singleLineText"
          }
        },
        "id": "fldagWC3nlePcWH0R",
        "name": "Test Pass Rate"
      },
      {
        "type": "formula",
        "options": {
          "isValid": true,
          "formula": "IF({fldChXehJna5hnHLE} > 0, {fldlOOAa3vmfM6axa} / {fldChXehJna5hnHLE}, 0)",
          "referencedFieldIds": [
            "fldChXehJna5hnHLE",
            "fldlOOAa3vmfM6axa"
          ],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fldsy66rQYJxAGNqM",
        "name": "Automation Efficiency"
      },
      {
        "type": "multipleLookupValues",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldJtDniNxwCa2n0F",
          "fieldIdInLinkedTable": "fldjLtsIUDDEStmoj",
          "result": {
            "type": "date",
            "options": {
              "dateFormat": {
                "name": "us",
                "format": "M/D/YYYY"
              }
            }
          }
        },
        "id": "fldtqgBdhtS5u6Fcy",
        "name": "Last Test Date"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblpUYR0cC8wsrxMp",
          "isReversed": false,
          "prefersSingleRecordLink": false,
          "inverseLinkFieldId": "fldynOvosb0WIHccg"
        },
        "id": "fldla8YmS0aL0xCe9",
        "name": "Automations"
      }
    ],
    "views": [
      {
        "id": "viwby5fFuc5NJ0Ylm",
        "name": "Grid view",
        "type": "grid"
      }
    ]
  },
  {
    "id": "tblkbmJM75Qs8SyUO",
    "name": "TaskData",
    "primaryFieldId": "fldEwhCps8mPK84gb",
    "fields": [
      {
        "type": "singleLineText",
        "id": "fldEwhCps8mPK84gb",
        "name": "Task ID"
      },
      {
        "type": "singleLineText",
        "id": "fldmKwah5glKaDJBA",
        "name": "Task Name"
      },
      {
        "type": "date",
        "options": {
          "dateFormat": {
            "name": "local",
            "format": "l"
          }
        },
        "id": "fld0IdhpLQ2B5hy9g",
        "name": "Execution Date"
      },
      {
        "type": "number",
        "options": {
          "precision": 0
        },
        "id": "fldIbg0O12vBWJ7wY",
        "name": "Duration (Minutes)"
      },
      {
        "type": "singleSelect",
        "options": {
          "choices": [
            {
              "id": "selPMI1conagUkQJh",
              "name": "Pending",
              "color": "blueLight2"
            },
            {
              "id": "selD1eZLdzrMM3WuC",
              "name": "In Progress",
              "color": "cyanLight2"
            },
            {
              "id": "sell117fmXiWjYq9A",
              "name": "Completed",
              "color": "tealLight2"
            },
            {
              "id": "seleKZXMZx46HJd9V",
              "name": "Failed",
              "color": "greenLight2"
            }
          ]
        },
        "id": "fldPj1tUZHJTGZTjZ",
        "name": "Status"
      },
      {
        "type": "singleLineText",
        "id": "fldTNtbY1esva3d9T",
        "name": "Assigned To"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tbl9uOSNFMyvQY3GE",
          "isReversed": false,
          "prefersSingleRecordLink": true,
          "inverseLinkFieldId": "fldIptEJ1uEhSlvIc"
        },
        "id": "fld43NvfzjiopAoT8",
        "name": "Automation Script"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblXfPs6khqGmXp1R",
          "isReversed": false,
          "prefersSingleRecordLink": true,
          "inverseLinkFieldId": "fldjbjPh6ZOmvG08y"
        },
        "id": "fldRMtArQcqP0Y1HQ",
        "name": "Performance Metrics"
      },
      {
        "type": "multilineText",
        "id": "fldVstYXDaxP1TTFa",
        "name": "Notes"
      },
      {
        "type": "multipleAttachments",
        "options": {
          "isReversed": true
        },
        "id": "fldw6oyk27msmpY82",
        "name": "Attachments"
      },
      {
        "type": "rollup",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldRMtArQcqP0Y1HQ",
          "fieldIdInLinkedTable": "fldChXehJna5hnHLE",
          "referencedFieldIds": [],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fld3ZUwLHhGAHYufT",
        "name": "Total Execution Time"
      },
      {
        "type": "rollup",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldRMtArQcqP0Y1HQ",
          "fieldIdInLinkedTable": "fldlOOAa3vmfM6axa",
          "referencedFieldIds": [],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fldZX7R2bwDBTrDwJ",
        "name": "Average Success Rate"
      },
      {
        "type": "rollup",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldRMtArQcqP0Y1HQ",
          "fieldIdInLinkedTable": "fldvvcOVKrK0lYro8",
          "referencedFieldIds": [],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fld8nRE8hYOH31MBe",
        "name": "Total Error Count"
      },
      {
        "type": "formula",
        "options": {
          "isValid": true,
          "formula": "IF({fldPj1tUZHJTGZTjZ} = 'Completed', 'Yes', 'No')",
          "referencedFieldIds": [
            "fldPj1tUZHJTGZTjZ"
          ],
          "result": {
            "type": "singleLineText"
          }
        },
        "id": "fldoDg8GotBAeOthm",
        "name": "Task Completion Status"
      },
      {
        "type": "multipleLookupValues",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldEw4nfdPuW32ciR",
          "fieldIdInLinkedTable": "fld4SHGX8YARleMcD",
          "result": {
            "type": "singleLineText"
          }
        },
        "id": "fldMYr6Puj9PQJMGl",
        "name": "Related Automation Name"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblpUYR0cC8wsrxMp",
          "isReversed": false,
          "prefersSingleRecordLink": false,
          "inverseLinkFieldId": "fldhOO2xJv5Xvd3Tn"
        },
        "id": "fldEw4nfdPuW32ciR",
        "name": "Automations"
      },
      {
        "type": "multipleLookupValues",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fld43NvfzjiopAoT8",
          "fieldIdInLinkedTable": "fldOtGm4lSvUIvvnQ",
          "result": {
            "type": "singleLineText"
          }
        },
        "id": "fldzBXapPcelfaTFT",
        "name": "Script Version"
      },
      {
        "type": "formula",
        "options": {
          "isValid": true,
          "formula": "DATETIME_DIFF(TODAY(), {fld0IdhpLQ2B5hy9g}, 'days')",
          "referencedFieldIds": [
            "fld0IdhpLQ2B5hy9g"
          ],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fld3kBOMGjRQeJuTD",
        "name": "Days Since Execution"
      }
    ],
    "views": [
      {
        "id": "viwlV299uXWkz6gYL",
        "name": "Grid view",
        "type": "grid"
      }
    ]
  },
  {
    "id": "tblzlQNEtFOFJ0mRi",
    "name": "TestResults",
    "primaryFieldId": "fldiQhlLQVjbmgYTd",
    "fields": [
      {
        "type": "singleLineText",
        "id": "fldiQhlLQVjbmgYTd",
        "name": "Test Name"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tbl9uOSNFMyvQY3GE",
          "isReversed": false,
          "prefersSingleRecordLink": true,
          "inverseLinkFieldId": "fldvjyJqW13bflJH6"
        },
        "id": "fldkymOXhHiooZY4H",
        "name": "Script Under Test"
      },
      {
        "type": "date",
        "options": {
          "dateFormat": {
            "name": "local",
            "format": "l"
          }
        },
        "id": "fldjLtsIUDDEStmoj",
        "name": "Test Date"
      },
      {
        "type": "singleLineText",
        "id": "fldyFnW6GN9Qmj7Xc",
        "name": "Tester Name"
      },
      {
        "type": "singleSelect",
        "options": {
          "choices": [
            {
              "id": "selCF2ShsW2QPhj7H",
              "name": "Pass",
              "color": "blueLight2"
            },
            {
              "id": "selB1giKOpZ5KUc3z",
              "name": "Fail",
              "color": "cyanLight2"
            },
            {
              "id": "selKYl3LAtuIXMHUs",
              "name": "Inconclusive",
              "color": "tealLight2"
            }
          ]
        },
        "id": "fldJTUDNzm97xWETS",
        "name": "Test Result"
      },
      {
        "type": "multilineText",
        "id": "fldZPoSeUy0b59dPl",
        "name": "Comments"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblXfPs6khqGmXp1R",
          "isReversed": false,
          "prefersSingleRecordLink": false,
          "inverseLinkFieldId": "fldJtDniNxwCa2n0F"
        },
        "id": "fldYUYX0CrKgwUwPR",
        "name": "Related Performance Metrics"
      },
      {
        "type": "multipleAttachments",
        "options": {
          "isReversed": true
        },
        "id": "fldcC4gh4t27TKaT2",
        "name": "Attachments"
      },
      {
        "type": "count",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldYUYX0CrKgwUwPR"
        },
        "id": "fldist4pUFV8Vg8vh",
        "name": "Total Related Metrics"
      },
      {
        "type": "rollup",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldYUYX0CrKgwUwPR",
          "fieldIdInLinkedTable": "fldChXehJna5hnHLE",
          "referencedFieldIds": [],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fldGr1QNWDy6X1q1C",
        "name": "Average Execution Time"
      },
      {
        "type": "rollup",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldYUYX0CrKgwUwPR",
          "fieldIdInLinkedTable": "fldlOOAa3vmfM6axa",
          "referencedFieldIds": [],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fldfscAlCr8V2e4ld",
        "name": "Success Rate Summary"
      },
      {
        "type": "rollup",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldYUYX0CrKgwUwPR",
          "fieldIdInLinkedTable": "fldvvcOVKrK0lYro8",
          "referencedFieldIds": [],
          "result": {
            "type": "number",
            "options": {
              "precision": 0
            }
          }
        },
        "id": "fldl6YmKynPybC7ie",
        "name": "Error Count Summary"
      },
      {
        "type": "multipleLookupValues",
        "options": {
          "isValid": true,
          "recordLinkFieldId": "fldYUYX0CrKgwUwPR",
          "fieldIdInLinkedTable": "fldTxjXmZUGn8KW2K",
          "result": {
            "type": "singleLineText"
          }
        },
        "id": "flddZtGtQgppO5Usd",
        "name": "Automation Status Overview"
      },
      {
        "type": "formula",
        "options": {
          "isValid": true,
          "formula": "IF({fldJTUDNzm97xWETS} = 'Pass', 'Successful', IF({fldJTUDNzm97xWETS} = 'Fail', 'Needs Improvement', 'Review Required'))",
          "referencedFieldIds": [
            "fldJTUDNzm97xWETS"
          ],
          "result": {
            "type": "singleLineText"
          }
        },
        "id": "flda1lpoQRxOTfAYi",
        "name": "Test Result Summary"
      },
      {
        "type": "multipleRecordLinks",
        "options": {
          "linkedTableId": "tblpUYR0cC8wsrxMp",
          "isReversed": false,
          "prefersSingleRecordLink": false,
          "inverseLinkFieldId": "fldJsazUK7hTDU7Sh"
        },
        "id": "fldu6RbzOk0JvsGRj",
        "name": "Automations"
      }
    ],
    "views": [
      {
        "id": "viwOpBoKFroOnG1e9",
        "name": "Grid view",
        "type": "grid"
      }
    ]
  }
]

Expand

TABLE Copy Link

Create Table Copy Link

This Method is used to create a new table and returns the schema for the newly created table.

Refer to field types for supported field types, the write format for field options, and other specifics for certain field types. Supported field types have a write format shown.

⚠️ Note:
● At least one field must be specified.
● The first field in the fields array will be used as the table’s primary field and must be a supported primary field type.
● Cannot duplicate field name. Fields must have case-insensitive unique names within the table.

A default grid view will be created with all fields visible.

See Airtable Create table API reference.

Configuration Table:

Input Options (Field Mapping):

Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
Default Value: Select value from a defined list or specify a fixed attribute.
Manual input: Set a custom value by using the Lightning Bold feature.

Name*	Create Table
Connection*	Select your connection or create one.

MAP FIELDS

Base ID*:

Select the Airtable base.

Table ID*:

Name the new table.

Table Description:

The description for the table (optional). If present, must be a non-empty string no longer than 20,000 characters.

Fields*:

Field types and cell values to create.

+Element +Map ↓
(Add a repeating group of fields or Map it from an array. See Field Mapping).

Element 1: Represents the first group of columns.

Each group will be added to your table one after another.

+ Add Field ↓
List of available fields:

Single line text:

Name or describe the column.

A column of single line of text. Limited to 100,000 characters.

Long text:

Name or describe the column.

Multiple lines of text, which may contain “mention tokens”. Limited to 100,000 characters.

Rich text:

Name or describe the column.

Long text (with rich text formatting enabled).

Learn more about using Markdown in long text’s rich text formatting API.

Attachment:

Name or describe the column.

Attachments allow you to add images, documents, or other files which can then be viewed or downloaded.

Checkbox:

Name*:

Name or describe the column.

Color*:

Select the icon color.

Icon*:

Select the icon.

Multiple select:

Column where each field allows the selection of multiple choices.

Name*:

Name or describe the column.

Choices*: +Element +Map ↓

Element 1: Represents the first choice.

Name*:

Enter the first choice.

+ Add Field ↓

Color: Define the choice color.

+ Add Field ↓

Color: Optional when the select field is configured to not use colors.

Single select:

Column where each field allows the selection of a single choice.

Name*:

Name or describe the column.

Choices*: +Element +Map ↓

Element 1: Represents the first choice.

Name*:

Enter the first choice.

+ Add Field ↓

Color: Define the choice color.

+ Add Field ↓

Color: Optional when the select field is configured to not use colors.

User:

Name or describe the column.

Column where each field allows the selection of one user.

Multiple Users:

Name or describe the column.

Column where each field allows the selection of multiple users.

Date:

Name*:

Name or describe the column.

Date format*:

Format*: Select the date format

l - LL - M/D/YYYY - D/M/YYYY - YYYY-MM-DD

Name*: Select the corresponding format name. Wrong matching will return error.

(l for Local, LL for Friendly, M/D/YYYY for US, D/M/YYYY for European, YYYY-MM-DD for ISO)

Date and Time:

Name*:

Name or describe the column.

Date format*:

Format*: Select the date format.

l - LL - M/D/YYYY - D/M/YYYY - YYYY-MM-DD

Name*: Select the corresponding format name. Wrong matching will return error.

(l for Local, LL for Friendly, M/D/YYYY for US, D/M/YYYY for European, YYYY-MM-DD for ISO)

Time format*:

Format*: Select the time format.

h:mma – HH:mm

Name*: Select the corresponding format name. Wrong matching will return error.

(h:mma for 12hour and HH:mm for 24hour)

Phone Number:

Name or describe the column.

Column for phone number, e.g. “(415) 555-9876”.

Email:

Name or describe the column.

Column of valid emails.

URL:

Name or describe the column.

A valid URL (e.g. wiresk.com or https://app.wiresk.com/en/register).

Number:

Name*:

Name or describe the column.

Precision*:

Indicates the number of digits shown to the right of the decimal point for this field. (0-8 inclusive)

Currency:

Name*:

Name or describe the column.

Precision*:

Indicates the number of digits shown to the right of the decimal point for this field. (0-7 inclusive)

Symbol*:

Currency symbol to use.

Percent:

Decimal number representing a percentage value. For example, the underlying cell value for 12.3% is 0.123.

Name*:

Name or describe the column.

Precision*:

Indicates the number of digits shown to the right of the decimal point for this field. (0-8 inclusive)

Rating:

A positive integer (e.g. “3 stars” is 3). A rating cannot be 0.

Bases on a free or plus plan are limited to using the star icon and yellow Bright color.

Name*:

Name or describe the column.

Icon*:

Select the icon used to display the rating.

star - heart - thumbs Up - flag - dot

Color*:

Select the color of the displayed icon.

Max*:

The maximum value for the rating, from 1 to 10 inclusive.

Duration:

An integer representing number of seconds.

Name*:

Name or describe the column.

Duration Format*:

Select the format:

h:mm
h:mm:ss
h:mm:ss.S
h:mm:ss.SS
h:mm:ss.SSS

Barcode:

Name or describe the Barcode column.

Use the Airtable iOS or Android app to scan barcodes.

Link to another record:

Creating “multiple Record Links” fields is supported but updating options for existing “multipleRecordLinks” fields is not supported.

Name:

Name or describe the column.

Linked Table ID:

The ID of the table this field links to.

View ID for record selection:

The ID of the view in the linked table to use when showing a list of records to select from.

(*) required field

Response sample

{
  “id”: “tblG31otxPI7hXSJj”,
  “name”: “add via create table”,
  “primaryFieldId”: “fldWg3rZwG5Z11Rjw”,
  “fields”: [
    {
      “type”: “singleLineText”,
      “id”: “fldWg3rZwG5Z11Rjw”,
      “name”: “Name”
    },
    {
      “type”: “multilineText”,
      “id”: “fldx5bLDZxEmJVCvB”,
      “name”: “Long text”
    },
    {
      “type”: “richText”,
      “id”: “fldAjyAmHLSZPcE20”,
      “name”: “Rich text”
    },
    {
      “type”: “multipleAttachments”,
      “options”: {
        “isReversed”: false
      },
      “id”: “fldvNaBgAdMEdmScU”,
      “name”: “attachment”
    },
    {
      “type”: “checkbox”,
      “options”: {
        “icon”: “xCheckbox”,
        “color”: “greenBright”
      },
      “id”: “fldG6OUaDgTYWBpuI”,
      “name”: “done”
    },
    {
      “type”: “multipleSelects”,
      “options”: {
        “choices”: [
          {
            “id”: “selBZBBDOObd7Kwbr”,
            “name”: “choice 1”,
            “color”: “blueLight2”
          },
          {
            “id”: “seltv3fTc2ljH35Um”,
            “name”: “choice 2”,
            “color”: “grayLight2”
          }
        ]
      },
      “id”: “fld1Lb14fPXlTeZmp”,
      “name”: “multiple select”
    },
    {
      “type”: “singleSelect”,
      “options”: {
        “choices”: [
          {
            “id”: “selnXEEqxnNnNF07Y”,
            “name”: “choice 1”,
            “color”: “cyanLight2”
          },
          {
            “id”: “selwhALx2DogtzJ4C”,
            “name”: “choice 2”,
            “color”: “greenLight2”
          }
        ]
      },
      “id”: “fldL8bNGH40AEnNBL”,
      “name”: “single select”
    },
    {
      “type”: “singleCollaborator”,
      “id”: “fldgoSaVqE0kBkTaV”,
      “name”: “user”
    },
    {
      “type”: “multipleCollaborators”,
      “id”: “fldNIn7Ja3okWEpMt”,
      “name”: “multiple users”
    },
    {
      “type”: “date”,
      “options”: {
        “dateFormat”: {
          “name”: “friendly”,
          “format”: “LL”
        }
      },
      “id”: “fld95cx9HZWPXA8f7”,
      “name”: “date”
    },
    {
      “type”: “dateTime”,
      “options”: {
        “dateFormat”: {
          “name”: “friendly”,
          “format”: “LL”
        },
        “timeFormat”: {
          “name”: “24hour”,
          “format”: “HH:mm”
        },
        “timeZone”: “client”
      },
      “id”: “fld7IpiKnHP4ukEcp”,
      “name”: “Date and time”
    },
    {
      “type”: “phoneNumber”,
      “id”: “fldpT7mThyIsb2JhC”,
      “name”: “phone number”
    },
    {
      “type”: “email”,
      “id”: “fldMCVOK3bsKWp95G”,
      “name”: “email”
    },
    {
      “type”: “url”,
      “id”: “fldLnYGD1XdgDusRW”,
      “name”: “external Link”
    },
    {
      “type”: “number”,
      “options”: {
        “precision”: 2
      },
      “id”: “fld6zemXd0F1UvPxd”,
      “name”: “Number field”
    },
    {
      “type”: “currency”,
      “options”: {
        “precision”: 2,
        “symbol”: “$”
      },
      “id”: “fldfLFAboc87gb5zi”,
      “name”: “currency field”
    },
    {
      “type”: “percent”,
      “options”: {
        “precision”: 2
      },
      “id”: “fld10lbcK3AUwEa5q”,
      “name”: “Percentage”
    },
    {
      “type”: “rating”,
      “options”: {
        “icon”: “star”,
        “max”: 10,
        “color”: “yellowBright”
      },
      “id”: “fldjDdREWovK1WO9c”,
      “name”: “Rating”
    },
    {
      “type”: “duration”,
      “options”: {
        “durationFormat”: “h:mm”
      },
      “id”: “fldq3IViuOll9ISqy”,
      “name”: “Duration”
    },
    {
      “type”: “barcode”,
      “id”: “fldIZcm183zu56N3J”,
      “name”: “Barcode number”
    }
  ],
  “views”: [
    {
      “id”: “viw1lOv2GlRvbxQuo”,
      “name”: “Grid view”,
      “type”: “grid”
    }
  ]
}

Copy

{
  "id": "tblG31otxPI7hXSJj",
  "name": "add via create table",
  "primaryFieldId": "fldWg3rZwG5Z11Rjw",
  "fields": [
    {
      "type": "singleLineText",
      "id": "fldWg3rZwG5Z11Rjw",
      "name": "Name"
    },
    {
      "type": "multilineText",
      "id": "fldx5bLDZxEmJVCvB",
      "name": "Long text"
    },
    {
      "type": "richText",
      "id": "fldAjyAmHLSZPcE20",
      "name": "Rich text"
    },
    {
      "type": "multipleAttachments",
      "options": {
        "isReversed": false
      },
      "id": "fldvNaBgAdMEdmScU",
      "name": "attachment"
    },
    {
      "type": "checkbox",
      "options": {
        "icon": "xCheckbox",
        "color": "greenBright"
      },
      "id": "fldG6OUaDgTYWBpuI",
      "name": "done"
    },
    {
      "type": "multipleSelects",
      "options": {
        "choices": [
          {
            "id": "selBZBBDOObd7Kwbr",
            "name": "choice 1",
            "color": "blueLight2"
          },
          {
            "id": "seltv3fTc2ljH35Um",
            "name": "choice 2",
            "color": "grayLight2"
          }
        ]
      },
      "id": "fld1Lb14fPXlTeZmp",
      "name": "multiple select"
    },
    {
      "type": "singleSelect",
      "options": {
        "choices": [
          {
            "id": "selnXEEqxnNnNF07Y",
            "name": "choice 1",
            "color": "cyanLight2"
          },
          {
            "id": "selwhALx2DogtzJ4C",
            "name": "choice 2",
            "color": "greenLight2"
          }
        ]
      },
      "id": "fldL8bNGH40AEnNBL",
      "name": "single select"
    },
    {
      "type": "singleCollaborator",
      "id": "fldgoSaVqE0kBkTaV",
      "name": "user"
    },
    {
      "type": "multipleCollaborators",
      "id": "fldNIn7Ja3okWEpMt",
      "name": "multiple users"
    },
    {
      "type": "date",
      "options": {
        "dateFormat": {
          "name": "friendly",
          "format": "LL"
        }
      },
      "id": "fld95cx9HZWPXA8f7",
      "name": "date"
    },
    {
      "type": "dateTime",
      "options": {
        "dateFormat": {
          "name": "friendly",
          "format": "LL"
        },
        "timeFormat": {
          "name": "24hour",
          "format": "HH:mm"
        },
        "timeZone": "client"
      },
      "id": "fld7IpiKnHP4ukEcp",
      "name": "Date and time"
    },
    {
      "type": "phoneNumber",
      "id": "fldpT7mThyIsb2JhC",
      "name": "phone number"
    },
    {
      "type": "email",
      "id": "fldMCVOK3bsKWp95G",
      "name": "email"
    },
    {
      "type": "url",
      "id": "fldLnYGD1XdgDusRW",
      "name": "external Link"
    },
    {
      "type": "number",
      "options": {
        "precision": 2
      },
      "id": "fld6zemXd0F1UvPxd",
      "name": "Number field"
    },
    {
      "type": "currency",
      "options": {
        "precision": 2,
        "symbol": "$"
      },
      "id": "fldfLFAboc87gb5zi",
      "name": "currency field"
    },
    {
      "type": "percent",
      "options": {
        "precision": 2
      },
      "id": "fld10lbcK3AUwEa5q",
      "name": "Percentage"
    },
    {
      "type": "rating",
      "options": {
        "icon": "star",
        "max": 10,
        "color": "yellowBright"
      },
      "id": "fldjDdREWovK1WO9c",
      "name": "Rating"
    },
    {
      "type": "duration",
      "options": {
        "durationFormat": "h:mm"
      },
      "id": "fldq3IViuOll9ISqy",
      "name": "Duration"
    },
    {
      "type": "barcode",
      "id": "fldIZcm183zu56N3J",
      "name": "Barcode number"
    }
  ],
  "views": [
    {
      "id": "viw1lOv2GlRvbxQuo",
      "name": "Grid view",
      "type": "grid"
    }
  ]
}

Expand

Update Table Copy Link

This Method is used to Update the name, description of a table. At least one of name, description must be specified.

See Airtable Update table API reference.

Configuration Table:

Input Options (Field Mapping):

Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
Default Value: Select value from a defined list or specify a fixed attribute.
Manual input: Set a custom value by using the Lightning Bold feature.

Name*	Update Table
Connection*	Select your connection or create one.

MATCHING CRITERIA

Base ID*:

Select the Airtable base.

Table ID or Name*:

Select the table to update.

MAP FIELDS

Table Name:

the new table name.

Table Description:

The new table description.

if present, must be a string no longer than 20,000 characters.

(*) required field

Response sample

{
  “id”: “tblG31otxPI7hXSJj”,
  “name”: “Update table”,
  “description”: “Table name updated via Wiresk”,
  “primaryFieldId”: “fldWg3rZwG5Z11Rjw”,
  “fields”: [
    {
      “id”: “fldWg3rZwG5Z11Rjw”,
      “name”: “Update name field”,
      “description”: “field updating with Wiresk Method”,
      “type”: “singleLineText”
    },
    {
      “id”: “fldx5bLDZxEmJVCvB”,
      “name”: “Long text”,
      “type”: “multilineText”
    },
    {
      “id”: “fldAjyAmHLSZPcE20”,
      “name”: “Rich text”,
      “type”: “richText”
    },
    {
      “id”: “fldvNaBgAdMEdmScU”,
      “name”: “attachment”,
      “type”: “multipleAttachments”,
      “options”: {
        “isReversed”: false
      }
    },
    {
      “id”: “fldG6OUaDgTYWBpuI”,
      “name”: “done”,
      “type”: “checkbox”,
      “options”: {
        “icon”: “xCheckbox”,
        “color”: “greenBright”
      }
    },
    {
      “id”: “fld1Lb14fPXlTeZmp”,
      “name”: “multiple select”,
      “type”: “multipleSelects”,
      “options”: {
        “choices”: [
          {
            “id”: “selBZBBDOObd7Kwbr”,
            “name”: “choice 1”,
            “color”: “blueLight2”
          },
          {
            “id”: “seltv3fTc2ljH35Um”,
            “name”: “choice 2”,
            “color”: “grayLight2”
          }
        ]
      }
    },
    {
      “id”: “fldL8bNGH40AEnNBL”,
      “name”: “single select”,
      “type”: “singleSelect”,
      “options”: {
        “choices”: [
          {
            “id”: “selnXEEqxnNnNF07Y”,
            “name”: “choice 1”,
            “color”: “cyanLight2”
          },
          {
            “id”: “selwhALx2DogtzJ4C”,
            “name”: “choice 2”,
            “color”: “greenLight2”
          }
        ]
      }
    },
    {
      “id”: “fldgoSaVqE0kBkTaV”,
      “name”: “user”,
      “type”: “singleCollaborator”,
      “options”: {
        “choices”: [
          {
            “id”: “usrYXyrjFY0y05ywc”,
            “email”: “wiresktest@gmail.com”,
            “permissionLevel”: “create”,
            “name”: “Wiresk Test”,
            “profilePicUrl”: “https://static.airtable.com/images/userIcons/user_icon_7.png”
          }
        ]
      }
    },
    {
      “id”: “fldNIn7Ja3okWEpMt”,
      “name”: “multiple users”,
      “type”: “multipleCollaborators”,
      “options”: {
        “choices”: [
          {
            “id”: “usrYXyrjFY0y05ywc”,
            “email”: “wiresktest@gmail.com”,
            “permissionLevel”: “create”,
            “name”: “Wiresk Test”,
            “profilePicUrl”: “https://static.airtable.com/images/userIcons/user_icon_7.png”
          }
        ]
      }
    },
    {
      “id”: “fld95cx9HZWPXA8f7”,
      “name”: “date”,
      “type”: “date”,
      “options”: {
        “dateFormat”: {
          “name”: “friendly”,
          “format”: “LL”
        }
      }
    },
    {
      “id”: “fld7IpiKnHP4ukEcp”,
      “name”: “Date and time”,
      “type”: “dateTime”,
      “options”: {
        “dateFormat”: {
          “name”: “friendly”,
          “format”: “LL”
        },
        “timeFormat”: {
          “name”: “24hour”,
          “format”: “HH:mm”
        },
        “timeZone”: “client”
      }
    },
    {
      “id”: “fldpT7mThyIsb2JhC”,
      “name”: “phone number”,
      “type”: “phoneNumber”
    },
    {
      “id”: “fldMCVOK3bsKWp95G”,
      “name”: “email”,
      “type”: “email”
    },
    {
      “id”: “fldLnYGD1XdgDusRW”,
      “name”: “external Link”,
      “type”: “url”
    },
    {
      “id”: “fld6zemXd0F1UvPxd”,
      “name”: “Number field”,
      “type”: “number”,
      “options”: {
        “precision”: 2
      }
    },
    {
      “id”: “fldfLFAboc87gb5zi”,
      “name”: “currency field”,
      “type”: “currency”,
      “options”: {
        “precision”: 2,
        “symbol”: “$”
      }
    },
    {
      “id”: “fld10lbcK3AUwEa5q”,
      “name”: “Percentage”,
      “type”: “percent”,
      “options”: {
        “precision”: 2
      }
    },
    {
      “id”: “fldjDdREWovK1WO9c”,
      “name”: “Rating”,
      “type”: “rating”,
      “options”: {
        “icon”: “star”,
        “max”: 10,
        “color”: “yellowBright”
      }
    },
    {
      “id”: “fldq3IViuOll9ISqy”,
      “name”: “Duration”,
      “type”: “duration”,
      “options”: {
        “durationFormat”: “h:mm”
      }
    },
    {
      “id”: “fldIZcm183zu56N3J”,
      “name”: “Barcode number”,
      “type”: “barcode”
    }
  ],
  “views”: [
    {
      “id”: “viw1lOv2GlRvbxQuo”,
      “name”: “Grid view”,
      “type”: “grid”
    }
  ]
}

Copy

{
  "id": "tblG31otxPI7hXSJj",
  "name": "Update table",
  "description": "Table name updated via Wiresk",
  "primaryFieldId": "fldWg3rZwG5Z11Rjw",
  "fields": [
    {
      "id": "fldWg3rZwG5Z11Rjw",
      "name": "Update name field",
      "description": "field updating with Wiresk Method",
      "type": "singleLineText"
    },
    {
      "id": "fldx5bLDZxEmJVCvB",
      "name": "Long text",
      "type": "multilineText"
    },
    {
      "id": "fldAjyAmHLSZPcE20",
      "name": "Rich text",
      "type": "richText"
    },
    {
      "id": "fldvNaBgAdMEdmScU",
      "name": "attachment",
      "type": "multipleAttachments",
      "options": {
        "isReversed": false
      }
    },
    {
      "id": "fldG6OUaDgTYWBpuI",
      "name": "done",
      "type": "checkbox",
      "options": {
        "icon": "xCheckbox",
        "color": "greenBright"
      }
    },
    {
      "id": "fld1Lb14fPXlTeZmp",
      "name": "multiple select",
      "type": "multipleSelects",
      "options": {
        "choices": [
          {
            "id": "selBZBBDOObd7Kwbr",
            "name": "choice 1",
            "color": "blueLight2"
          },
          {
            "id": "seltv3fTc2ljH35Um",
            "name": "choice 2",
            "color": "grayLight2"
          }
        ]
      }
    },
    {
      "id": "fldL8bNGH40AEnNBL",
      "name": "single select",
      "type": "singleSelect",
      "options": {
        "choices": [
          {
            "id": "selnXEEqxnNnNF07Y",
            "name": "choice 1",
            "color": "cyanLight2"
          },
          {
            "id": "selwhALx2DogtzJ4C",
            "name": "choice 2",
            "color": "greenLight2"
          }
        ]
      }
    },
    {
      "id": "fldgoSaVqE0kBkTaV",
      "name": "user",
      "type": "singleCollaborator",
      "options": {
        "choices": [
          {
            "id": "usrYXyrjFY0y05ywc",
            "email": "wiresktest@gmail.com",
            "permissionLevel": "create",
            "name": "Wiresk Test",
            "profilePicUrl": "https://static.airtable.com/images/userIcons/user_icon_7.png"
          }
        ]
      }
    },
    {
      "id": "fldNIn7Ja3okWEpMt",
      "name": "multiple users",
      "type": "multipleCollaborators",
      "options": {
        "choices": [
          {
            "id": "usrYXyrjFY0y05ywc",
            "email": "wiresktest@gmail.com",
            "permissionLevel": "create",
            "name": "Wiresk Test",
            "profilePicUrl": "https://static.airtable.com/images/userIcons/user_icon_7.png"
          }
        ]
      }
    },
    {
      "id": "fld95cx9HZWPXA8f7",
      "name": "date",
      "type": "date",
      "options": {
        "dateFormat": {
          "name": "friendly",
          "format": "LL"
        }
      }
    },
    {
      "id": "fld7IpiKnHP4ukEcp",
      "name": "Date and time",
      "type": "dateTime",
      "options": {
        "dateFormat": {
          "name": "friendly",
          "format": "LL"
        },
        "timeFormat": {
          "name": "24hour",
          "format": "HH:mm"
        },
        "timeZone": "client"
      }
    },
    {
      "id": "fldpT7mThyIsb2JhC",
      "name": "phone number",
      "type": "phoneNumber"
    },
    {
      "id": "fldMCVOK3bsKWp95G",
      "name": "email",
      "type": "email"
    },
    {
      "id": "fldLnYGD1XdgDusRW",
      "name": "external Link",
      "type": "url"
    },
    {
      "id": "fld6zemXd0F1UvPxd",
      "name": "Number field",
      "type": "number",
      "options": {
        "precision": 2
      }
    },
    {
      "id": "fldfLFAboc87gb5zi",
      "name": "currency field",
      "type": "currency",
      "options": {
        "precision": 2,
        "symbol": "$"
      }
    },
    {
      "id": "fld10lbcK3AUwEa5q",
      "name": "Percentage",
      "type": "percent",
      "options": {
        "precision": 2
      }
    },
    {
      "id": "fldjDdREWovK1WO9c",
      "name": "Rating",
      "type": "rating",
      "options": {
        "icon": "star",
        "max": 10,
        "color": "yellowBright"
      }
    },
    {
      "id": "fldq3IViuOll9ISqy",
      "name": "Duration",
      "type": "duration",
      "options": {
        "durationFormat": "h:mm"
      }
    },
    {
      "id": "fldIZcm183zu56N3J",
      "name": "Barcode number",
      "type": "barcode"
    }
  ],
  "views": [
    {
      "id": "viw1lOv2GlRvbxQuo",
      "name": "Grid view",
      "type": "grid"
    }
  ]
}

Expand

Create Table Fields Copy Link

This Method is used to create a new column and returns the schema for the newly created column.

⚠️ Cannot duplicate field name. Creating a field with an existing name will return an error. Fields must have case-insensitive unique names within the table.

Refer to field types for supported field types, the write format for field options, and other specifics for certain field types. Supported field types have a write format shown.

See Airtable Create field API reference.

Configuration Table:

Input Options (Field Mapping):

Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
Default Value: Select value from a defined list or specify a fixed attribute.
Manual input: Set a custom value by using the Lightning Bold feature.

Name*	Create Table Fields
Connection*	Select your connection or create one.

MATCHING CRITERIA

Base ID*:

Select the Airtable base.

Table ID*:

Select the table in which to create new columns.

MAP FIELDS

Fields*:

Field types and cell values to create.

+Element +Map ↓
(Add a repeating group of fields or Map it from an array. See Field Mapping).

Element 1: Represents the first group of columns.

Each group will be added to your table one after another.

+ Add Field ↓
List of available fields:

Single line text:

Name or describe the column.

A column of single line of text. Limited to 100,000 characters.

Long text:

Name or describe the column.

Multiple lines of text, which may contain “mention tokens”. Limited to 100,000 characters.

Rich text:

Name or describe the column.

Long text (with rich text formatting enabled).

Learn more about using Markdown in long text’s rich text formatting API.

Attachment:

Name or describe the column.

Attachments allow you to add images, documents, or other files which can then be viewed or downloaded.

Checkbox:

Name*: Name or describe the column.

Color*: Select the icon color.

Bases on a free or plus plan are limited to using the 'check' icon and 'greenBright' color.

Icon*: Select the icon.

Multiple select:

Name*: Name or describe the column.

Column where each field allows the selection of multiple choices.

Choices*: +Element +Map ↓

Element 1: Represents the first choice.

Name*:

Enter the first choice.

+ Add Field ↓

Color: Define the choice color.

+ Add Field ↓

Color: Optional when the select field is configured to not use colors.

Single select:

Name*: Name or describe the column.

Column where each field allows the selection of a single choice.

Choices*: +Element +Map ↓

Element 1: Represents the first choice.

Name*:

Enter the first choice.

+ Add Field ↓

Color: Define the choice color.

+ Add Field ↓

Color: Optional when the select field is configured to not use colors.

User:

Name or describe the column.

Column where each field allows the selection of one user.

Multiple Users:

Name or describe the column.

Column where each field allows the selection of multiple users.

Date:

Name*: Name or describe the column.

Date format*:

Format*: Select the date format

l - LL - M/D/YYYY - D/M/YYYY - YYYY-MM-DD

Name*: Select the corresponding format name. Wrong matching will return error.

(l for Local, LL for Friendly, M/D/YYYY for US, D/M/YYYY for European, YYYY-MM-DD for ISO)

Date and Time:

Name*: Name or describe the column.

Date format*:

Format*: Select the date format.

l - LL - M/D/YYYY - D/M/YYYY - YYYY-MM-DD

Name*: Select the corresponding format name. Wrong matching will return error.

(l for Local, LL for Friendly, M/D/YYYY for US, D/M/YYYY for European, YYYY-MM-DD for ISO)

Time format*:

Format*: Select the time format.

h:mma – HH:mm

Name*: Select the corresponding format name. Wrong matching will return error.

(h:mma for 12hour and HH:mm for 24hour)

Phone Number:

Name or describe the column.

Column for phone number, e.g. “(415) 555-9876”.

Email:

Name or describe the column.

Column of valid emails.

URL:

Name or describe the column.

A valid URL (e.g. wiresk.com or https://app.wiresk.com/en/register).

Number:

Name*:

Name or describe the column.

Precision*:

Indicates the number of digits shown to the right of the decimal point for this field. (0-8 inclusive)

Currency:

Name*:

Name or describe the column.

Precision*:

Indicates the number of digits shown to the right of the decimal point for this field. (0-7 inclusive)

Symbol*:

Currency symbol to use.

Percent:

Decimal number representing a percentage value. For example, the underlying cell value for 12.3% is 0.123.

Name*:

Name or describe the column.

Precision*:

Indicates the number of digits shown to the right of the decimal point for this field. (0-8 inclusive)

Rating:

A positive integer (e.g. “3 stars” is 3). A rating cannot be 0.

Bases on a free or plus plan are limited to using the star icon and yellow Bright color.

Name*:

Name or describe the column.

Icon*:

Select the icon used to display the rating.

star - heart - thumbs Up - flag - dot

Color*:

Select the color of the displayed icon.

Max*:

The maximum value for the rating, from 1 to 10 inclusive.

Duration:

An integer representing number of seconds.

Name*:

Name or describe the column.

Duration Format*:

Select the format:

h:mm
h:mm:ss
h:mm:ss.S
h:mm:ss.SS
h:mm:ss.SSS

Barcode:

Name or describe the Barcode column.

Use the Airtable iOS or Android app to scan barcodes.

Link to another record:

Creating “multiple Record Links” fields is supported but updating options for existing “multipleRecordLinks” fields is not supported.

Name:

Name or describe the column.

Linked Table ID:

The ID of the table this field links to.

View ID for record selection:

The ID of the view in the linked table to use when showing a list of records to select from.

(*) required field

Response sample

[
  {
    “type”: “singleLineText”,
    “id”: “fldHk7JVS7klCSE5B”,
    “name”: “add single line”
  },
  {
    “type”: “multilineText”,
    “id”: “fldBuQ80u8yl40C4b”,
    “name”: “add long text”
  },
  {
    “type”: “richText”,
    “id”: “fldHtj6qeskvDHYDg”,
    “name”: “add rich text”
  },
  {
    “type”: “multipleAttachments”,
    “options”: {
      “isReversed”: false
    },
    “id”: “fldNZ0xoHNMy5Q2bM”,
    “name”: “add attachment”
  },
  {
    “type”: “checkbox”,
    “options”: {
      “icon”: “check”,
      “color”: “greenBright”
    },
    “id”: “fldoAtT18d3ceWRJJ”,
    “name”: “add c heckbox”
  },
  {
    “type”: “multipleSelects”,
    “options”: {
      “choices”: [
        {
          “id”: “sela0hPQNq9AFtVdo”,
          “name”: “choice 1”,
          “color”: “blueLight2”
        },
        {
          “id”: “sel50zhilOw8GD3ug”,
          “name”: “choice 2”,
          “color”: “cyanLight2”
        }
      ]
    },
    “id”: “fldNpjJCFdfmW4ocr”,
    “name”: “add multiple select”
  },
  {
    “type”: “singleSelect”,
    “options”: {
      “choices”: [
        {
          “id”: “seludidgaMdl56aZb”,
          “name”: “choice 1”,
          “color”: “pinkLight2”
        },
        {
          “id”: “sel2wqZrvDBUNtHj5”,
          “name”: “choice 2”,
          “color”: “purpleLight2”
        }
      ]
    },
    “id”: “fldt5y317qsnvGPwx”,
    “name”: “add single select”
  },
  {
    “type”: “singleCollaborator”,
    “id”: “fldwtwSA3HaPBV59j”,
    “name”: “add user field”
  },
  {
    “type”: “multipleCollaborators”,
    “id”: “fldC2TdOLTpFo5Gyw”,
    “name”: “add multiple users field”
  },
  {
    “type”: “date”,
    “options”: {
      “dateFormat”: {
        “name”: “friendly”,
        “format”: “LL”
      }
    },
    “id”: “fldOVGSCWbsswyG2J”,
    “name”: “add date”
  },
  {
    “type”: “dateTime”,
    “options”: {
      “dateFormat”: {
        “name”: “us”,
        “format”: “M/D/YYYY”
      },
      “timeFormat”: {
        “name”: “24hour”,
        “format”: “HH:mm”
      },
      “timeZone”: “client”
    },
    “id”: “fldHFhvxjc7eYDmGB”,
    “name”: “add date and time”
  },
  {
    “type”: “phoneNumber”,
    “id”: “fldHSSinfsRVmaXMQ”,
    “name”: “add phone number”
  },
  {
    “type”: “email”,
    “id”: “fldSjztKov7XTgkCh”,
    “name”: “add email”
  },
  {
    “type”: “url”,
    “id”: “fldfiM6CqfbyVtMMD”,
    “name”: “add URL”
  },
  {
    “type”: “number”,
    “options”: {
      “precision”: 2
    },
    “id”: “fldIDHza7wLqalhg3”,
    “name”: “Add number”
  },
  {
    “type”: “currency”,
    “options”: {
      “precision”: 2,
      “symbol”: “$”
    },
    “id”: “fldrkmGW6TcxTc95r”,
    “name”: “add Currency field”
  },
  {
    “type”: “percent”,
    “options”: {
      “precision”: 2
    },
    “id”: “fldVqUUVMSZDQyYEt”,
    “name”: “add percent field”
  },
  {
    “type”: “rating”,
    “options”: {
      “icon”: “star”,
      “max”: 5,
      “color”: “yellowBright”
    },
    “id”: “fldgCnZNVJfCoRl5f”,
    “name”: “add rating field”
  },
  {
    “type”: “duration”,
    “options”: {
      “durationFormat”: “h:mm:ss”
    },
    “id”: “fldhsVrmfJiyI6R5n”,
    “name”: “add duration field”
  },
  {
    “type”: “barcode”,
    “id”: “fldvjtcHPmZpFR7pE”,
    “name”: “120897FF234”
  }
]

Copy

[
  {
    "type": "singleLineText",
    "id": "fldHk7JVS7klCSE5B",
    "name": "add single line"
  },
  {
    "type": "multilineText",
    "id": "fldBuQ80u8yl40C4b",
    "name": "add long text"
  },
  {
    "type": "richText",
    "id": "fldHtj6qeskvDHYDg",
    "name": "add rich text"
  },
  {
    "type": "multipleAttachments",
    "options": {
      "isReversed": false
    },
    "id": "fldNZ0xoHNMy5Q2bM",
    "name": "add attachment"
  },
  {
    "type": "checkbox",
    "options": {
      "icon": "check",
      "color": "greenBright"
    },
    "id": "fldoAtT18d3ceWRJJ",
    "name": "add c heckbox"
  },
  {
    "type": "multipleSelects",
    "options": {
      "choices": [
        {
          "id": "sela0hPQNq9AFtVdo",
          "name": "choice 1",
          "color": "blueLight2"
        },
        {
          "id": "sel50zhilOw8GD3ug",
          "name": "choice 2",
          "color": "cyanLight2"
        }
      ]
    },
    "id": "fldNpjJCFdfmW4ocr",
    "name": "add multiple select"
  },
  {
    "type": "singleSelect",
    "options": {
      "choices": [
        {
          "id": "seludidgaMdl56aZb",
          "name": "choice 1",
          "color": "pinkLight2"
        },
        {
          "id": "sel2wqZrvDBUNtHj5",
          "name": "choice 2",
          "color": "purpleLight2"
        }
      ]
    },
    "id": "fldt5y317qsnvGPwx",
    "name": "add single select"
  },
  {
    "type": "singleCollaborator",
    "id": "fldwtwSA3HaPBV59j",
    "name": "add user field"
  },
  {
    "type": "multipleCollaborators",
    "id": "fldC2TdOLTpFo5Gyw",
    "name": "add multiple users field"
  },
  {
    "type": "date",
    "options": {
      "dateFormat": {
        "name": "friendly",
        "format": "LL"
      }
    },
    "id": "fldOVGSCWbsswyG2J",
    "name": "add date"
  },
  {
    "type": "dateTime",
    "options": {
      "dateFormat": {
        "name": "us",
        "format": "M/D/YYYY"
      },
      "timeFormat": {
        "name": "24hour",
        "format": "HH:mm"
      },
      "timeZone": "client"
    },
    "id": "fldHFhvxjc7eYDmGB",
    "name": "add date and time"
  },
  {
    "type": "phoneNumber",
    "id": "fldHSSinfsRVmaXMQ",
    "name": "add phone number"
  },
  {
    "type": "email",
    "id": "fldSjztKov7XTgkCh",
    "name": "add email"
  },
  {
    "type": "url",
    "id": "fldfiM6CqfbyVtMMD",
    "name": "add URL"
  },
  {
    "type": "number",
    "options": {
      "precision": 2
    },
    "id": "fldIDHza7wLqalhg3",
    "name": "Add number"
  },
  {
    "type": "currency",
    "options": {
      "precision": 2,
      "symbol": "$"
    },
    "id": "fldrkmGW6TcxTc95r",
    "name": "add Currency field"
  },
  {
    "type": "percent",
    "options": {
      "precision": 2
    },
    "id": "fldVqUUVMSZDQyYEt",
    "name": "add percent field"
  },
  {
    "type": "rating",
    "options": {
      "icon": "star",
      "max": 5,
      "color": "yellowBright"
    },
    "id": "fldgCnZNVJfCoRl5f",
    "name": "add rating field"
  },
  {
    "type": "duration",
    "options": {
      "durationFormat": "h:mm:ss"
    },
    "id": "fldhsVrmfJiyI6R5n",
    "name": "add duration field"
  },
  {
    "type": "barcode",
    "id": "fldvjtcHPmZpFR7pE",
    "name": "120897FF234"
  }
]

Expand

Update Table Field Copy Link

This Method is used to update the name and/or description of a field. At least one of name or description must be specified.

See Airtable Update field API reference.

Configuration Table:

Input Options (Field Mapping):

Input: Allows dynamic inputs, e.g., from a Trigger or from Step responses. Input tab>uncheck “Show recommended” to see all fields).
Default Value: Select value from a defined list or specify a fixed attribute.
Manual input: Set a custom value by using the Lightning Bold feature.

Name*	Update Table Field
Connection*	Select your connection or create one.

MATCHING CRITERIA

Base ID*:

Select the Airtable base.

Table ID*:

Select the table containing the field to update.

Field ID*:

Select the name of the field to update.

MAP FIELDS

Field Name:

The new field (column) name.

Field Description:

The new field (column) description.

if present, must be a string no longer than 20,000 characters.

(*) required field

Response sample

{
  "type": "singleLineText",
  "id": "fldWg3rZwG5Z11Rjw",
  "name": "Update name field",
  "description": "field updated with Wiresk Method"
}

Expand

Test and automate your Flow Copy Link

Once your Flow is configured, you can test or automate it using the Run panel or by managing Triggers from the Flow Management screen.

Run Flow: Manually runs the Flow once using sample data. Ideal for testing logic and field mapping. See How to Run a Flow.
Run Scheduler: Force-runs the Trigger immediately using live input. This bypasses the recurrence rule and is useful for verifying real data mapping. Learn more in Wiresk Scheduler – The Fundamentals.

From the Trigger management panel (clock icon), you can:

Activate or deactivate Triggers
Force-run the scheduler
Copy Routing Keys (for HTTP Triggers)

If your Flow uses a Webhook Trigger, it runs automatically on each incoming webhook—no scheduler required. It remains active until you manually deactivate it.