Creating a slice with department level access to multiple useremails

AppSheet AppSheet Q&A
,
1

Hi

I have three different tables in Google sheet

  • Table 1 (Master Sheet) contains columns: Intent, Journey, Response, Category
  • Table 2 (Categories) contains columns: Category, Owner
  • Table 3 (Owner Email) contains columns: Owner, Email

My aim is to provide access to the user(s) to view, modify and delete data only pertaining to their Department.

Note - Incorporating Admin and/or Super admin role would be a good to have but not a necessity at this point.

Constraint:

The column “Email” in Table 3 (Owner email) can contain one or multiple email ids separated by commas

The slice expression that I have created is as follows:

IN(

LOOKUP(

Category,Categories,Categories,Owner),SELECT(

Owner email[Owner],IN(

USEREMAIL(),LIST(Owner email[Email]))))

I am facing two problems:

  1. No data is being shown in the slice for any of the useremails()

  2. It’s taking too much time to load the slice

What have I tried:

  1. I have tried to create references between the 3 tables but have seen no success

  2. Follow along the QnA at https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Filter-Data-based-on-Team-Dept-or-Category/m-p/299635 but am getting an error - “unable to find column ‘_THIS.ROW’”

I am new to app sheets and don’t have a strong programming background. Below are screenshots showing the data type that the system has auto selected

Nishit_0-1649231712409.png
Nishit_0-1649231712409.png651×481 23.6 KB

Nishit_1-1649231722839.png
Nishit_1-1649231722839.png656×487 24.2 KB

Nishit_2-1649231740415.png
Nishit_2-1649231740415.png671×454 21.1 KB

2

Nothing about your slice row filter expression is correct. I encourage you to keep tinkering. You have some learning to do.

3

Hi Steve

Definitely a lot of learning to do but can you help understand what I am trying to do is achievable through this method or am I headed in the wrong direction?

4

For anyone who has a similar challenge, this is what worked for me

  1. Create reference between the three tables.

  2. Create a new slice - IN(USEREMAIL(),[Email])

1 Like