A deep-on-Airtable friend showed me a useful table for recurring tasks. Nice little low-code database tool for keeping yourself honest; a little like a todo list with better ergonomics.
High-level - I make recurring tasks, set their frequency and last performed date, and I get an email when something is due.
Here’s a look at some of mine, including some very overdue tasks:
At the heart of it is this formula, for the Days Until Service column:
{Service Every}-IF({✍️Last Performed✍️} = "", DATETIME_DIFF(TODAY(), CREATED_TIME(), 'days'),DATETIME_DIFF(TODAY(),{✍️Last Performed✍️},'days'))The admittedly finicky-to-set-up Frequency enum column is (and has to be):
Slap on top of that an automation that emails me when Days Until Service <= 0 and Bob is our uncle.
An improvement I’ve yet to implement: the ability to define tasks that must happen on a certain date, rather than after X time has elapsed since last performed. For seasonal tasks like, eg, fertilizing plants, if you’re routinely delinquent they’ll start to slip into the next season!