Button to create a date and time
I am trying to create a clock in/out like a timesheet. I would like to create a button that adds the current date and time to the field. I have tried looking for this formula that is probably very ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf you are looking for a button that would work in View mode to update field ID # 99 to the current date/time, it would look like this
var text ClockIn = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xxxxxxxxxx" // only required if you gave application tokens enabled.
& "&_fid_99=now";
var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();
$ClockIn
& "&rdr=" & URLEncode($RefreshPage)
​
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
