Skip to main content
Question

URL Button Formula Error

  • November 14, 2019
  • 0 replies
  • 24 views
GeorgeBramhall2
Forum|alt.badge.img+11
What's wrong with my formula:
URLRoot() & "db/" & Dbid()
& "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_855=1"

I am getting this 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>5783</rid>
<num_fields_changed>1</num_fields_changed>
<update_id>1573764171032</update_id>
</qdbapi>


------------------------------
George Bramhall
------------------------------
This topic has been closed for replies.

  • AustinK
  • Quickbase Alumni
  • November 14, 2019
That is not an error it is telling you it was successful and changed 1 field.

<errtext>No error</errtext>

Are you not seeing the field update with the new information?
MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • November 14, 2019
George
After you do an API call you need to refresh the page or redirect the to land the user n a record or report.  That will suppress the success message.

Try this

var text URL = URLRoot() & "db/" & Dbid()
& "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_855=1";

"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement