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.
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.