Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Find and update records at a scheduled time

Topic Labels: Automations
1544 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Jonathan_Gunne1
6 - Interface Innovator
6 - Interface Innovator

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. 

Screenshot 2023-07-07 at 4.52.04 PM.png

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. 

Screenshot 2023-07-07 at 5.02.06 PM.png

 

5 Replies 5

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.

.

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). 

Did you even read what I wrote? Try rereading slowly. 

Snarkiness accepted. Missed the first line, obviously. 

I'll just have to build several of them.

Lol, perfect! Glad you have the solution now! 🙂