Action, to delete certain data set in columns

AppSheet AppSheet Q&A
,
1

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

2

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
3

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

4

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

5

much appreciated, thanks

1 Like
6

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

7

Either:

table[key-column]

Or:

FILTER("table", TRUE)
1 Like
8

Many thanks Steve - much appreciated

1 Like
9

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.