I have a database of sign in / sign out logs to determine how long people are on a particular site for record keeping. I created a QR code for people to scan and log when they signed in and then when they sign out. On sign out I run a workflow as below:
It has been working well for some time, and now it seems to decide when it will / will not work. You can see below extract from the database, there’s some that are correct in time around 4-500 mins. Then there’s others that have a number in the millions, yet when you look at the date and time between it should be only a few hundred.
oddly, when you open the data up and save it again, it goes back o the correct value. Can anyone help with what this issue may be? I would think if it is working before and does still work regularly that this is a bug?
That’s incredible! Thanks @tylerboodman. The drop down can’t be empty as its a mandatory field, but my guess from what you’ve said is because I am updating both fields at the same time, the database may beat the timeinmunites field from time out, making it seem empty when updated, I just split the workflow into 2 steps and tested several times in a row and it worked each time, hopefully that is the solution
