I have set up an automation:
Trigger> Google sheets: when a row is created
Action 1> find records where REF is [value from google sheet column with REF #s, which should match airtable REF values]
Action 2> update record
Action 2 is giving me trouble. I have 2 fields I want to update (a checkbox and a currency field).
When a row is created on the google sheet, for example with airtable REF #AB-0101 in the google sheets "airtable ref #" column, I want airtable to find record #AB-0101 and update that record's checkbox and currency field.
I swear I had it working last week, but today's test failed due to "invalid inputs."
I don't really understand how the "Record ID" part of the automation setup works for Action 2 (update record).
I did blue plus sign > Use data from... find records step > ...... then I'm lost! I've been digging around trying to find an explanation for the different options here (Insert all records as list vs grid, vs Make a new list of...) but not having much luck.
Can someone shed light on how these different "Record ID" options work and/or which one I need?