Hello I have an app with groups so I have a security filter that restricts the information to that particular group based on the user thatโs logged in. The security filter is: LOOKUP(USEREMAIL(),โgroup_usersโ,โuserโ,โgroupโ)=[group_id]
Question 1: Is there a less expensive expression I can use?
Question 2: I now have to restrict the โgroup_usersโ table to only show users in the logged in userโs company.
The above expression no longer works of course as weโre IN the table so it would be great if we use something like LOOKUP(USEREMAIL(),[_THIS],โuserโ,โgroupโ)=[group_id] but that doesnโt work either.
Any ideas?
Thank you
You could add a column with all emails of the group as an ENUMLIST and check if USEREMAIL() is in that column
Isnโt the filter just
[user] = USEREMAIL()
What concerns do you have about the current one? The only question that jumps to mind for me is can the user belong to more than one group?
If by โcompanyโ you mean โemail domainโ (the part after the at sign (@)):
(
INDEX(SPLIT(USEREMAIL(), "@"), 2)
= INDEX(SPLIT([email], "@"), 2)
)
yes, the user could belong to more than one group
CORRECTION: the user can only below to one group
Hi Steve, weโll use the LOOKUP expression as you are correct, users belong to only one group.
@praveen the user will need to see all users for their group
I think I can use USERSETTINGS to capture the group the user is associated and then call on USERSETTINGS (group) as needed. Iโll update the note if successful.
UPDATE: USERSETTINGS() doesnโt work - seems to be a circular reference issue.
Thanks
So where do we stand now?
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |