Airtable modules

after connecting to the airtable app, you can use the following modules to build your {{scenario plural lowercase}} records watch records returns all newly created or updated records in a view (required created time or last modified time fields) field description connection airtable docid\ qbgn1rehdvl u3epf3jak 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 trigger field label field used as a label for a record for example, status dialog limit the maximum number of records make 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 {{scenario singular lowercase}} watch responses triggers when a new response is submitted available for paid airtable pro plan only see the airtable pricing page the webhook url needs to be generated in {{product name}} and added to the form configuration in the airtable add the watch responses module to your {{product name}} {{scenario singular lowercase}} generate and copy the webhook url log in to your airtable account open the base and the table you want for the form and create a form view create a from view set the form as needed, scroll down the form, and enable the redirect to url after the form is submitted option 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} go back to your {{product name}} {{scenario singular lowercase}} and run the watch responses module only to load the record id from airtable and to be able to map that field into the other modules airtable only supports sending the record id parameter submit the form in airtable where the redirect to url after the form is submitted option is enabled and the webhook url is added (step 6 above) the watch responses module is triggered and loads the record id you can now add another module after the watch responses module and map the record id to the record id field search records searches for specific records or returns all records field description connection airtable docid\ qbgn1rehdvl u3epf3jak 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, 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 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 make 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 {{scenario singular lowercase}} get a record retrieves a single record by its id field description connection airtable docid\ qbgn1rehdvl u3epf3jak base select or map the base that contains the table you want to get a record from table select the table you want to get a record from 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 {{scenario singular lowercase}} create a record creates a new record in a airtable field description connection airtable docid\ qbgn1rehdvl u3epf3jak base select or map the base that contains the table where you want to create a record table select the table where you want to create a record record enter values to the desired fields see 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 {{scenario singular lowercase}} update a record updates a record by its id field description connection airtable docid\ qbgn1rehdvl u3epf3jak base select or map the base that contains the table whose records you want to update table select the table whose records you want to update record 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 to the desired fields see airtable's guide to basic field types to delete the content of the field, use the erase function 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 {{scenario singular lowercase}} upsert a record creates a new or updates an existing record field description connection airtable docid\ qbgn1rehdvl u3epf3jak base select or map the base that contains 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 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 if you enter an id that does not exist, an error occurs, and no action is performed record enter the values you want to update or create see airtable's guide to basic field types to delete the content of the field, use the erase function 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 {{scenario singular lowercase}} delete a record deletes a record by its id field description connection airtable docid\ qbgn1rehdvl u3epf3jak base select or map 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 (map) the record id 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 bulk create records (advanced) creates multiple records field description connection airtable docid\ qbgn1rehdvl u3epf3jak create records in bulk select the input method enter manually select from the list base select or map the base that contains the table you want to create records in table select the table in which you want to create the records records enter values in the fields you want to create see airtable's guide to basic field types bulk update records (advanced) updates multiple existing records field description connection airtable docid\ qbgn1rehdvl u3epf3jak update records in bulk select the input method enter manually select from the list base select or map the base that contains the table whose records you want to update table select the table in which you want to update the records records enter values in the fields you want to update see airtable's guide to basic field types bulk upsert records (advanced) upserts multiple records field description connection airtable docid\ qbgn1rehdvl u3epf3jak upsert records in bulk select the input method enter manually select from the list base select or map the base that contains the table where you want to upsert records table select the table in which you want to upsert records fields to merge on enter at least one and at most three field names or ids to uniquely identify a single record records enter values in the fields you want to upsert see airtable's guide to basic field types bulk delete records (advanced) deletes multiple records field description connection airtable docid\ qbgn1rehdvl u3epf3jak delete records in bulk select the input method enter manually select from the list base select or map the base that contains the table where you want to delete records table select the table for which you want to delete records record id enter the ids of the record you want to delete you can retrieve the ids, for example, using the search records or watch records module alternatively, you can use the search button to select the record ids other make an api call allows you to perform a custom api call field description connection airtable docid\ qbgn1rehdvl u3epf3jak url enter a path relative to https //api airtable com/ for example, /v0/{base id}/{table id} 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