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.