Discussions

Expand all | Collapse all

keep getting error message when a record is modified

  • 1.  keep getting error message when a record is modified

    Posted 26 days ago

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


  • 2.  RE: keep getting error message when a record is modified

    Posted 26 days ago
    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
    ------------------------------



  • 3.  RE: keep getting error message when a record is modified

    Posted 26 days ago
    How exactly do i do that??

    ------------------------------
    BLAKE CARLSON
    ------------------------------



  • 4.  RE: keep getting error message when a record is modified

    Posted 26 days ago
    I am guessing from your post that you or someone has gone into the field properties and set certain Roles to be View only.  So that would need to be changed to allow editing of that field.

    To set the from properties you go to that field on he form, and there is a checkbox to make a field Read Only.

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



  • 5.  RE: keep getting error message when a record is modified

    Posted 26 days ago
    i was able to figure it out thank you for your help Mark.

    ------------------------------
    BLAKE CARLSON
    ------------------------------