Skip to main content
Question

quickbase error

  • September 9, 2017
  • 0 replies
  • 24 views
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 
    This topic has been closed for replies.

    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
    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
    • Liangxie
    • Author
    • Registered
    • September 9, 2017
    it's work, thanks a lot!
    Terms & ConditionsAccessibility statement