I’m creating an app for my team to monitor us working alone. Staff members can indicate that they are entering an unsafe location/work. I would like it to notify my supervisor if they have not selected that the work is complete within 2h. I know that the appsheet wait for a condition doesn’t currently support any sort of timer, so I created a column in google sheets (Unsafe Duration) that calculates the time since the form was created {HH:MM}. I then set it to send a text when [Unsafe Duration]=02:00. However, it sends the text immediately. Any ideas what I’m doing wrong?
LinkedIn
Twitter
