Jul 07, 2023 01:15 PM
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?
Solved! Go to Solution.
Jul 07, 2023 04:04 PM
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.
Jul 07, 2023 04:04 PM
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.
Jul 10, 2023 09:32 AM
using the repeating groups action worked. I know I can use make, but I prefer to keep things in one platform whenever possible
Jul 10, 2023 09:33 AM
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.