Member-only story
A Time Based Automation
to delete checked rows older than 30 days
In the community a question came up expressing a feeling many makers might have had one day. Are we sure we want to take the risk to have all rows deleted while we only intent to have some removed?
Evaluate all rows
Automations run over every row of the defined table(s), but do not run their instructions (like deletete thisRow) on every row. In order to understand where to execute the instruction, the automation simple checks everything before running.
When does an automation run?
An automation runs when you tell it to run. It runs when the doc is closed and when you are not behind your computer, when you machine felt asleep and is getting cold. It works independently from you and it does the job for you. The maker instructs, the automation executes.
KISS
In my community response I focused on simplicity. You need a rule that tells when a row is ready to be deleted. The rules I created are…
