Help

Update individual Records in a time interval automation

Solved
Jump to Solution
1138 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Opher_Yunger
5 - Automation Enthusiast
5 - Automation Enthusiast

I am trying to create an automation that updates all records in a table at a specific interval. The automation needs to look a single select field and based on what it is set to update another single select field.

The automation works when the trigger is update or create, but the time interval trigger is eluding me.

The automation is set to run every 15 minutes, and it looks for specific records. But How do we tell it to update individual records from the list it found?

Screenshot 2023-07-07 at 4.14.40 PM.png

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

You would need to loop through the records by using Airtable's new repeating groups action.

However, there are 2 big drawbacks that you should be aware of:

1. You can only find a maximum of 100 records in the "Find Records" step.
2. I noticed that you have conditional actions in your automation, but unfortunately, you can't combine both conditional actions & repeating groups in the same automation.

This is why I typically recommend that people use Make for their Airtable automations & integrations. Make has no limits, and you can also combine looping & conditionals.

There can be a bit of a learning curve with Make, which is why I created this basic navigation video for Make, along with providing the link to Make’s free training courses. And if you're looking for an expert Airtable consultant to help you with any of this, feel free to reach out to me through my Airtable consulting website.

See Solution in Thread

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

You would need to loop through the records by using Airtable's new repeating groups action.

However, there are 2 big drawbacks that you should be aware of:

1. You can only find a maximum of 100 records in the "Find Records" step.
2. I noticed that you have conditional actions in your automation, but unfortunately, you can't combine both conditional actions & repeating groups in the same automation.

This is why I typically recommend that people use Make for their Airtable automations & integrations. Make has no limits, and you can also combine looping & conditionals.

There can be a bit of a learning curve with Make, which is why I created this basic navigation video for Make, along with providing the link to Make’s free training courses. And if you're looking for an expert Airtable consultant to help you with any of this, feel free to reach out to me through my Airtable consulting website.

using the repeating groups action worked. I know I can use make, but I prefer to keep things in one platform whenever possible

 

That's great! Yes, I agree... if everything you need to do can be done within Airtable, then there is no need to use external apps.