Skip to main content
Question

Formula URL error

  • February 2, 2023
  • 0 replies
  • 38 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement