Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 03, 2021 01:29 AM
If I find a bunch of records in step x and try to update them in step y I’m getting the following error: ‘received invalid inputs’.
According to the docs (Find records automation action – Airtable Support) it should work: “One recommendation is to use the update record action in order to update one set of records using data from the records found using the “find records” action outlined in this article.”
How?
Just to be clear, it works fine with 1 record, just not with a list.
Mar 03, 2021 05:09 AM
Unfortunately, Airtable’s Automations feature doesn’t work in the way that the vast majority of us (maybe ALL of us?) would expect it to work. :frowning: :frowning:
See my comments here:
Mar 03, 2021 05:13 AM
That’s all good and well, but the quoted text from the help explicitly tells me it should work.
So it’s not about expectations, it’s not working as advertised. Right? :slightly_smiling_face:
Mar 03, 2021 05:27 AM
Thinking about this some more, you can update a set of records, as long as you only want to update a parent table. :confused:
Talking with support now to clear this up.
Mar 03, 2021 05:37 AM
Yeah, that article is wrong… or at best extremely misleading. Airtable should fix that article.
Right, which is exactly what I outlined in my other message that I linked to above.
Unfortunately, the only thing we can effectively do with the “Find Records” action is copy-and-paste the group of record ID’s into a linked record field. Ostensibly to update the parent record.
For anything more than that, you would need to write a custom JavaScript or use a professional automation tool like Integromat. (Note that I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link contains my personal referral code.)
Mar 03, 2021 05:42 AM
I rather use my own automation tool in that case (note that I am a professional Airtable consultant and developer, and the tool contains my personal code). :stuck_out_tongue_winking_eye:
Mar 03, 2021 12:13 PM
Here’s the official line: “I did get confirmation from the engineering team that it is not possible to update multiple records with this action. It will fail if the “Find Records” action is finding more than one record.”
I suggested improving the article.
Sep 21, 2022 12:10 AM
Thank you guys for the inputs,
i hope the AT team will improve this because there is no interest to use the update automation feature.