Skip to main content

Celonis Product Documentation

Airtable (Action Flows)

The Airtable modules allow you to monitor records and submitted forms or search, retrieve, create, update and delete records in your Airtable account.

To get started with Airtable, create an account at airtable.com/signup.

Connect Airtable to Execution Management System
  1. Log in to your Airtable account.

  2. Click Your Profile Icon > Account > Generate API key, and copy it to your clipboard.

    61d5a7b14ee55.gif
  3. Log in to your Execution Management System account, open the Airtable module Action Flow, and click the Add button next to the Connection field.

    airtable-1.png
  4. Optional: In the Connection name field, enter a name for the connection.

  5. In the API Token field, enter the API Key copied in step 2.

  6. Optional: Click Show Advanced Settings and in the Proxy field, select the proxy service.

    Note

    By choosing a Proxy, you understand and confirm that your Airtable data, including API keys, will be routed through a third-party service.

  7. Click Save.

You have successfully established the connection. You can now edit your Action Flow and add more Airtable modules. If your connection needs reauthorization, follow the connection renewal steps here.

Records

You can watch, create, update, search, retrieve, upsert, delete records, and watch responses using the following modules.

Triggers when a new record is added or updated in the table.

Connection

Establish a connection to your Airtable account.

Base

Select the base that contains the table you want to watch for records.

Table

Select the table you want to watch for new records.

Trigger configuration

Trigger field

Select the Created Time option to watch for new records or the Last Modified Time option to watch for modified records.

If you do not have a Created Time or Last Modified Time field in your scheme, we ask you to create one. Without this field, the trigger will not work correctly.

61d5a7b5d47d6.gif

Label field: used as a label for a record. For example, Choose where to start dialog.

Airtable_trigger_field.png

Limit

The maximum number of records Execution Management System will return during one execution cycle.

View

Select the view to watch the records. If selected, it will return the records only in that view.

Formula

Enter the formula to filter records. For more details, refer to the Formula field reference documentation.

The formula will be evaluated for each record, and if the result is not 0, false, "", NaN, [], or #Error!, includes the record in the response.

If combined with the view parameter, it returns only records in that view that satisfy the formula.

For example, to only include records where Name isn't empty, pass in NOT({Name} = '') as a parameter like this:

filterByFormula=NOT%28%7BName%7D%20%3D%20%27%27%29

Use Column ID

Select whether to use column ID instead of column name for mapping.

This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this Action Flow.

Triggers when a form is submitted.

Warning

Available for paid Pro Plan only. See the Airtable pricing page.

The webhook URL needs to be generated in Execution Management System and added to the form configuration in the Airtable.

  1. Add the Watch Responses module to your Execution Management System Action Flow.

  2. Generate and copy the webhook URL.

    Airtable_webhook_.gif
  3. Log in to your Airtable account.

  4. Open the Base and the table you want to use for the form and create a Form view.

    61d5a7c07e2c4.gif
  5. Set the form as needed, scroll down the form, and enable the Redirect to URL after the form is submitted option.

    61d5a7c446f88.png
  6. Enter the Webhook URL generated in step 2 to the displayed dialog box and add the ?record_id={record_id} just after the webhook URL to include the Record ID in the module's output, then click Save. The resulting URL will, for example, look like this:

    https://hook.eu1.make.com/tgnp28pewooafbdgobvbh225hmocbn85?record_id={record_id}

    61d5a7c61cdbc.png
  7. Go back to your Execution Management System Action Flow and run the Watch Responses module only to load fields from Airtable and to be able to map those fields into the other modules.

  8. Submit the form in Airtable where the Redirect to URL after the form is submitted option is enabled and Webhook URL added (step 6 above).

    The Watch Responses module is triggered and loads the desired data.

    61d5a7c7b5df4.gif
  9. Add the Airtable > Get a Record module just after the Airtable > Watch Responses module and map the record_id to the Record ID field.

    Airtable_record_ID.png

Every time the form is submitted, the Watch Responses module in your Execution Management System Action Flow is triggered, and the Get a Record module returns the submitted form details.

Returns records based on the filter settings.

Connection

Establish a connection to your Airtable account.

Base

Select or map the base that contains the table you want to search for records.

Table

Select the table you want to search for records.

Formula

Enter the formula to filter records. For more details about formulae, refer to the Formula field reference documentation. The formula will be evaluated for each record, and if the result is not 0, false, "", NaN, [], or #Error!, includes the record in the response.

If combined with the view parameter, returns only the records in that view that satisfy the formula.

For example, to only include records where Name isn't empty, pass in NOT({Name} = '') as a parameter like this:

filterByFormula=NOT%28%7BName%7D%20%3D%20%27%27%29

Sort

Specify sorting, if needed. The higher item in the list has precedence.

View

Select or map the view for the search results.

Output Fields

Add the fields you want to receive in the output. If no field is provided, all fields will be returned. It can be the field's name, for example, Email, or the field's ID, for example, fldzuOSozlM84fYV3.

Limit

Set the maximum number of records Execution Management System will return during one execution cycle. The default value is 10.

Use Column ID

Select whether to use column ID instead of column name for mapping.

This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this Action Flow.

Retrieves the specified record details.

Connection

Establish a connection to your Airtable account.

Base

Select the base that contains the table with the record whose details you want to retrieve.

Table

Select the table that contains the record whose details you want to retrieve.

Record ID

Enter (map) the Record ID whose details you want to retrieve. Alternatively, you can use the search option to select the record.

Use Column ID

Select whether to use column ID instead of column name for mapping.

This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this Action Flow.

Creates a new record in a selected table.

Connection

Establish a connection to your Airtable account.

Base

Select the base that contains the table in which you want to create a record.

Table

Select the table in which you want to create a record.

Record

Enter values to the desired fields. See also Airtable's guide to basic field types.

Smart links

Enable this option if you want to enter names instead of record IDs to fields that link to another table. The record is automatically created in the linked table if there is no match.

Use Column ID

Select whether to use column ID instead of column name for mapping.

This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this Action Flow.

Updates an existing record.

Connection

Establish a connection to your Airtable account.

Base

Select the base containing the table whose records you want to update.

Table

Select the table whose record you want to update.

Records ID

Enter (map) the Record ID you want to update. You can retrieve the ID, for example, using the Search Records or Watch Records module. Alternatively, you can use the Search button to select the Record ID.

Record

Enter values in the fields you want to update. See also Airtable's guide to basic field types.

Note

To delete the content of the field, use the erase function.

Airtable_erasing_a_field.png
2019-05-06-15_11_20-window.png

Smart links

Enable this option if you want to enter names instead of record IDs to fields that link to another table. The record is automatically created in the linked table if there is no match.

Use Column ID

Select whether to use column ID instead of column name for mapping.

This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this Action Flow.

Creates a record when you don't specify a record ID. Updates a record if the record ID is specified.

Connection

Establish a connection to your Airtable account.

Base

Select the base containing the table you want to update or create a record.

Table

Select the table where you want to create or update a record.

Record ID

Enter (map) the ID of the record you want to update. If no ID is entered, it will create a new record. You can retrieve the ID, for example, using the Search Records or Watch Records module. Alternatively, you can use the Search button to select the Record ID.

If you enter an ID that does not exist, an error occurs, and no action is performed.

Record

Enter values in the fields you want to update or create. See also Airtable's guide to basic field types.

Smart links

Enable this option if you want to enter names instead of record IDs to fields that link to another table. The record is automatically created in the linked table if there is no match.

Use Column ID

Select whether to use column ID instead of column name for mapping.

This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this Action Flow.

Deletes a specified record.

Connection

Establish a connection to your Airtable account.

Base

Select the base that contains the table you want to delete a record from.

Table

Select the table you want to delete the record from.

Record ID

Enter the ID of the record you want to delete. You can retrieve the ID, for example, using the Search Records or Watch Records module. Alternatively, you can use the Search button to select the Record ID.

Creates a record with mapped fields.

Connection

Establish a connection to your Airtable account.

Base

Enter the base that contains the table you want to create a record in.

Table

Enter the table you want to create a record in.

Record Fields as Array

Add the Column ID and Field value by selecting the field type for the record you want to create.

Smart links

Enable this field to enter the user name in the linked record fields instead of record IDs to select an existing record or create a new one if it doesn't exist and use it to add new options in single/multiple select fields.

Updates a record with mapped fields.

Connection

Establish a connection to your Airtable account.

Base

Enter the base that contains the table whose record details you want to update.

Table

Enter the table whose record details you want to update.

Record ID

Enter the Record ID whose details you want to update.

Record Fields

Add a new Column ID and Field value by selecting the field type you want to update.

Smart links

Enable this field to enter the user name in the linked record fields instead of record IDs to select an existing record or create a new one if it doesn't exist and use it to add new options in single/multiple select fields.

Searches for specific records or returns all records. Advanced module for mapping.

Connection

Establish a connection to your Airtable account.

Base ID

Enter the Base ID that contains the table whose records you want to search.

Table

Enter the table whose records you want to search.

Sort

A list of sort objects that specifies the way you want to order the records. For example, asc.

View

The name or ID of a view of the records in the table.

Formula

formula is used to filter records. The formula will be evaluated for each record, and if the result is not 0false""NaN[], or #Error! includes the record in the response.

Output Fields

Add the fields you want to receive in the output. If no field is provided, all fields will be returned. It can be the field's name, for example, Email, or the field's ID, for example, fldzuOSozlM84fYV3.

Limit

Set the maximum number of records Execution Management System will return during one execution cycle.

Use Column ID

Select whether to use column ID instead of column name for mapping.

This enables persistence over the column name change. Enabling this option allows to replace entity keys in the response; instead of entity names specified as parameter keys, their identifiers will be specified. Changing this value will break all existing mappings in this Action Flow.

Other

You can list bases, table schemas, and call APIs using the following modules.

Allows you to perform a custom API call.

Connection

Establish a connection to your Airtable account.

URL

Enter a path relative to https://api.airtable.com/. For example, /v0/{base_id}/{table_id}.

Note

For the list of available endpoints, refer to the Airtable REST API Documentation.

Method

Select the HTTP method you want to use:

  • GET

    to retrieve information for an entry.

  • POST

    to create a new entry.

  • PUT

    to update/replace an existing entry.

  • PATCH

    to make a partial entry update.

  • DELETE

    to delete an entry.

Headers

Enter the desired request headers. You don't have to add authorization headers; we already did that for you.

Query String

Enter the request query string.

Body

Enter the body content for your API call.

Example of Use - List Records

The following API call returns all records in the specified table in your Airtable account:

URL:

/v0/{base_id}/{table_id}

Method:

GET

Airtable_api_call.png

Search results can be found in the module's Output under Bundle > Body > records

In our example, 4 records were returned:

Airtable_api_bundles.png

Returns a detail list of all bases.

Connection

Establish a connection to your Airtable account.

Limit

Set the maximum number of bases Execution Management System will return during one execution cycle.

Returns the schema of the tables in the specified base.

Connection

Establish a connection to your Airtable account.

Base

Select or map the base whose table schemas you want to list.

Limit

Set the maximum number of table schemas Execution Management System will return during one execution cycle.