Modify status automatically

[Adolfo_Enrique_]

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!!

[Steve]

help.appsheet.com

Reports

Generate reports and take actions on a schedule that you specify.

help.appsheet.com

Trigger Scheduled Reports on Specific Dates

A type of Scheduled Action, Scheduled Reports are a great way to automate whatever materials you need to send out regularly.

[Aleksi]

Have you thought to use virtual column for this purpose?

[Adolfo_Enrique_]

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.

[Aleksi · 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.