Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to show one sheet for only some people, rest of the sheets can see everyone. Here i am using osuser() function in conditional show like: =
=if(OSUser()='user1' or OSUser()= 'user2' ,1,0). This is working fine, but i have to show this for 30 users and in future it may increase, how can i do this without section access?
Hi Pradeep,
Load user names from Excel file
LOAD
UserName
FROM ExcelFile;
=Len(Only({<UserName={'$(=OsUser())'}>} UserName)) > 0
Hope this helps you.
Regards,
Jagan.
Hi,
Use Mixmatch() function as shown below
=mixmatch(osuser(), 'user1','user2', 'user3')>0
regards,
Naresh
Hi Pradeep,
Try Match()
If(Match(OSUser(), 'user1', 'user2' , 'user3', 'user4', 'user5', .............'usern'),1,0)
FROM DataSource;
Hope this helps you.
Regards,
Jagan.
can we make usernames configurable?
i mean can we put all the usernames in one excel file and can we use the same in conditional show without writing all the usernames in condition?
Hi Jagan,
can we make usernames configurable?
i mean can we put all the usernames in one excel file and can we use the same in conditional show without writing all the usernames in condition?
Hi Pradeep,
Load user names from Excel file
LOAD
UserName
FROM ExcelFile;
=Len(Only({<UserName={'$(=OsUser())'}>} UserName)) > 0
Hope this helps you.
Regards,
Jagan.
This doc in the resource library
Sheets Security with Section Access
Is a very good reference for what you are trying to do. Basically you create a tick sheet for each user. If you aren't using section access then you will need to add the OsUser() calculation to set analysis in the sheet visibility.
Pradeep,
Go to sheet properties-> condition and use this condition below:
OSUser() = 'ABC' or OSUser() = 'XYZ' or OSUser() = 'HJX'
Thanks,
AS
It's Working,
Thank you