Skip to content
a due datea statusif the status is “Recurring”if the frequency is defined
A common way that lead to coda is the need of a task management tool. This is a backdoor that open a whole new world of possibility, beeing so obivous that coda, in particular, is so much more than just a task manager.
Anyway, as it can make hyper-powerfull stuff, we assume that any basics feature can be found also in coda.
This is obviously the case of the epic and of course essential recurring tasks.
Here is a very dummy example, which is my easiest way to manage recurrent tasks !
Let’s assume a list of task, that would include :
What could be great for classical task, is to add a button that change the status to “Done” with this action below, and disabled if Status="Done"
ModifyRows(thisRow, [Dummy Tasks].Status, "Done")
New Task
Clear Dummy Task
Dummy Tasks
Task
Status
Due Date
Done
Watch Star Wars
Waiting
9/30/2022
Do the cleaning
Done
10/1/2022
Call my mother
Recurring
11/1/2022
Buy some food
Waiting
10/6/2022
Go to ACDC Concert
Waiting
9/13/2022
Working on secret report
In Process
10/2/2022
There are no rows in this table
By clicking the button, you will put the status on “Done”, and according to any filter we have, the task may disappear to clean your dashboard.
With recurring task, when we click to “Done” Button, we would like the task to remain and to be updated to the next date, according to a give frequency
💡 Very easy : just add a column “frequency” (number or slider) to put any frequency your recurring task you may have. Then, we modify the “Done” Button to check
If yes, rather than changing the status to “Done”, it adds frequency to the current due date. Here you are!
The action formula for Done 2.0 Button :
if(
thisRow.Status = "Recurring" AND thisRow.[Frequency (days)] != "",
ModifyRows(
thisRow,
thisRow.[Due Date],
thisRow.[Due Date] + thisRow.[Frequency (days)]),
ModifyRows(thisRow, [Dummy Tasks].Status, "Done")
)
Task
Status
Due Date
Done 2.0
Frequency (days)
Watch Star Wars
Waiting
9/30/2022
00
Do the cleaning
Done
10/1/2022
00
Call my mother
Recurring
11/1/2022
00
21Buy some food
Waiting
10/6/2022
00
Go to ACDC Concert
Waiting
9/13/2022
00
Working on secret report
In Process
10/2/2022
00
There are no rows in this table
Hope you enjoy this little trick ! Please visit to leave any comment, suggestion, or see my twitter feed !
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.