I would like to have my clients set up their ...

[Simon_Zhang]

I would like to have my clients set up their own Company profile, and Add members to that company profile. Only members added in that company can see related data. How to make it happen?!

I used this but it doesn’t work IN(LOOKUP(USEREMAIL(), Member, Email, Organization), LIST(“Member”))

Thanks

[Sdfaheemuddin]

Is this formula in a slice? If slice then [Organization]=Lookup(USEREMAIL(),Member,Email,Organization)

will work

[Simon_Zhang]

@Sdfaheemuddin Hi thanks for your reply, but I’m trying to create a security filter. Which applies to data base directly not slice.

[Sdfaheemuddin]

Try it with security filter. I think it will work

[Simon_Zhang]

@Sdfaheemuddin Table ‘Member’ has an invalid security filter ‘=[Organization]=Lookup(USEREMAIL(),Member,Email,Organization)’. The filter expression cannot reference the table being filtered.

This is the error, had tried this before

[Sdfaheemuddin]

Can you provide more details like what are the tables and where you are applying filter. You should apply this filter for the table where you have data not the members table