I have an app and I want it to open to users one at time in 20 second increments from when a action is triggered.
Each row has a different value to correspond to the amount of seconds, 0,20,40,60,80 ect. Currently I have the time the button was pushed in a column, then i was going to use a math column to add the seconds to the date. But when I put the seconds column into the equation on the math column I get an error invalid operation for date/time. How can I do this?
What does your math look like?
Math needs numbers or dates to work. Your format date column does not return a number. It’s a text based character string. You are better off using the original numeric WAIT column in your math instead.
Also, date math in glide is based on days. 1 equals 1 whole day. You need the decimal version of seconds, so change your math to look like this and make sure WAIT is referring to the unformatted version of seconds.
TURN + (WAIT/86400)
3 Likes
Thank you!
1 Like