Forum Discussion

Qrew Cadet

3 years ago

Using printed QR codes to Clock In or Clock Out of a Task

I am setting up a timekeeping system and want to use printed QR codes to clock in and out of specific tasks (the codes would be on the bin of material being worked on). I have a URL for clocking in...

Integration

MarkShnier__You

Qrew Legend

If you're looking for the syntax to generate a QR code, try this as a Rich Text Formula field. Can you post back to confirm that it works. It's an interesting approach you are using to query for the current user.

"<img src=http://chart.googleapis.com/chart?cht=qr&chs=240x240&chl="
& URLEncode($URL)& "'>"

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

EdwardHefter

Qrew Cadet

3 years ago

I already have the QR codes. I am using a different source for them than Google, but I didn't see how to set colors in the Google one, and the colors help people figure out which one to scan.

Logging in - "<img src=\"http://api.qrserver.com/v1/create-qr-code/?color=00FF00&bgcolor=FFFFFF&data="&URLEncode([Clock In from Task])&"&qzone=1&margin=0&size=250x250&ecc=L\" alt=\"Scan this to log in\" />"

Logging out - "<img src=\"http://api.qrserver.com/v1/create-qr-code/?color=FF0000&bgcolor=FFFFFF&data="&URLEncode([Clock Out from Task])&"&qzone=1&margin=0&size=250x250&ecc=L\" alt=\"Scan this to Clock Out\" />"

I am hoping to find a way to have just one QR code that can figure out if the user is already clocked in or out (depending on the user name they are logged in under on their phone) and then do the appropriate Add or Edit action.

Figuring out if the current user is the one in the field tracking whose time card it is (FID 7) is something I found in the online help, as was using "&_fid_8=now&" rather than "&_fid_8=now()&". Using the formula now() would work find for clicking something online, but not for a printed QR code that isn't dynamic.

------------------------------
Edward Hefter
www.Sutubra.com
------------------------------

MarkShnier__You
Qrew Legend
3 years ago
I appreciate that lead on alternative methods to generate a free QR code.
https://goqr.me/api/doc/create-qr-code/

I can't see how a static QR code could make a decision. It seems to me that you need to add records to come kind of child table and have logic with Pipelines to decide what to do with that record. If you set the User field to default to the current user, then you can probably get the ADDRecord API to default that current user into that field.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- EdwardHefter
  Qrew Cadet
  3 years ago
  I hadn't considered putting the scan into a temporary record, including the Task ID and the User ID, and then running a pipeline against it. It could then figure out whether to clock in, clock out, or even clock out of the old task and clock into the new one. That's a great idea - thanks!
  
  ------------------------------
  Edward Hefter
  www.Sutubra.com
  ------------------------------