LinkedIn
Twitter
I've searched the boards here and have found some info that has been helpful, but I have not found the solid answer to my problem.
I've built a time clocking app for my company for large projects. The one issue I am facing is the compiling of time. Currently I have it set up like a badge system. Each employee has a unique QR attached to their name. I have 4 forms attached to slices for clock in, lunch out, lunch in, and clock out.
The issue I am running into is that ideally I would like to reference the entry id(UNIQUEID) and be able to just edit and existing row. For example, if Emmett Jackson is already clocked in and he scans his QR on the clock out form, I would like that scan and save to update the "clock out" column in the same Entry ID row where he is currently clocked in. See the screen shot of the google sheet below.
Is it possible to do what I'm wanting to do?
