Skip to main content
Question

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

  • October 24, 2018
  • 0 replies
  • 30 views
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? 
    This topic has been closed for replies.

    Forum|alt.badge.img+12
    • LauraThacker
    • Registered
    • October 24, 2018
    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#])
    Laura Thacker (IDS) laura@intelligentdbs.com (626) 771 0454
    • AndrewOrner
    • Author
    • Registered
    • October 24, 2018
    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
    Terms & ConditionsAccessibility statement