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,
You must have Users information stored somewhere in table/ qvd/excel. You can cretae one table in application with concatenated field (0say User) of all users which you want to give access and then use expression
Substringcount(OSUser,User)>0
Ex:
If you have table
UserList:
UserName
A,
B,
C
From XYZ.qvd;
Load
Concat(UserName) As UserName
From XYZ.qvd;
Hope this help.