The Airtable Field Generator automation creates a new Airtable table and generates one field in that table for each record in the source table. This is useful when you have a list of field names and field types stored in Airtable and want to turn that list into a new table structure automatically.
Setup
Create or choose a source table that contains one record for each field you want to create.
Make sure the source table has a text field that stores the name of each field, and a separate text field that stores the Airtable API field type string for each field (for example
singleLineTextorcheckbox).Create the Airtable Field Generator automation and select your source table.
Under Field Name, select the source field that contains the name for each field to be created.
Under Field Type, select the source field that contains the Airtable API field type string for each field.
Enter a Table Name for the new Airtable table that the automation will create when it runs.
Optional: enable Error Message Field and select a text field to store per-record error messages so that the run continues even when individual fields fail to create.
Run the automation
Click Run in the Run section. The automation will create the new table, then create one field in that table for each processed source record.
The target table name must not already exist in the base. If a table with the same name already exists, the run will fail before creating any fields.
Supported field types
The Field Type field must contain a valid Airtable API field type string. The following types are supported:
singleLineTextmultilineTextrichTextemailurlphonebarcodebuttonautoNumbernumberpercentcurrencycheckboxdatedateTimeratingduration