Change Value in Multi Rows

AppSheet AppSheet Q&A
1

I have a table with three columns; order, number, status,
I would like the status to change in value when I enter a new order that uses the same number, for all rows.. that contain the same value in the number column

That is, I have an order with number 333 with active status, and when I insert another order with number 333 I would like the previous status to become inactive and the latter insert Active. It is possible via action or bot.

Thanks More

2

Yes

3

can you tell me how to set the expression?

4

you can help me!!?

5

Hi @Fabio_T , I’m sorry for not replying earlier.

I shifted to mainly payed support, and I’m bussy serving my clients.
But I’m not the only one that can help, for sure someone like @Steve could provide with an awesome expression to do this.

You can also read the docs about SELECT()/FILTER() and use actions like “Set the value of some columns…”