I would like to run an automation on a daily basis that run's through a tables rows and deletes rows based on a date field in that row. If the date in that row is < NOW-14Days delete the row.
How can I do that? Where is some info on the formulas? Is there such thing as a cron trigger to setup the daily run?
Hi @Sven-df80 welcome to the forum and thank you for your question! One way to do this is to use an automation that is triggered on a date column in a table. Then you can overwrite that date column value to the next day in the same automation. You can then do the delete <Now()-14 rows in subsequent steps in your automation. Let us know if you have further questions!