I have essentially no coding experience whatsoever but I'm building an app for my little company. I spent weeks figurign out how to display views to people with a certain role and its working great BUT I need to show a certain thing to two different roles. So If its the logged in user or if its staff. As I want staff to be able to see all our orders but users to only be able to see their own. Both of these expressions work fine on their own but I cant seem to combine them to make them work. Can anyone help?
Shows users their own stuff
USEREMAIL()=ANY(SELECT(User[email],[Email]=USEREMAIL()))
Shows stuff only to staff
'staff'=ANY(SELECT(User[role],[Email]=USEREMAIL()))
IF(staff'=ANY(SELECT(User[role],[Email]=USEREMAIL())), true, USEREMAIL()=ANY(SELECT(User[email],[Email]=USEREMAIL())))
User | Count |
---|---|
43 | |
27 | |
23 | |
14 | |
12 |