Security Filter, show guest all data in applauncher

[JaysonTatum]

Hi,

IN([SITE], SELECT(USERS[SITE], [EMAIL] = USEREMAIL()))
Above formula will show specific SITE to a specific user on the list.

Need to show all sites when a useremail is not on the USERS table, like if a visitor/guest will use the applauncher. Thanks

[Steve · Accepted solution]

Try this:

OR(
  IN([SITE], SELECT(USERS[SITE], [EMAIL] = USEREMAIL())),
  NOT(IN(USEREMAIL(), USERS[EMAIL]))
)

See also:

help.appsheet.com

OR()

Are any true?

[JaysonTatum]

Thanks Steve!!! It works