I’m really struggling to get my head around this one.
I’m trying to build a touchless clock-in and out system for employees in our building.
The plan is to use a card with a QR Code generated from the UNIQUEID in our Employees table (Employee ID).
My other table holds the clock in and out data, with references to the Employee ID, set to scannable. This is all very simple. I can scan the card and get a Clock In written to the database. However, when I scan to clock out, I’m creating a new row.
What I’ve tried so far:
I tried a LINKTOROW and LINKTOFORM expression, with the scanner in a separate table, which I couldn’t get to correctly update only the “Clock Out” column.
Tried having separate tables for “In” and “Out” forms, then collecting those in a third table. Could not get the data to write to the third table at all.
I’ve looked through a couple of threads here, and [tsuji_koichi] had come closest to what I’m hoping to do, but can’t see how that data is recorded. And a lot of the sample apps seem to not be working/offline at the moment.
Is anybody able to offer any insight on this? I’m sure I was heading down the right path, but probably made some rookie mistakes!
EDIT: Probably more helpful if I add the whole formula!
So action created, " Go to another view within this app" with
IN([Employee ID], JS_ClockIn[Employee ID]),
LINKTOROW([Employee ID], “JS_ClockIn”),
LINKTOFORM(“JS_ClockIn_Form”, “Employee ID”,[Employee ID])
Then another batch action of this + delete to remove the QR scan. With no data in the table, this works perfectly, to create the form as needed. However it’s not deleting the scan from the table.