Formula URL Button that goes to XML page

Question

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:

<action>API_EditRecord</action>

<errtext>No error</errtext>

<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
------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community