Solved: Security view expression - Page 2

Miranda_Lubarsk · 03-04-2021 12:51 PM

Hey guys!

Ok so I am trying to put together an expression that says these employees on this crew can view a view on the app. I want people both on the admin crew and the maintenance crew to be able to view it.

I have a spreadsheet called Employees. The key is the employee name, but then the other columns are [Useremail], [Crew], etc.

I have other functions on the app that utilize the Employee Name as a ref so I need to keep that as the key. Can’t change the key to Useremail.

So what expression do I use? FILTER? SELECT? Nothing seems to be working. Is it a row ref? Idk. I’m thinking something like this, but I know it’s not quite there…

OR((Useremail() = [Useremail].([Crew]= “Maintenance”), (Useremail() = [Useremail].([Crew]= “Admin”)

What are your thoughts? Remember, Useremail is not the key in the spreadsheet. I feel like I should use a de-ref somewhere but maybe that’s not quite right.

Steve

Try this as the view’s Show if expression:

ISNOTBLANK(
  FILTER(
    "Employees",
    AND(
      (USEREMAIL() = [Useremail]),
      IN([Crew], {"Admin", "Maintenance"})
    )
  )
)

View solution in original post