Multiple redirects in formula

Question

I have an embedded report that has a formula url button. The button updates a check box then edits that same record. When it is saved I want it to return to the record that had the embedded report. The first two parts of my formula work, the checkbox is edited, the form displays and I must complete it, but upon save it is not redirecting to the original record. Can someone offer insight in to what I may be doing wrong with the last redirect?

URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_43=1&apptoken=xxxx"
& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#])
& "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_BENE] & "?a=dr&key=" & [Related Beneficiary])

------------------------------
Jazmynn Cathey
------------------------------

MarkShnierYou · Answer

Not testing but try this.

URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_43=1&apptoken=xxxx"

& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#])

& URLEncode("&NextURL=" & URLEncode(URLEncode(URLRoot() & "db/" & [_DBID_BENE] & "?a=dr&key=" & [Related Beneficiary])))

The generic syntax is below but because you are redirecting after a manual save, you need to use NextURL

$URLONE
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHREE))

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community