Actions5
- Base Actions
- Table Actions
- Field Actions
- Schema Actions
Overview
This node allows you to programmatically create and manage Airtable schema elements, specifically focusing here on creating a new field within an existing Airtable table. It is useful when automating the setup or modification of Airtable bases, tables, and fields without manual intervention in the Airtable UI.
For example, you can use this node to add a new "Status" single-select field with predefined choices to a customer contacts table, or add a currency field with specific decimal precision to a sales table. This is beneficial in workflows where Airtable schemas need to be dynamically adjusted based on external data or processes.
Properties
| Name | Meaning |
|---|---|
| Base ID | The identifier of the Airtable base that contains the table where the new field will be created. |
| Table ID | The identifier of the table within the base where the new field will be added. |
| Field Name | The name to assign to the new field. |
| Field Type | The type of the field to create. Options include: Attachments, Barcode, Checkbox, Count, Created By, Created Time, Currency, Date, Date and Time, Duration, Email, Formula, Last Modified By, Last Modified Time, Link to Another Record, Long Text, Lookup, Multiple Select, Number, Percent, Phone Number, Rating, Rich Text, Rollup, Single Line Text, Single Select, URL. |
| Field Description | Optional description for the new field. |
| Choices | (Only for Single Select and Multiple Select field types) A collection of choice options, each with a name and a color. |
| Currency Symbol | (Only for Currency field type) The currency symbol to use. Options include Australian Dollar (A$), British Pound (£), Canadian Dollar (C$), Chinese Yuan (¥), Euro (€), Japanese Yen (¥), US Dollar ($). |
| Decimal Precision | (Only for Currency and Percent field types) Number of decimal places to use. Defaults to 2. |
Output
The node outputs JSON data representing the newly created field object as returned by the underlying Airtable API call. This typically includes details such as the field's ID, name, type, description, and any additional configuration like choices or currency settings.
No binary data output is produced by this operation.
Dependencies
- Requires an API key credential for Airtable Enterprise API access.
- The node depends on the Airtable Enterprise workspace and proper permissions to create fields in the specified base and table.
- No additional environment variables are required beyond the configured API credentials.
Troubleshooting
Common issues:
- Invalid or missing Base ID or Table ID will cause the creation to fail.
- Insufficient permissions or invalid API credentials will result in authentication errors.
- Providing choices for field types other than single select or multiple select will be ignored or cause errors.
- Incorrect currency symbol or decimal precision values may lead to validation errors.
Error messages:
- Authentication errors indicate problems with the provided API key; verify and update credentials.
- Validation errors about field names or types suggest incorrect input parameters; ensure all required properties are correctly set.
- Network or API rate limit errors require retrying after some time or checking Airtable API usage limits.