Forum Discussion

NehaRaghav1's avatar
NehaRaghav1
Quickbase Staff
2 years ago

Formula URL error

Trying to change the value of a multiple choice field using formula URL for a different Record ID 

getting following 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>215</rid>
<num_fields_changed>0</num_fields_changed>
<update_id>1675336884376</update_id>
</qdbapi>






URLRoot()&"db/"&[_DBID_TASKS]&"?a=API_EditRecord&rid="& [Successor Task Record ID] &"&apptoken=***********************&_fid_57= In Progress"

------------------------------
Neha Raghav
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago
    it is not actually an error, in fact it is a success message. When you call an API from QuickBase it feels compelled to spit out on the screen a success or failure message. In order to suppress that you need to redirect after executing that URL to learn the user somewhere.

    When you string two successive URL calls together there is a generic syntax like this.


    $URLONE
    & "&rdr=" & URLEncode($URLTWO)

    So, for example you might do

    var text SetInProgress = URLRoot()&"db/"&[_DBID_TASKS]&"?a=API_EditRecord&rid="& [Successor Task Record ID] &"&apptoken=***********************&_fid_57= In Progress";

    var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();

    $SetInProgress
    & "&rdr=" & URLEncode($RefreshPage)



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------