Forum Discussion

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
6 years ago

URL Button Formula Error

What's wrong with my formula:
URLRoot() & "db/" & Dbid()
& "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_855=1"

I am getting this error:
This XML file does not appear to have any style information associated with it. The document tree is shown below.
<qdbapi>
<action>API_EditRecord</action>
<errcode>0</errcode>
<errtext>No error</errtext>
<rid>5783</rid>
<num_fields_changed>1</num_fields_changed>
<update_id>1573764171032</update_id>
</qdbapi>


------------------------------
George Bramhall
------------------------------
APIs and custom code
Button
Formulas and functions
  • AustinK's avatar
    AustinK
    Qrew Commander
    6 years ago
    That is not an error it is telling you it was successful and changed 1 field.

    <errtext>No error</errtext>

    Are you not seeing the field update with the new information?
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    George
    After you do an API call you need to refresh the page or redirect the to land the user n a record or report.  That will suppress the success message.

    Try this

    var text URL = URLRoot() & "db/" & Dbid()
    & "?act=API_EditRecord&rid=" & [Record ID#]
    & "&_fid_855=1";

    "javascript:" &
    "$.get('" &
    $URL &
    "',function(){" &
    "location.reload(true);" &
    "});"
    & "void(0);"

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