Discussions

 View Only
  • 1.  Formula URL error

    Posted 02-02-2023 06:37
    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
    ------------------------------


  • 2.  RE: Formula URL error

    Posted 02-02-2023 09:50
    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
    ------------------------------