Hi everyone,
In my task table, I want to be able to automatically change the date of a task if it’s not done by the end date. For example, if a task is due on September 30th and it’s not completed by then, it should switch to October 1st.
Thanks in advance! I’m very new to Coda, so your help is appreciated.
Hello and welcome to Coda.
What you need to do is to set up a time-based automation (Automations in coda). You probably have a progress column, and use the its value to setup the filter of the automation. So, every day, e.g. 7am, the automation will run, and if the task is not completed (progress not 100%) and the due date is less than today, you update the due date to today.
The formula will be something like that (i did not tested):
DBtasks.Filter(due < Today() and progress != 0).Foreach(
WithName(currentValue, task,
ModifyRows(task, due, Today())
))
I like to use the WithName formula when iterating through a list. The formula becomes more legible and prevents errors when using nested iterations.
Please note that automation is unlimited only in the Team plan. If you have a Pro or free account, you have to take this into consideration. As stated in Coda’s pricing, the free plan has 35 time-based automations per month per doc, while Pro has 100. If this is a limitation, I suggest putting the formula in a button and manually clicking it every day.
Best Regards,
Arnhold