I have a simple scenario where I have some invoices in google sheets and I want to check if they exist in airtable and if they don’t exist, I want to create them.
I have a router because I have a column for 1st payment with an invoice nr and another column with 2nd invoice number.
As you can see the filter works for some records but doesn’t for some others.
I’m searching for the ID of the invoice and using bolean as comparison, because on my first try I did with text (not exist) and still didn’t work.
I ran the scenario twice in a row, on 1st run it should create the invoices that were missing and 2nd run should filter all.
Thanks in advance