I am using Coda to manage my TODO list and loving it.
I have sets of things that I like to check in on periodically. Things like doing a balance workout once a week, updating my investments spreadsheet once a month or getting the gutter people to come clean our gutters early Fall before the rains. I do this manually by having these things in a google spreadsheet and periodically adding to my todo list by manual scanning. I would love to be able to automate this using Coda.
A sample doc with two tables is here.
Roughly, I want to be able to run a piece of code every Sunday. It will iterate through each row in the “Periodic Tasks” table and if the next instance of a particular task (in the future) is in the upcoming week, I want to insert a row into the TODO List table.