Security Filter to Limit USEREMAIL() views of data

[Jason_Stetler]

Hello!

I am struggling to find out how to customize the view of a certain data table depending on USEREMAIL.

The data table I am using lists objects, and each object may have multiple owners. I am trying to make it to where each owner can only see the objects in which they have ownership. I have an OWNERS column where I list each USEREMAIL separated by a comma (",")–and I have tried the CONTAINS([Owners], USEREMAIL()) function in the security filter, but this only works if the useremail is listed FIRST in the list of owners.

Is there a function that will allow me to search for USEREMAIL in a list of text, rather than only searching for the true single value of a useremail?

Sorry if this sounds confusing I’m confusing myself just typing this–any and all help is greatly appreciated! Thanks!

[Marc_Dillon · Accepted solution]

Jason_Stetler:

and I have tried the CONTAINS([Owners], USEREMAIL()) function in the security filter, but this only works if the useremail is listed FIRST in the list of owners.

Please show evidence how it only works in that case. CONTAINS() should not be constrained like that.

It’d be better to hold your “owners” list as a List type. Try the EnumList column type for a Real column. Then you can use IN().

[Steve]

Marc_Dillon:

Please show evidence how it only works in that case. CONTAINS() should not be constrained like that.

I agree.

[Jason_Stetler]

Shoot–I reloaded things and must have just had something entered incorrectly before…it DID end up working how I imaged it should. Thanks guys!

[Marc_Dillon]

What same thing? CONTAINS() not working like it should be? What does the second half of your sentence mean?

[SkrOYC]

El row filter condition del Slice puede tener una lógica bastante fuerte.
Para empezar, lo sencillo es filtrar solo columnas que pertenezcan a un usuario en particular. Para eso puedes poner como filtro que [ColumnaConMailDelUsuario]=USEREMAIL()
Si quisieras hacer que también filtre en base a otros criterios, solo debes usar cada condición dentro de una función AND()
Incluso puedes hacer lo del UserEmail() como un security filter y luego usar una slice para dividir la tabla con los datos del usuario

help.appsheet.com

AND()

Are all true?