I am putting a long formula on ALL my views so that only people who meet the in(lookup and In(
conditions can see the view. The formula is the same for all my views. If I need to change the logic I have to change it on every view.
I would rather have this formula just be for the whole appโฆso I can control when the app loads users can not see see ANY views if (the formula)
Is there a way to do that on the UX General Options ?
My formula is something like this:
OR(
IN(LOOKUP(USEREMAIL(), Allemps, EmpEmail, JobCode), LIST(โtestโ,MGRHR)),
IN(
โCorpHRโ,
SELECT(Users[Role],[Email]=USEREMAIL())),
)
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |