Forum Discussion

NirajShah4's avatar
NirajShah4
Qrew Cadet
5 years ago

Formula URL Button that goes to XML page

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
------------------------------
  • 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
    ------------------------------
    • NirajShah4's avatar
      NirajShah4
      Qrew Cadet
      Thanks, Mark!

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