Formula URL Redirect to Report

Question

Hello,I have a formula URL I am using as a button on a report to allow the user to add a new record. Once they save the record is there a way to redirect them back to the report they started from? Currently, when i click save and close it redirects me to the saved record view.I have tried adding & 'rdr=" & URLEncode(URLRoot() & "db/" &  & "?a=q&qid =130" )and also have tried just putting the direct link for the report into the formula but neither change the behavior when the new record is saved.------------------------------Thanks in advance,Jennifer Paschal------------------------------

MarkShnierYou · Answer

You can try using the usual native syntax

URLRoot() & "db/" & [_DBID_PROJECTS] & "?a=API_GenAddRecordForm&_fid_20=" & URLEncode ([Record ID#])
& "&z=" & Rurl()

That last BOLD part says "after saving to return to where you came from".

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

Sign up

Login to the community