Update all yesterday tasks to today

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

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.

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.