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
June 15, 2022, 7:27am
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
June 15, 2022, 11:10am
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.
I did not notice your answer!
Thanks a lot for taking the time.
I gave up on n8n but seeing my make.com bill, now I’m back with a fresh install on AWS!
March 19, 2023, 2:19pm
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.