Discussions

 View Only
  • 1.  URL Button Formula Error

    Posted 11-14-2019 15:44
    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
    ------------------------------


  • 2.  RE: URL Button Formula Error

    Posted 11-14-2019 15:55
    Edited by Austin K 11-14-2019 15:55
    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?


  • 3.  RE: URL Button Formula Error

    Posted 11-14-2019 16:05
    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
    ------------------------------