hello guys
I have three tables. The first table is for users. It contains email and role. The second table contains the basic data, including the book column. What I want is according to the data in the book column. I choose who can see this row, for example, if the book is red or yellow, he cannot View this row except for admin. If it is different from these two colors, everyone can view this row
Hi @salehej
You may want to combine these expressions:
So, you will make an expression for the show_if condition, like:
OR(
USERROLE()="Admin",
AND(
USERROLE()="User",
OR(
[colorBook]="Red",
[colorBook]="Yellow"
)
)
)
or (equivalent)
SWITCH(USERROLE(),
"Admin",
true,
"User",
OR(
[colorBook]="Red",
[colorBook]="Yellow"
)
)
Then, depending on your expectations for filtering, you can use security filters or slices:
Please note that:
Both work the same: you need to set a row filter expression.
didnโt work
What I want is to hide the entire row, not just the cell
Thatโs exactly what I explained when talking about slices and security filters.
I mis-expressed my explanations then.
Can you set the expression into the row filter condition of your slice ?
If that does not work, please:
I recommend you indent your expression for understanding purpose, and enclose it using this tool:
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |