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

(Simon Zhang) #1

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

(Syed Faheemuddin) #2

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

will work

(Simon Zhang) #3

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

(Syed Faheemuddin) #4

Try it with security filter. I think it will work

(Simon Zhang) #5

@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

(Syed Faheemuddin) #6

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