Forum Discussion

GeorgeBramhall1's avatar
GeorgeBramhall1
Qrew Member
4 years ago

Edit a Record in a Different form and then stay on that form after saving

I am trying to create a URL formula button on a form that Edits the Record in a Different form and then stays on that form after saving. This formula returns me to the orginal form after saving. What do I add to to the formula that keeps me on the new form?

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

------------------------------
George Bramhall
------------------------------
APIs and custom code
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    try this

    var text EDIT = URLRoot() & "db/" & Dbid() & "?a=er&dfid=10&rid=" & [Record ID#];
    var text Display = URLRoot() & "db/" & Dbid() & "?a=dr&dfid=10&rid=" & [Record ID#];

    $EDIT
    & "&NextURL=" & URLEncode($Display)

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • GeorgeBramhall1's avatar
      GeorgeBramhall1
      Qrew Member
      4 years ago
      Thanks Mark!! Ahuva???

      ------------------------------
      George Bramhall
      ------------------------------
  • AhuvaBrown's avatar
    AhuvaBrown
    Qrew Cadet
    4 years ago
    I solved this issue with a custom edit button using this url:
    URLRoot() & "db/" & Dbid() & "?a=er&dfid=yourformID&rid=" & URLEncode([Record ID#])& "&z=" & Rurl()

    z=Rurl() should return you to the url from where you pressed the edit button, so in this case, the same form in display mode.

    ------------------------------
    Ahuva Brown
    ------------------------------