keep getting error message when a record is modified
Hello I keep getting this error message when I put the field as view only.
<qdbapi>
<action>API_EditRecord</action>
<errcode>34</errcode>
<errtext>You cannot change the value of this field</errtext>
<errdetail>You do not have sufficient permission to set the value of the restricted field named "Morning Punch Time" with field id 7</errdetail>
<rid>11</rid>
<num_fields_changed>0</num_fields_changed>
<update_id/>
</qdbapi>
This is the code for one of the buttons I'm using. is there a better way to do this so people aren't able to change the date and time after they have clocked in.
If(IsNull([Morning Punch Time]),
URLRoot() & "db/" & Dbid() &
"?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_7=" &
URLEncode (Now())
&"&rdr=" & URLEncode(URLRoot()& "db/"
& [_DBID_TIME_CARDS] & "?a=dr&rid=" & [Record ID#]),
"javascript:alert('This has already logged in.')")
This is the code for one of the buttons I'm using. is there a better way to do this so people aren't able to change the date and time after they have clocked in.
If(IsNull([Morning Punch Time]),
URLRoot() & "db/" & Dbid() &
"?a=API_EditRecord&rid="& [Record ID#]
& "&_fid_7=" &
URLEncode (Now())
&"&rdr=" & URLEncode(URLRoot()& "db/"
& [_DBID_TIME_CARDS] & "?a=dr&rid=" & [Record ID#]),
"javascript:alert('This has already logged in.')")
------------------------------
BLAKE CARLSON
------------------------------
