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! Go to 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.
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.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |