at 8.00am every weekday check table to see which records in a particular view (view pulls records that meet the following two conditions: 1) Status = SCHEDULED 2) Email to KAE sent (scheduled) = false) Trigger works Find action works
I then send out an email to a list of people showing the records in that view Action works
Then I want to update the records to mark them as processed (which will also take them out of the view) Action does NOT work
I have tried everything, just cannot get this to work
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.