Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jan 08, 2024 12:26 PM - edited Jan 08, 2024 12:28 PM
Hello everyone! I'm fairly new to Airtable and have a question as I'm building my database.
I've found it helpful for me to assign "focus times" for tasks independently from their due date in previous systems, so I added a Single Select field named "Status" that has several options: Today, Tomorrow, This Week, Backlog, Completed, and On Hold. I have attached a screenshot of how that looks.
Is there a way to create an automation that (at midnight) automatically updates anything with the Tomorrow status to have a Today status instead? I was able to create an automation to change a singular record, but I failed to find a method to update them all. I'm not sure if it's impossible, or if I just don't understand automations enough yet.
Regardless, thanks so much, and have a great day!
Solved! Go to Solution.
Jan 08, 2024 02:21 PM
Just be sure to add a repeating action to loop through the found records, or else you won't be able to update the found records (even if there is just one).
Jan 08, 2024 02:06 PM
Hi @bribrimcb
You can use the 'find record' action after the trigger if you are using the 'at a specific time' trigger currently. Use the find record action to find all the tomorrow records and then use the update record action to act on all the 'found' records.
Jan 08, 2024 02:21 PM
Just be sure to add a repeating action to loop through the found records, or else you won't be able to update the found records (even if there is just one).
Jan 08, 2024 02:49 PM
I think this might be where I'm getting tripped up. I have a repeating action, but maybe I put it in the wrong place? This is the setup I have, and it only updates one task instead of any task with the "Tomorrow" status:
Jan 08, 2024 03:03 PM
Yes, your automation is setup correctly. You can't do a test on more than one record at a time, so you'll need to wait until your automation runs.
Jan 08, 2024 03:20 PM
...I can't believe I got stuck on the most obvious part of the whole thing. I'm hanging my head in shame. Thank you to you both, and happy 2024!
Jan 08, 2024 03:24 PM
You're welcome! Glad I could help, and Happy New Year! ☺️