Forum Discussion

ChrisSwirtz's avatar
ChrisSwirtz
Qrew Cadet
3 years ago

Need a button to view current record in a different form

*Edited* I am looking to create a button on the main form that when clicked will Save the current record form and then show the info in that current record in a different form? I have tried the aut...
APIs and custom code
Buttons
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
np, look at your list of forms and observe the Form ID#.
Then make a Formula URL button like

URLRoot() & "db/" & dbid() & "?a=dr&dfid=10&rid=" & [Record ID#] 

That says to display the record on Form ID #10


------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • ChrisSwirtz's avatar
    ChrisSwirtz
    Qrew Cadet
    3 years ago
    Perfect, thanks! I knew it was something like this, just couldn't quite get it right.

    ------------------------------
    Chris Swirtz
    ------------------------------
  • ChrisSwirtz's avatar
    ChrisSwirtz
    Qrew Cadet
    3 years ago
    Mark,

    Would it be possible to add the save function to this formula? Like so when the user clicks the button, it saves the record as is before opening the new form?

    ------------------------------
    Chris Swirtz
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 years ago
      If the table is set in properties to auto save then when you push the button and it should save the record before we displaying it.

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------
      • ChrisSwirtz's avatar
        ChrisSwirtz
        Qrew Cadet
        3 years ago

        Hey Mark,

        I turned on the auto save as you said and have the button that takes the user to a different form set to open in the same window so it has to navigate away from the current form/screen. When I click on said button it does ask me to save the record first, which is what I want, but when it opens the subsequent form, it is in 'add new" mode instead editing the the new form with the same Record ID and info I just navigated from. It's like the save action doesn't allow for the button formula to pick up the newly created Record ID. 

        That being said, when I say hit "save & keep working", then hit the button, it works just fine. Which is why I wondered if I could incorporate the "save & keep working" function into the button formula.



        ------------------------------
        Chris Swirtz
        ------------------------------