Button click to populate a field with the current time
I'm using a formula URL button to input the current time in a "Clock-in" field. I have another formula URL button to input the current time in a "Clock-out" field. It works, and we have the employees use the mobile app to clock in/out each workday.
The issue we are having is that if the employee doesn't close out the app after clocking in, when they clock out, it will input the same time from when they clocked in.
Does anyone know how I would modify this code so it will capture the current time, every time, no matter if the app has been closed or not?
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=MYAPPTOKEN"
& "&rid=" & [Record ID#] & "&_fid_433=" & ToTimeOfDay(Now()) & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]))
------------------------------
Barry Dolan
------------------------------