- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 08, 2024 03:24 PM
You're welcome! Glad I could help, and Happy New Year! ☺️
