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 ?

Answers

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭

    Hi @Alan R,

    Smartsheet Forms only create new rows. They do not modify existing rows. That unfortunately is not an option.

  • AravindGP
    AravindGP ✭✭✭✭✭✭

    Hi @Alan R ,


    Instead of using a QR code in the exit, you can set up update request workflows in your sheet to send out an update request for the row at a certain time to the people who have signed in. They can update the exit/sign out time for the same row using that form which gets sent to their email. This way, you won't have two rows for the same person on the same day.

    Thanks,

    Aravind GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com