Creating a slice with department level access to multiple useremails

[Nishit]

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/... 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

[Steve]

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

[Nishit]

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?

[Nishit · Accepted solution]

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])