Show if for authorised useremails

AppSheet AppSheet Q&A
,
1

Hi there,

I have created a workflow app with 2 tables (table1, table2).

I have shared the app with 3 separate email accounts (email1@gmail.com, email2@gmail.com, email3@gmail.com ).

Now would like to limit access/visibility of the tables based on the usermail.

Permissions:

What is the expression I need to add in Show if in the UX Primary Views of each table1 and table2?

Thanking you in advance.

2

Tab1 Show if

IN(USEREMAIL(), {"email1@gmail.com"})

Tab2 Show if

IN(USEREMAIL(), {"email2@gmail.com", "email3@gmail.com"})
4 Likes
3

“Show if” works for all views not only primary. You can variate it if add CONTEXT() function to expression.

4

Champion! I forgot the { }

5

Arni,

Question, what if I have to lookup email2 in table4, row3 and email3 in table5, row3 respectively. Rather than adding the email addresses in the expression?

Regards

6

What is row3? Write in more detail please.

7

Note that Show_If for a view merely hides the link to the view from the menu or navigation bar. If the user has the right URL–which isn’t difficult to guess–they can navigate to the hidden view and see whatever’s in it. Also, the data used by the view is still loaded into the app. A savvy user can still access loaded data regardless of the lengths you go to to hide it. To secure the data, use security filters to prevent the data from being loaded. In your cases, use the expressions provided by @Arni_Kli in the security filters, too.

1 Like