Discussions

 View Only
  • 1.  Formula URL Redirect to Report

    Posted 03-23-2022 13:34
    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/" & [TABLE] & "?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
    ------------------------------


  • 2.  RE: Formula URL Redirect to Report

    Posted 03-23-2022 13:39
    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
    ------------------------------



  • 3.  RE: Formula URL Redirect to Report

    Posted 03-23-2022 14:09
    Thank you!

    ------------------------------
    Thanks in advance,
    Jennifer Paschal
    ------------------------------