Update or append in airtable

Questions
,
1

Hello everyone,

I’m having trouble understanding what blocks to use in the following case.
I have:

  • 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
Joachim

2

Hi @Joachim_Brindeau,
you can use Airtables List operation with Filter By Formula to only return items where fieldName="value",

image
image710×960 38.9 KB

3

Thanks!

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

4

Hey Joachim,
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.

image
image2691×876 121 KB

The second time the records are updated.

image
image2538×855 118 KB

Make sure to update all occurences of orderID and employeeName according to your scenario.

5

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!