quickbase error

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
i creat one URL formula as below
 URLRoot() & "db/" & [_DBID_EXPRESS_SHIPPING_TRACKING]
& "?a=API_EditRecord&rid="&[Record ID#]&"&apptoken=bm2czcxzy&_fid_18=Close"

but i always get  error as below
<qdbapi><action>API_EditRecord</action>
<errcode>0</errcode>
<errtext>No error</errtext>
<rid>62</rid>
<num_fields_changed>1</num_fields_changed>
<update_id>1504916937061</update_id>

</qdbapi>

how to fix it thanks a lot 
Photo of Liang xie

Liang xie

  • 170 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
That is not an error, it is an XML response saying that the edit was successful.  But you do  not want to expose that to your users.

If you want to refresh the page after the button is clicked, use this syntax.


var text URL = URLRoot() & "db/" & [_DBID_EXPRESS_SHIPPING_TRACKING]
& "?a=API_EditRecord&rid="&[Record ID#]&"&apptoken=bm2czcxzy&_fid_18=Close";
"javascript:" &
"$.get('" & 
$URL & 
"',function(){" &
"location.reload(true);" &
"});" 
& "void(0);"


If you always name your formula variable URL, then that will work.

Here is the help text on what a formula variable is
http://help.quickbase.com/user-assistance/formula_variables.html
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
That is not an error, it is an XML response saying that the edit was successful.  But you do  not want to expose that to your users.

If you want to refresh the page after the button is clicked, use this syntax.


var text URL = URLRoot() & "db/" & [_DBID_EXPRESS_SHIPPING_TRACKING]
& "?a=API_EditRecord&rid="&[Record ID#]&"&apptoken=bm2czcxzy&_fid_18=Close";
"javascript:" &
"$.get('" & 
$URL & 
"',function(){" &
"location.reload(true);" &
"});" 
& "void(0);"


If you always name your formula variable URL, then that will work.

Here is the help text on what a formula variable is
http://help.quickbase.com/user-assistance/formula_variables.html
Photo of Liang xie

Liang xie

  • 170 Points 100 badge 2x thumb
it's work, thanks a lot!