Unfortunately, the only way that I can think of doing this easily is by removing the auto feature and using the action button instead.
Assuming that this is the final data structure and the o try we variables are non-negotiable (which is totally fine by the way!) I think you may want to look down the path of.
- Generating a “number” that is assigned to each sign in and sign out
- Have an ID that is a Concatenation of that number and the staff ID
- Have that “number” increase sequentially (generally not recommended) based on
IF the last row in this table that matches has a sign out, then add 1, if not, then don’t add the 1 so it will sign out instead
That last part is based on if the QR code in and out is the same.
If there are seperate QR codes for in and out, then really it would just be looking for if there is another row and then + 1 on the sequential.
Another thought I am having, are users scanning a QR code on a central device (such as one printed on an ID Card, but are scanning this on a “terminal”
OR
Have you printed out QR codes that staff are scanning on their own devices?
I will keep thinking about it though and see if I can come up with something.