Hey guys - I would like to limit who can see a certain view in the app using the security in Data>Tables>Security Filter.
I want Homestead Managers to be able to view the rows that have their name in it, but not not other Homestead Managerโs names.
And then I also want Evaluators to be able to see all of the rows.
In the existing rows in this โGarden Feedback Formโ spreadsheet, I have both columns for Homestead Manager names and Evaluator names.
In another spreadsheet, titled โEmployeesโ, I have a column of [Employee Names] which would be equal to the โHomestead Managerโ names. And I have another Column where I have assigned people the status of โEvaluatorโ. I also have USEREMAIL() in this spreadsheet which I know I need for this all to work.
So how do I ask app sheet to show the view if the USEREMAIL() equals the name of the person in the spreadsheet? AND if you have status of Evaluator, you can see all rows?
Many thanks!
Miranda
LinkedIn
Twitter
