Discussions

Expand all | Collapse all

quickbase error

  • 1.  quickbase error

    Posted 09-09-2017 00:29
    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 


  • 2.  RE: quickbase error

    Posted 09-09-2017 00:34
    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


  • 3.  RE: quickbase error

    Posted 09-09-2017 00:34
    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


  • 4.  RE: quickbase error

    Posted 09-09-2017 00:43
    it's work, thanks a lot!