You’re offline. This is a read only version of the page.
I'm building an app from a database that will contain data from multiple manufacturing facility locations. I need to filter the view so that the user can only see the data for their location. Any help would be appreciated!
You will need a list of Users emails and their associated location. Then, when the user logs in, capture the location in the App.OnStart: Set(loc,LookUp(userlist, email =User().Email, location)
However, according to Microsoft, App.OnStart will be deprecated and replaced by App.Formulas.
I am currently using Named Formula so instead of the above set function I am putting
loc=LookUp(userlist, email= User().Email, location);
You can then filter your database as Filter(database, Location = loc)
Share
Report
All responses (
Answers (
610
