Modify status automatically

Hi, I need help with the following.
My app contains a table where I save orders, a column represents the status of my orders.
I need to be able to automatically modify the status of an order, for example when the current date is May to the scheduled date.
Try adding the following formula:
if ([Scheduled Date]> NOW (), โ€œIn Progress (Within Date)โ€, โ€œIn Progress (Delayed)โ€) as a state data formula, but I am unable to change it.

How do I have to execute this formula automatically, and chang e the value in my table?

Thank you very much for the help!!

Solved Solved
0 4 334
  • UX
1 ACCEPTED SOLUTION

You can use the same formula. The difference is when the value is calculated. With the virtual column itโ€™s recalculated every time you sync the app.

View solution in original post

4 REPLIES 4

Steve
Participant V


Have you thought to use virtual column for this purpose?

Hi Aleski. Honestly, I havenโ€™t thought about virtual columns, because I donโ€™t know how to solve it. Can you tell me how it would be? I am investigating the best way to solve it. thanks for your suggestion.

You can use the same formula. The difference is when the value is calculated. With the virtual column itโ€™s recalculated every time you sync the app.

Top Labels in this Space