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 associate...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendit 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
------------------------------
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
------------------------------