Forum Discussion

AndrewOrner's avatar
AndrewOrner
Qrew Cadet
7 years ago

EditRecord URL button functional (errcode 0) but doesn't edit record (num_fields_changed 0)

I'm attempting to build a button that changes the "Status" (ie. FID 52) of a record to "Complete"

Here's my formula: 
URLRoot()&
"db/"& Dbid()&"?a=API_EditRecord&rid="&
[Record ID#]&
"&apptoken=XXXX"&
"&_fid_52=Complete"
& "?a=dr&rid=" & [Record ID#]

I receive the below xml:
<qdbapi>
<action>API_EditRecord</action>
<errcode>0</errcode>
<errtext>No error</errtext>
<rid>243</rid>
<num_fields_changed>0</num_fields_changed>
<update_id>1540387215968</update_id>
</qdbapi>

The button is not updating the fid 52 value- any ideas? 
APIs and custom code
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    7 years ago
    TRY THIS:

    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=xxxxx&rid=" & [Record ID#] &
    "&_fid_52=" & URLEncode("Complete") &
    "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])
  • AndrewOrner's avatar
    AndrewOrner
    Qrew Cadet
    7 years ago
    Thanks for the speedy reply, but unfortunately this formula did not resolve my issue. 

    The field in question ("Status" fid 52) is Type: Text - Multiple Choice, do you think that could affect it? There are two choices for this field: Initiated, Complete
    • LauraThacker's avatar
      LauraThacker
      Qrew Captain
      7 years ago
      A true text-multiple choice field should not have any issues.  Only a List-Text field would need to be handled differently.  If you would like to call me, we can do a screenshare to troubleshoot. My # is 626 771 0454