I’m having trouble understanding what blocks to use in the following case.
- A csv with record set A + record set B with field NUMBER
- An airtable with record set A with field NUMBER and field ID
How can I check whether to append or update into airtable depending if the NUMBER from the CSV is already in Airtable or not?
I thought a simple switch would suffice but apparently not.
Kind of lost on this.
Thanks a lot
you can use Airtables List operation with
Filter By Formula to only return items where
That would let me update the records.
How do I filter out these records for the create step?
My current issue is the duplicates being created.
Thanks again for your help
the following workflow to append/update records in airtable is losely based on n8n Course Level 1. Make sure to also checkout n8n Course Level 2 to better understand how to work with data in n8n.
The first time the records are appended.
The second time the records are updated.
Make sure to update all occurences of
employeeName according to your scenario.