Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Update all yesterday tasks to today

Topic Labels: Automations
Solved
Jump to Solution
887 1
cancel
Showing results for 
Search instead for 
Did you mean: 
brewster3
4 - Data Explorer
4 - Data Explorer

I am building a simple daily task management automation. I want any task that was not Done to be forwarded to the next day at 3AM so when I start work I have all uncompleted tasks automatically in today’s task list. So far…

Trigger
When records matches conditions
When Date is yesterday
And Status is not Done

Action
Update record
Record ID: Record (step 1 Trigger) | Field values | Date
Fields: Date | Today()
Also tried DATEADD( Date, 1, ‘days’)

Trigger test ran successfiully.
Action test failed “Received invalid inputs.”

Wondering how to do this?
(New to Airtable.)

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

Do you need an Automation, or could you just use a Formula field? You have a limited number of Automation runs per month, and its best to reduce the number of Automations.

A simple formula could report “today” if the task isn’t “done” or the original date field if it is done:

IF(
   {Status} != "Done",
   TODAY(),
   {Date field}
)

Filter your “daily task” view to be based on the formula field, and you won’t need an Automation at all.

See Solution in Thread

1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus

Do you need an Automation, or could you just use a Formula field? You have a limited number of Automation runs per month, and its best to reduce the number of Automations.

A simple formula could report “today” if the task isn’t “done” or the original date field if it is done:

IF(
   {Status} != "Done",
   TODAY(),
   {Date field}
)

Filter your “daily task” view to be based on the formula field, and you won’t need an Automation at all.