"Expunge" Old Objects

tvinci
Participant V

Hi AppSheet,

I have a column in my table of Yes/No type titled “Expunge?”

And I want the value to be set to TRUE if the timestamp is a week old or older. So I wrote this expression to reference the row, but nothing happens when I press the button. What should I do?

Thanks,
Tiffany
select(routesV7[name],[Intended Day/Time].
<today()-7)

Solved Solved
0 11 204
1 ACCEPTED SOLUTION

Yeah then swap [name] for the key column. The SELECT must return Keys for the action to work.

View solution in original post

11 REPLIES 11

There shouldn’t be a period there after “[Intended Day/Time]”

Real column or virtual column?

What button?

I would have it be a virtual column with the App Formula of:

[Intended Day/Time] < (TODAY() - 7)

But I may be not quite understanding the situation

The period was a typo. I know what a virtual column is but how would you use it here?

I created a virtual column that returns true if the row is too old but nothing happens when I press the button to delete those rows.

How is your action set up?

Bahbus
Participant V

2X_5_5a3563baa97ac37eedcf4d6858b4fd693fb17ece.png
Is there more to this expression, or does it end with that check expungement column?

select(routesV7[name],[check expungement]=y)

If [check expungement] is a Yes/No column and [name] is your Key column, then your expression should be:
SELECT(routesV7[name], [check expungement])

[name] is not my key column but i’ll try what you suggested.

Yeah then swap [name] for the key column. The SELECT must return Keys for the action to work.

Or

FILTER( routesV7 , [check expungement] )

Top Labels in this Space