Adding new records based on user recognition
I have an app with a Companies Table and an Offices Table which have a 1 Company can have many Offices relationship. Is it possible to set it up so that when a User from one of the Companies logs into...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou would need to set up every user in a Users table in the app - a new table, not the User icon at the top left. Then make the Key field their userid. The associate each employee record with the company they belong to via a relationship with Companies.
Then on offices you make a relationship to users based on a reference field of [Current User] with a formula of User().
The look up their Company or related company.
The have a form rule populate the company field if its blank.
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------
Then on offices you make a relationship to users based on a reference field of [Current User] with a formula of User().
The look up their Company or related company.
The have a form rule populate the company field if its blank.
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------
Thanks Mark,
So adding a new user to that User Table would have to be done manually by someone correct? Perhaps make it a function of whoever does the inviting of users to also add them to the Users Table?
What about adding a User-List field to the Companies Table and selecting every User that is affiliated with that Company. Could we utilize something like that?
------------------------------
Chris Swirtz
------------------------------
So adding a new user to that User Table would have to be done manually by someone correct? Perhaps make it a function of whoever does the inviting of users to also add them to the Users Table?
What about adding a User-List field to the Companies Table and selecting every User that is affiliated with that Company. Could we utilize something like that?
------------------------------
Chris Swirtz
------------------------------