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!
Solved! Go to Solution.
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()
.
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()
.
I agree.
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!
What same thing? CONTAINS() not working like it should be? What does the second half of your sentence mean?
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
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |