How to create a record in Airtable?

This article demonstrates creating/adding a record to a table in Airtable.

What you'll need:

Skill level: Intermediate

Time required: 7 minutes

• Scheduler by Quickwork as a trigger--for triggering the journey 
• Airtable: Create record Action
• Pre-created app. In Airtable, an app is regarded as a base
• A table in a base
• At least one completely filled record in a table
• Accurate copy-paste skills

Prerequisite

In the article, we'll test creating a record in the Product Planning app of the Airtable account:

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

Note: The data type of the column headers in the Airtable account will get reflected automatically in the Quickwork while creating a record. 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. If a value of non-supportive datatype is specified, an error will occur.

 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 in the Apps list.
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. Set the date and time of your choice in the Start at field and keep 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). As mentioned earlier, our app is Product Planning. To get the ID, visit https://airtable.com/api and click Product Planning:
   
   
   
6. Then, have a closer look at the app URL in the web browser. It would look like the following screenshot:
   
   
   
7. In the above URL, appA4jMsruk8iXTbv is your app ID. 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 you are using will give you the app ID.
   
   
8. In the Table name field, specify the name of the table in which you want to create a record. E.g., Demo_Table. Ensure that you have specified the same table name while establishing the connection. If the table names are different, you won't get the column headers of your table in Quickwork:
   
   
   
9.  The next input field is Sample record ID. To get this record ID, go to your table in the Airtable account and right-click on any one of the previously created records:
   
   
   
   
10. Click the Copy record URL option. 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. As soon as you specify the sample record ID, the column headers of Demo_Table will open up in the Fields data block.
12. Now, specify the values that you want to insert in these fields:

Executing the journey

Save the changes in a journey and click the Save & Start button. You'll be taken to the History tab automatically. As soon as the journey gets executed, you’ll see a record displaying the journey ID with a green tick mark emphasizing the successful execution. You can click on the record to view the input-output details of the execution:

 To cross-check, go to your Demo_Table in your Airtable account: 

You'll see that a record has been added to the table successfully.