Managing Dynamic Data Updates in Airtable Tables
I have a table with 10 columns in Airtable categorized by category. I have dynamic output data from one of my nodes, and I need to look up a specific value in one of these columns to determine if it already exists in my table. If the value exists, I want to update the corresponding row with the new data. If it doesn't exist, I want to add a new row and include all the output data from the previous node. How can I achieve this?
Solution:Jump to solution
Hi @Jrocks, You can use the CRUD nodes for Airtable, here's a full documentation - https://docs.buildship.com/database/airtable.
4 Replies
To achieve this, you can use BuildShip's integration with Airtable to check for the existence of a value, update the row if it exists, or add a new row if it doesn't. Here are the steps:
1. Query the Airtable Table: Use the
Airtable Query node to search for the specific value in the desired column.
2. Branch Node: Use a Branch (If Else) node to determine if the value exists based on the result of the query.
3. Update or Insert: Depending on the result of the Branch node, use either the Airtable Update node to update the existing row or the Airtable Create node to add a new row.
Step-by-Step Guide:
1. Query the Airtable Table:
- Add the Airtable Query node.
- Configure it to query the specific column for the value you want to check.
2. Branch Node:
- Add a Branch (If Else) node to check if the query result contains the value.
- Set the condition to check if the result from the Airtable Query node is not empty.
3. Update or Insert:
- In the Then branch of the Branch (If Else) node, add the Airtable Update node to update the existing row with the new data.
- In the Else branch of the Branch (If Else) node, add the Airtable Create node to add a new row with the output data from the previous node.
For more detailed steps on how to use the Branch node and other nodes, you can refer to the following documentation:
- Branch Node
- Airtable Integration
If you need further assistance, please submit your query via the in-app support button.Branch (If Else) – BuildShip
A unified resource to start building your backend with low-code. Dive into triggers, nodes, and step-by-step guidance to jumpstart your workflow creation.
It appears that Airtable Query node doesn't exist
It seems that there might not be a pre-built Airtable Query node available in BuildShip. If you need specific functionality that isn't available, you can use the API Call node to interact with Airtable's API.
For more information on using the API Call node, please refer to the BuildShip documentation: API Call Node.
If you need further assistance, please submit your query via the in-app support button.
Solution
Hi @Jrocks, You can use the CRUD nodes for Airtable, here's a full documentation - https://docs.buildship.com/database/airtable.