Issue with Subtraction in Minutes

Bugs
1

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:

Screenshot 2024-10-20 at 1.48.34 pm
Screenshot 2024-10-20 at 1.48.34 pm768×616 35.6 KB

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.

Screenshot 2024-10-20 at 1.49.37 pm
Screenshot 2024-10-20 at 1.49.37 pm936×520 32.9 KB

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?

2

28,821,943 minutes * 60 seconds = 1,729,316,580 which is suspiciously close to the UNIX timestamp around that time

Which means that dropdown’s value’s time is empty somehow during the calculation, maybe check that first

3

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 :slight_smile: