Access to certain views based on given custom role

AppSheet AppSheet Q&A
, ,
1

Hi everyone. I’m currently working on an app which requires users to see certain views based on different conditions such as their role and the site they are working at. I’ve watched a couple of videos and read through some question that were already asked but none seemed to work for me.

Example:

Role: Site Head

Site: NY

I’ve been trying with expression in the “Display” section of the view but I can’t seem to find the correct way write the expression.

(AND(IN(“Site Head”, UserManagement[Role]), IN(“NY”, UserManagement[Site]))) = TRUE

This is the expression I’ve been testing it with. Any help would be greatly appreciated!

1 Like
2

Try this:

AND(IN(“Site Head”, SELECT(UserManagement[Role],TRUE)), IN(“NY”, SELECT(UserManagement[Site],TRUE)))

IN() will return a true or false so no need for “=TRUE”

2 Likes