Forum Discussion

JENNIFERPASCHAL's avatar
JENNIFERPASCHAL
Qrew Trainee
3 years ago

Formula URL Redirect to Report

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
------------------------------
APIs and custom code
Button

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    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
    ------------------------------
    • JENNIFERPASCHAL's avatar
      JENNIFERPASCHAL
      Qrew Trainee
      3 years ago
      Thank you!

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