UserEmail OR/And Funciton

So i’ve got a Security filter so the user (via useremail) will only see their assigned task. How do I make it so when I (admin) is logged in, i see all the data?

Function is currently set to: [Email]=useremail()

To use the built-in privileges:

OR(
  (USEREMAIL() = [Email]),
  ("admin" = USERROLE())
)

Or, to give only select email addresses that extra privilege:

IN(
  USEREMAIL(),
  LIST(
    [Email],
    "your-email",
    "some-other-admin-email",
    ...
  )
)
1 Like