Update Airtable from Sheets

I am new to make.com

I am trying to bring Sheets data into Airtable. Both Airtable and Sheets have a calculated field (labeled “key”) that is unique to each row of data. That field is identical in both apps.

The goal is to compare the Sheets Key field for each record to the Airtable Key field to see if it exists. If it does, then update the Airtable row, otherwise add new Airtable record.

Here is my scenario.

The Sheets Search Row module has no filter, so all row in the sheet are passed to next module, Airtable Search.

Here is the output of one bundle from Sheets

The search module is comparing the data in the Airtable {key} field to the Sheets key field. I suspect this is where I am screwing up, but I have tried everything under the sun for this filter.

The output of Airtable search looks like this for one bundle:

I think (???) that the “number of bundles = 0” in the output means that there was no match?

But the key field in Airtable and Sheets do have the same data in them. Cannot figure out what I am doing wrong.

ADDITIONAL THOUGHTS
I am assuming (and this may be incorrect) that Airtable Search module is searching the entire table in that field (key) for a match. Is that correct?

Hello @Dirk_Dusharme,
Inside of that formula use this formula like this.

AND({key}=your field) 

Don’t use that double quotes.

Read more at here

:+1:

1 Like

Hello Dilip, removing the quotes results in an error:

Make Support suggested that the issue may be that the Key field in AirTable is a calculated field and that the Airtable API may not return calculated values.

Has any one worked with calculated values from Airtable?

Problem Solved
The formula in my Airtable field had an error. Oddly, Airtable didn’t flag it as an error, but apparently what ever value was returned to Make wasn’t what it should have been.
Fixed error
All is well.

3 Likes