Mar 12, 2021 07:54 PM
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.
Mar 12, 2021 09:14 PM
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.
Mar 12, 2021 09:45 PM
The documented current purpose is to render a list of records within the body of an email using the Send Email/G Mail action.
Mar 12, 2021 09:49 PM
Thank you, that’s another action that I forgot! I can see that being useful.
Mar 12, 2021 09:55 PM
No word on if they’ll do it, but I can see some time in the future them adding a separate “Update records” action to take in an array of record ids.
Mar 12, 2021 10:45 PM
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.
Mar 12, 2021 11:24 PM
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.
Mar 12, 2021 11:31 PM
Kamille, thanks for being a staple within the community. I recently stumbled upon BuiltOnAir and have been backlogging episodes. Keep up the good work.
Mar 13, 2021 11:10 AM
Thank you! Glad you like the show :slightly_smiling_face:
Mar 27, 2021 09:21 AM
Can I give this more than a thumbs up? Maybe a gold star - :star2: