Change Value in Multi Rows

[Fabio_T]

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

[SkrOYC]

---

@Fabio_T wrote:

It is possible via action or bot

---

Yes

[Fabio_T]

can you tell me how to set the expression?

[Fabio_T]

you can help me!!?

[SkrOYC]

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..."