Hi,
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
Rhys
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)
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
Can you advise how I can reference all rows? I know e.g. how to reference say rows 1-5 by LIST(1,2,3,4,5). However, I want to be able to set values of all rows in column. Thanks
Either:
table[key-column]
Or:
FILTER("table", TRUE)
Hey @Steve,
I followed this to create an Action where it would delete a value on a specific column, when i tried the action i get an error "Action failed, User ID is required", I am only changing the value on 1 column, not the one is faling.
Many thanks Steve - much appreciated
User | Count |
---|---|
18 | |
14 | |
11 | |
7 | |
4 |