Yeah, unfortunately, the “find records” action doesn’t work in the way that the vast majority of us Airtable customers actually wanted it to work. It’s extremely disappointing.
The “find records” action will ONLY generate an array of found records — which can be used for sending emails to that array, or dumping that entire array into a single field. But that’s it. You can’t actually loop through the records in the array and update each record individually (unless it’s a found set of only one record).
Since you can dump all the Record ID values into a single field, you might be able to figure out something different that way, but in general, there are only 3 ways to work around this limitation:
- Try to completely recreate your automation so that it only triggers on one record at a time (instead of finding a bunch of records).
- Write a custom script that updates each record that was found in the “find records” action.
- Use an external automation platform like Zapier or Make.com. I prefer Make, because Zapier has its own set of limitations (and is pricier too). But Make is much harder to learn.