Discussions

Expand all | Collapse all

Formula URL Button that goes to XML page

  • 1.  Formula URL Button that goes to XML page

    Posted 11 days ago
    I have a formula URL button that is performing the intended action of updating the current record but it isn't returning the user to the current record. Instead, an XML page is showing with the results of the button. XML results show no errors; but how do I get the URL button to just update the record and then refresh the current record page?

    XML:

    <qdbapi>
    <action>API_EditRecord</action>
    <errcode>0</errcode>
    <errtext>No error</errtext>
    <rid>1</rid>
    <num_fields_changed>0</num_fields_changed>
    <update_id>1595855550100</update_id>
    </qdbapi>

    URL Formula Field:

    var text approve = URLRoot() & "db/" & [_DBID_TIMECARDS] & "?a=API_EditRecord&apptoken=xxxxxxxx&rid=" & URLEncode ([Record ID#])

    & "&_fid_11=" & URLEncode(ToBoolean("yes"));

    var text rdr = URLRoot() & "db/xxxxxx?a=API_EditRecord&apptoken=xxxxxxxxxxxxx&rid=" & URLEncode ([Record ID#]);

    $approve
    & "&rdr=" & URLEncode($rdr)


    ------------------------------
    Niraj Shah
    ------------------------------


  • 2.  RE: Formula URL Button that goes to XML page

    Posted 11 days ago

    the problem is in the redirect 


    var text rdr = URLRoot() & "db/xxxxxx?a=dr&rid=" & URLEncode ([Record ID#]);



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Formula URL Button that goes to XML page

    Posted 11 days ago
    Thanks, Mark!

    ------------------------------
    Niraj Shah
    ------------------------------