Forum Discussion

NehaRaghav1's avatar
Qrew Member
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.
<errtext>No error</errtext>

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

Neha Raghav

1 Reply

  • MarkShnier__You's avatar
    Qrew #1 Challenger
    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.

    & "&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();

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

    Mark Shnier (Your Quickbase Coach)