Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 09, 2022 02:39 AM
Use case:
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
Screenshot here:
Mar 09, 2022 03:16 AM
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:
Mar 09, 2022 04:41 AM
thanks ScottWorld
shame!
don’t think my usecase is worth step 2 or 3, so I’ll just process manually for now