Signing In/Out Register
We’re trying to set up a way for our operatives to sign in and out of a construction site by scanning a QR code at the entrance/exit.
We’ve got the basics sorted, a QR code that they can scan which then opens a short form for them to fill in with their name and company they work for and then submit to either sign in or out dependent on which QR code they have scanned
This then transfers on to a sheet that our site manager can use to see who is on site at any one time.
The issue we’re having is that each entry, signing in or out creates a new row. Is there a way that once somebody has signed in and their row is created, that when they come to sign out, they sign out on the same row as they signed in rather than creating a new row ?