I need help figuring out what I am doing wrong. In the main table, I track daily work, and in the other table, I track inventory. There is created a link record from the main table to the inventory table. From the main table, I am selecting the available items for sale. What I would like the automation to do is find the records that I have assigned and copy the quote number from my main table to the inventory table. I know I can do a lookup the problem is that I have too many records that would have to backlog. Here is what I am trying to accomplish with the automation, but it keeps failing.
After I update that Quote Number field and select the items from the inventory table, I am triggering the automation from the checkbox field.
Main table view:
Inventory table (Resale Items) view:
It finds the records.
Automation fails, even though it finds the Record IDs.
Unfortunately, the “Find Records” action (and the subsequent “Update Record” action) doesn’t work in the way that any of us would expect it to work.
What you were expecting is what most of us were expecting, which is that Airtable would loop through the found Record ID’s and update each one of the records that it found. But unfortunately, it won’t do that.
In your final screenshot above, you’ve pasted in the “List of Record ID’s” into the “Record ID” field, but the “Record ID” field can only handle a single Record ID. You pasted in an entire array of Record ID’s expecting Airtable to loop through each one of those records and update each one of those records, but unfortunately, Airtable can only handle ONE Record ID there.
I would also email Airtable at email@example.com to ask them to improve/fix how this functions.
Yesss, that would be amazing! That would really open up an entire world of possibilities, and I think that’s what all of us were initially hoping for as the companion to the “Find Records” action.
Scott, thank you for this post. It now makes sense why that doesn’t work. I know the lookup field is the best option. The problem is I would need to backlog about 6 months of old records in the main table that don’t exist. We are only about 7 weeks in with Airtable and most of the old inventory was imported, but I have no records for it in the main table. I do think I have another option but it means I am going to use the lookup table with a trigger. I only added the lookup table for an example. I appreciate your insight, Scott! Thank you for always being active on here.