Forum Discussion

Liangxie's avatar
Liangxie
Qrew Cadet
7 years ago

quickbase error

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 
Ask about Quickbase functionality
Errors

3 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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