Action, to delete certain data set in columns


I am searching a way to action deleting certain data only in certain columns. I don’t want to delete the entire row as it has certain data i need to keep for auditing purpose.

basically, I would like an automated way of deleting a set data that is over a year old.

many thanks in advanced


Action 1
For a record of this table: (table with old column values)
Do this: Data: set the values of some columns in this row

Action 2
For a record of this table: (same as action 1, above)
Do this: Data: execute an action on a set of rows
Referenced Rows: (list of rows with old column values)
Referenced Action: (action 1, above)

1 Like

Thank you Steve. I shall give this ago. where would you input this? sorry for the silly question.

Sounds like you might benefit from reading up on actions. Here’s a good place to start:

much appreciated, thanks

1 Like