Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 07, 2023 02:03 PM
I am currently using the "when a record is updated" trigger paired with 10 separate condition groups, each with its own "update record" action to change the status of records that meet specific criteria.
The problem is that it relies on the record to be updated in order to trigger. I'd like to do this same thing using the "at a scheduled time" trigger so I can run this automation daily whether a record was updated or not. I've tried using "find records" to get a list of records to update followed by an "update record" action but I get a "received invalid inputs" error.
Jul 07, 2023 05:14 PM
You would need to loop through the records by using Airtable's repeating groups action.
However, there are 2 drawbacks that you should be aware of:
1. You can only find a maximum of 100 records in the "Find Records" step.
2. You have conditional actions in your original automation. But if you need conditional actions in your new “repeating group” automation, you won’t be able to do that because unfortunately Airtable won’t allow you to combine both conditional actions & repeating groups in the same automation.
If you find yourself needing to combine conditional groups & repeating actions in the same automation, I would highly recommend using Make for your Airtable automations.
.
Jul 08, 2023 05:34 AM
I'm not sure why a third-party tool would be necessary. This seems like a pretty easy task. My "Find Records" step is pulling well under 100 records. This doesn't work even without conditional actions (see the second screenshot).
Jul 08, 2023 05:46 AM
Did you even read what I wrote? Try rereading slowly.
Jul 08, 2023 05:54 AM
Snarkiness accepted. Missed the first line, obviously.
I'll just have to build several of them.
Jul 08, 2023 08:35 AM
Lol, perfect! Glad you have the solution now! 🙂