SHOW IF useremail() doesn't prevent users from seeing views

[giampierotec]

in my app i have a reference view admin that should only be seen by the user logged in with the admin email. So in the display>Show If formula i wrote USEREMAIL() = "(PII Removed by Staff)", but it doesn't work at all and any account can still see the view. If it's important the view is of type gallery and the position is ref.

[Joseph_Seddik]

Regardless of the "Show If" condition, users will still be able to access the view directly using its URL, and for reference views, this is what "View Ref" actions are doing. So instead you should:

1. Apply the condition in the relevant "View Ref" action. 
2. Apply a security filter to the table so that even with a direct access to the view, undesired users would get an empty view.

[xeonavn]

@giampierotec you can use this in show_if, Create user role table list, then try this IN(LOOKUP(USEREMAIL(),"user_role","Email","Role"),LIST("DEV/ADMIN"))

[Joseph_Seddik]

---

@xeonavn wrote:

you can use this in show_if

---

No it won't work. Even if you just explicitly put false, it wont.