!Change Value in every row which are under specific condition on the same time every day!

[Xuxun_huang]

Hi guys,
please help
I have the data 2 columns as explained below

Step Status
A Active
B Inactive
A Inactive

As showed above, I would like to set a bot to change the data from “A” to “B” on 1 pm every day. If the Status is “Inactive”
The result should be The row 3 → change the data from A to B on 1 pm because the status is Inactive already.

Please, help
for further question, Can it apply for the virtual column as well?
I mean if the status column is an virtual column which is embeded formula inside to calculate whether it is “Active” or “Inactive”

[WillowMobileSys]

You could use a Scheduled Bot or a Virtual Column.

Virtual Columns are recalculated every time there is a Sync so I would lean towards a Bot. That way the processing is only once per day and happens on the servers.

[Xuxun_huang]

I try using BOT .

But, nothing has changed.

Im not sure whether my code is correct or not

[LAIVANHOA]

can i see your code ? may be somebody will help