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 auto save when navigating away function. It doesn't establish the Record ID# so the formula showing the current form also shows in the newly opened form.

------------------------------
Chris Swirtz
------------------------------
  • 40711's avatar
    40711
    Qrew Trainee

    Is there a way to create a "universal" button where you click it to edit whichever form you're on? We have 30+ forms for the same table, so whenever you hit "edit," it takes you to the form that is the default for your role. I want to edit whichever record The user is on

  • 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
      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
        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
      Perfect, thanks! I knew it was something like this, just couldn't quite get it right.

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