Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Afternoon!
I have a problem. I have 2 sheets, with different analyzes on a QVW, and I have some users who need see dashboard A with all information, other just see dashboard B and another both dashboards. So I created a button that activate this sheet and associated the users on conditional layout with this function: OSUser() = ‘ ID User’. It ‘s working, but now I have a greater number of user, and this method is difficult to manager. Is there another solution or function to hide object based on login user?
P.S: I tried use section access, but I don`t need hide one field, but all dashoard.
Some one can help me? Thanks
Talita, you can still use Clever solution, if you want to hide an specific object, you need to open the object properties, then go to layout and in conditional add his expression
another option is to hardcode the values with a nested if, something like if(UPPER(OSUSER()) = RAMON OR UPPER(OSUSER()) = TALITA,1,0)
It would easier having a table (inline or excel file) with OSuser() and a flag
You expression would be = only(Flag) = 1
Hi Clever!
The function not solved my problem, the sheet doesn’t hide. I would like to hide sheets when the user access the dashboard. For example: When I open the dashboard, my user is identified so hide or show the sheet.
Talita, you can still use Clever solution, if you want to hide an specific object, you need to open the object properties, then go to layout and in conditional add his expression
another option is to hardcode the values with a nested if, something like if(UPPER(OSUSER()) = RAMON OR UPPER(OSUSER()) = TALITA,1,0)
Hi,
if You have many users and few profiles, You can create an Input Box (Profile A, B)
instead of Button.
The User selects Profile.
In Your conditional expression Hide/Show Profile='A' or Profile='B'.
Regards,
Antonio
Ramon!
I have used function OSUser() on conditional layout, but a have a lot of number users and it's difficult to manager. Is there another solution?
Thanks