Airtable

The Airtable connector lets you create/update/delete and fetch the records in Airtable.

The Airtable connector lets you perform the following actions:

1. Create Record
2. Delete a Record
3. Get Single Record
4. Get Records
5. Update a Record

Let’s look at each of them in detail.

This action lets you create a record(s) in a table.

1. Click Configure Action Step from the left navigation panel.
2. Click Action Step to configure third-party services.
3. Within the Configure Action Step, click the Airtable connector.
   
   Click to enlarge
   
   
4. Under Choose an Action tab, select the Create Record action.
   
   Click to enlarge
5. Click the + Add New Account button to add your Airtable account.
   
   Click to enlarge
6. In the pop-up window, mark the checkboxes for all the OAuth permissions and then click the Authorize button.
   
   Click to enlarge
7. Click + Add a base to add a new database or select an existing one. Click Grant access to allow access to Airtable.
   
   Click to enlarge
8. Enter an Account Name and then click Save.
   
   Click to enlarge
9. Select a Database Name/ID present in the Airtable account.
10. Select a Table Name/ID to create a new record(s) in the selected table.
    
    Click to enlarge
11. In the Record Data field, provide the value for the record(s) you want to create.

    Note Below is a sample format to create the records. Here Name, Notes, and Status are column names of the table. You must provide values in key-value pairs.

    123456789

    {
            "records" : [
                "fields": {
                    "Name" : "Demo",
                    "Notes" : "Demo notes",
                    "Status" : "Done"
                }
            ]
        }

    Click to enlarge
12. Click the Proceed button.
13. Click the Test Action button to test the configured action.
    
    Click to enlarge
14. Once set, click the Save and Exit button.
    
    Click to enlarge

You have successfully created a record(s) in the selected table in Airtable.

This action lets you delete a single record in a table.

1. Under Choose an Action tab, select the Delete a Record action.
   
   Click to enlarge
2. Click the + Add New Account button to add your Airtable account.
   
   Click to enlarge
3. In the pop-up window, mark the checkboxes for all the OAuth permissions and then click the Authorize button.
   
   Click to enlarge
4. Click + Add a base to add a new database or select an existing one. Click Grant access to allow access to Airtable.
   
   Click to enlarge
5. Enter an Account Name and then click Save.
   
   Click to enlarge
6. Select a Database Name/ID present in the Airtable account.
7. Select a Table Name/ID to delete a record.
8. In the Record ID field, select the ID of the record you want to delete from the Lookup dropdown.
   
   Click to enlarge
9. Click the Proceed button.
10. Click the Test Action button to test the configured action.
    
    Click to enlarge
11. Once set, click the Save and Exit button.
    
    Click to enlarge

You have successfully deleted a record in the selected table in Airtable.

This action lets you fetch the details of a single record from a table.

1. Under Choose an Action tab, select the Get Single Record action.
   
   Click to enlarge
2. Click the + Add New Account button to add your Airtable account.
   
   Click to enlarge
3. In the pop-up window, mark the checkboxes for all the OAuth permissions and then click the Authorize button.
   
   Click to enlarge
4. Click + Add a base to add a new database or select an existing one. Click Grant access to allow access to Airtable.
   
   Click to enlarge
5. Enter an Account Name and then click Save.
   
   Click to enlarge
6. Select a Database Name/ID present in the Airtable account.
7. Select a Table Name/ID to fetch details of a record from the selected table.
8. In the Record ID field, select the ID of the record you want to fetch from the Lookup dropdown.
   
   Click to enlarge
9. Click the Proceed button.
10. Click the Test Action button to test the configured action.
    
    Click to enlarge
11. Once set, click the Save and Exit button.
    
    Click to enlarge

You have successfully fetched the details of a single record from the selected table.

This action lets you fetch the details of multiple records in a table.

1. Under Choose an Action tab, select the Get Records action.
   
   Click to enlarge
2. Click the + Add New Account button to add your Airtable account.
   
   Click to enlarge
3. In the pop-up window, mark the checkboxes for all the OAuth permissions and then click the Authorize button.
   
   Click to enlarge
4. Click + Add a base to add a new database or select an existing one. Click Grant access to allow access to Airtable.
   
   Click to enlarge
5. Enter an Account Name and then click Save.
   
   Click to enlarge
6. Select a Database Name/ID present in the Airtable account.
7. Select a Table Name/ID to fetch details of a record(s) present in the table.
8. In the Number of records field, enter the number of records you want to fetch from the selected table.

   NoteYou can fetch up to 100 records.

   Click to enlarge
9. [Optional] Enable the Show optional fields toggle button to display the Sort Column Name, Order of Sorting, and Airtable Filter field.
   Column Name sorts the records based on the column names. The Order of Sorting field sorts the records in Ascending or Descending order. You can add a filter formula to fetch the record.

   Additional Resource To learn more, refer to the Formula field reference document.

   Click to enlarge
10. Click the Proceed button.
11. Click the Test Action button to test the configured action.
    
    Click to enlarge
12. Once set, click the Save and Exit button.
    
    Click to enlarge

You have successfully fetched the details of multiple records from the selected table.

This action lets you update a record in a table.

1. Under Choose an Action tab, select the Update a Record action.
   
   Click to enlarge
2. Click the + Add New Account button to add your Airtable account.
   
   Click to enlarge
3. In the pop-up window, mark the checkboxes for all the OAuth permissions and then click the Authorize button.
   
   Click to enlarge
4. Click + Add a base to add a new database or select an existing one. Click Grant access to allow access to Airtable.
   
   Click to enlarge

5. Enter an Account Name and then click Save.
   

   Click to enlarge
6. Select a Database Name/ID present in the Airtable account.
7. Select a Table Name/ID to update a new record in the table.
8. In the Record ID field, select the ID of the record you want to update from the Lookup dropdown.
   
   Click to enlarge
9. In the Record Data field, provide the value for the record you want to update.

   Note You need to add the values for each column to update the record. If any column value is not updated, then it will remain empty

   Click to enlarge
10. Click the Proceed button.
11. Click the Test Action button to test the configured action.
    
    Click to enlarge
12. Once set, click the Save and Exit button.
    
    Click to enlarge

You have successfully updated a record in the selected table.