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------------------------------
