Forum Discussion

ChrisSwirtz3's avatar
ChrisSwirtz3
Qrew Member
3 years ago

Button that creates a new record based on the selection in the new record

I have an app with a Companies Table and a Offices Table related by a one Company to many Offices relationship. When a Company wants to create a new Office request, there is a few types of request to ...
Buttons
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
Yes, that is possible.  You would display a "report" of those users we discussed on the home page filtered where the User is the current user.  So it will be a one record report.  The only fields that you need to offer are the ones like [Create New Annual]  or [Create Renewal].

Since the user record knows their office, you would just adjust the buttons to have an extra line like

& "&_fid_999=" & [Related User Office]

so that he correct Office auto populates  .. although I think that we were going to also do that via a form rule anyways so this is sort of belt and suspenders.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
ChrisSwirtz3's avatar
ChrisSwirtz3
Qrew Member
3 years ago
So it would look something like this?



------------------------------
Chris Swirtz
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    yes

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • ChrisSwirtz3's avatar
      ChrisSwirtz3
      Qrew Member
      3 years ago
      Ok excellent, thanks! I was hoping there was a way to be able to break those buttons out on their own but I think this will end up working just find.

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