Skip to main content

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.

Reply


Terms & Conditions