I have an app that allows users to create a TASK that has a START TIME, END TIME and a STATUS of either open, closed or overdue. What I’m trying to accomplish is to have the STATUS change to “overdue” if the END TIME is less than NOW(). I have an action to make the change and I created a workflow to trigger it using this condition: (([Status] =“Open”) , [End Date] <= Now())
…but it only triggers when the task is updated. Is there a way to trigger the workflow or the action whenever the app is synced, or launched? I basically want users to wake up in the morning and see all current statuses of their tasks. Any help is greatly appreciated.