How to hide object with login user?

[#1]

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

[Clever_Anjos]

It would easier having a table (inline or excel file) with OSuser() and a flag

You expression would be = only(Flag) = 1

[#3]

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.

[ramoncova06 · Accepted solution]

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)

[antoniotiman]

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

[#6]

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