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
-
Hi @Alan R,
Smartsheet Forms only create new rows. They do not modify existing rows. That unfortunately is not an option.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives