Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 06, 2021 01:30 PM
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.)
Solved! Go to Solution.
Jun 06, 2021 03:40 PM
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.
Jun 06, 2021 03:40 PM
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.