Show_if view

I am trying to limit access to a view under the display and "Show_if" I created a seprate table in the database for admins and I only want admins to be able to view the page. What I have so far is  

Show More
Admin data[Admin email] = USEREMAIL()

 And I keep getting this error message

Show More
Cannot compare List with Email in (Admin data[Admin email] = USEREMAIL())

Please help!

0 2 49
2 REPLIES 2

Aurelien
Google Developer Expert
Google Developer Expert

Hi @Helfmenschools 

Can you try:

IN(USEREMAIL(),Admin data[Admin email])

 For reference:

IN() - AppSheet Help

 

Please remember.. when using the Show_If, it only hides the button to open that view, not the view itself. When the view exists, app users are still able to see that view for examle modifing the URL with the desktop. If the data contains any sensitive data, you should use security filter instead.. or at least the combination of them.

Top Labels in this Space