How to create a record in Airtable

Skill level: Intermediate

Time required: 7 minutes

This article explains how to create or add a record to a table in Airtable using Quickwork's Create record action.

Prerequisites

• A Quickwork account and and familiarity with the platform's GUI.
  

Overview

For this demonstration, we will add a record to the Demo_Table in the Product Planning app of an Airtable account.

1. Create a table, Demo_Table, in the Product Planning app and fill some values in the record:

Note: The column headers’ data types in Airtable will reflect automatically in Quickwork. For example, if the datatype of the Name field is a string, then Quickwork will accept string values for this field at the time of creating a record. Providing an unsupported data type will result in an error.

Step-by-step guide 

Configuring the trigger

1. In the Event section, click on the New Trigger button and then choose the Scheduler by Quickwork app from the drop-down menu.
2. Select the trigger event, New scheduled event, from the drop-down menu in the Trigger Event field.
3. Set the Interval for One hour.
4. Specify the date and time in the Start at field. Leave the Custom payload field empty.
   
   

Configuring Airtable action

1. Under the Steps section, click on the Simple Action button and choose the Airtable app from the drop-down menu in the Apps list.
2. Select the Create record action from the drop-down menu in the Actions list.
3. Click the Link an account button to establish a new connection with the Airtable account. You can also connect an existing account if you have one. 
4. Upon successful establishment of the connection, the input fields will open.
5. In the App ID field, you need to specify the ID of the app containing the table(s). To get the ID, visit https://airtable.com/api and click Product Planning.
   
   
   
6. In the app URL, locate the App ID. In the URL, appA4jMsruk8iXTbv is the app ID.
   
   
   
7. Specify this in your App ID field of Create record action.
   
   Note: The API link https://airtable.com/api is common for all the apps created in the Airtable account. Clicking this link followed by the app will give you the app ID.
   
   
8. Enter the name of the table where you want to add a record (For example, Demo_Table). 
   
   
   

9. Sample record ID:

   • Go to your Airtable table and right-click on any existing record.
   • Click Copy Record URL.
   
   
   
   
   
10.  Now, return to the Quickwork and paste the copied URL in the Sample record ID field. If the record URL is https://airtable.com/tblgjElmaQDSxZv5H/viwT0RmAeXWLAFxBo/reci1R0QggGYv1rzu, then reci1R0QggGYv1rzu is your sample record ID:
    
    
    
    
11. After specifying the sample record ID, the column headers of Demo_Table will  be displayed in the Fields data block.
12. Now, specify the values that you want to insert in these fields.

Executing the journey

1. Save the journey and click on Save & Start.
2. You will be automatically redirected to the History tab.
3. Once the journey executes, you’ll see a record with a green tick mark, confirming successful execution.
4. Click on the executed record to view the input-output details.
   
   
5. Open the Demo_Table in your Airtable account.
6. Verify that the new record has been successfully added.

By following these steps, you have successfully added a new record to your Airtable table using Quickwork's Create record action.