I am trying to filter what different employees can see in the app.
Specifically I would like one crew to see only certain views and not others.
First question: is it possible to filter views, not just tables?
I am only seeing a security filter field in the table area.
However, I have some forms that use the same table, but I want one crew to see one form and not the other.
So if I can only filter the table and not the view, I don’t think what I’m asking is actually possible.
I know I could clone the app and make different apps for each crew, but I don’t want to have to regenerate and update multiple apps all the time.
This would be too much of a time suck for me during our busy season.
Second question: when putting an equation into the security filter (right now in a table), if I use the expression “Employees[Maintenance Crew Emails]” am I telling app sheet to SHOW it to the Maintenance Crew or NOT show it to the maintenance crew??
This is unclear to me.
Am I even using the correct expression/equation?
Also, how do I test the app to see if the table or view is actually hidden to that crew?
Thank you for your assistance! Miranda