Skip to main content
Solved

Updating Single Select Fields at Chosen Time

B
Forum|alt.badge.img+3

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!

Best answer by ScottWorld

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

View original
Did this topic help you find an answer to your question?

6 replies

E
Forum|alt.badge.img+15
  • Ella11
  • Inspiring
  • 57 replies
  • January 8, 2024

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.

ScottWorld
Forum|alt.badge.img+33
  • ScottWorld
  • Brainy
  • 8778 replies
  • Answer
  • January 8, 2024

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

E
B
2 people like this
  • E
    Ella11
  • B
    bribrimcb
B
Forum|alt.badge.img+3
  • bribrimcb
  • Author
  • New Participant
  • 2 replies
  • January 8, 2024
ScottWorld wrote:

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


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:



ScottWorld
Forum|alt.badge.img+33
  • ScottWorld
  • Brainy
  • 8778 replies
  • January 8, 2024

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.

B
1 person likes this
  • B
    bribrimcb
B
Forum|alt.badge.img+3
  • bribrimcb
  • Author
  • New Participant
  • 2 replies
  • January 8, 2024
ScottWorld wrote:

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.


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

ScottWorld
1 person likes this
  • ScottWorld
    ScottWorld
ScottWorld
Forum|alt.badge.img+33
  • ScottWorld
  • Brainy
  • 8778 replies
  • January 8, 2024

You're welcome! Glad I could help, and Happy New Year! ☺️

Reply


Most helpful members this week

Terms & Conditions