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?