Action, to delete certain data set in columns

[Rhys]

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

[Steve]

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)

[Rhys]

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

[Steve]

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

help.appsheet.com

Actions: The Essentials

Learn how to use actions to modify data and navigation in your app.

[Rhys]

much appreciated, thanks

[meshy]

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

[Steve]

Either:

table[key-column]

Or:

FILTER("table", TRUE)

[SEUAdmin]

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.

[meshy]

Many thanks Steve - much appreciated