Skip to main content
Question

keep getting error message when a record is modified

  • September 30, 2020
  • 0 replies
  • 32 views


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.')")


------------------------------
BLAKE CARLSON
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • September 30, 2020
You should make the field view only on the FORM properties, but still allow it to be editable in the FIELD properties.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------