security filters

[Jester_Castillo]

I need help creating security filters based on user emails, it works fine when I only use one, but the minute I add more using the AND or OR function it does not work. 

below is how I am currently doing it. I really appreciate any help you can provide.

and(useremail<>"xxxxxx.com",useremail<>"xxxxxxx.com")

[SkrOYC]

Security filters: The Essentials - AppSheet Help

[Jester_Castillo]

I tried this one and nothing, it says unable to find email column( I changed the name to the actual column name on my sheet obviously)

To limit access by user email but allow any manager to have access, create a Managers table that contains the email addresses of all managers. Then specify a security filter like:

OR(IN(USEREMAIL(), Managers[Email]), USEREMAIL() = [EmailColumn])

[SkrOYC]

---

@Jester_Castillo wrote:

I changed the name to the actual column name on my sheet obviously

---

I don't see a syntax problem

[Jester_Castillo]

I can't get this to work, I created the manager's table and that piece is working, I need my distributors now to only see the customers assigned to them, there is an email column for each customer with the assigned manager and distributor. 

[Steve]

Limit users to their own data - AppSheet Help