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
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 datatype of the column headers in the Airtable account will get reflected automatically in the Quickwork Journey Builder while creating a record. For example, if the datatype of the Name field is string, then Quickwork Journey Builder 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
- In the Trigger section, click on the New Trigger button and then choose the Scheduler by Quickwork app from the drop-down menu in the App field.
- Select the trigger event, New scheduled event, from the drop-down menu in the Trigger Event field.
- Set the Interval for One day as we need to fetch the breaking news on a daily basis.
- Set the date and time of your choice in the Start At field and keep the Custom Payload field empty:
Configuring Airtable action
- Under the Steps section, click on the Simple Action button and choose the Airtable app from the drop-down menu in the App field.
- Select the Create record action from the drop-down menu in the Action field.
- 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.
- Upon successful establishment of the connection, the input fields will open.
- 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:
- Then, have a closer look at the app URL in the web browser. It would look like the following screenshot:
- 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.
- 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 Journey Builder.
- 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:
- Click the Copy record URL option. Now, return to the Quickwork Journey Builder 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:
- As soon as you specify the sample record ID, the column headers of Demo_Table will open up in the Fields data block.
- Now, specify the values that you want to insert in these fields:
Executing the journey
Save the changes in a journey and click the Start Journey 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.