Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I've got multiple users for my project. Now I want to disable a few worksheets for users...
I've got this code in my script:
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, SOORT, MISGROEP
ADMIN, ADMIN, ADMIN, *
USER, USERA, PASA, K, *
USER, USERA, PASA, N, *
USER, USERA, PASA, P, *
USER, USERB, PASB, K, *
USER, USERB, PASB, N, *
USER, IT, IT, * , M50103020100
USER, ONDERHOUD, ONDERHOUD, *, M401010
USER, ONDERHOUD, ONDERHOUD, *, M402010
];
Section Application;
USERID, Sheets, flag
ADMIN,SH01, 1
ADMIN,SH02, 1
ADMIN,SH03, 1
ADMIN,SH04, 0
ADMIN,SH05, 0
USERA,SH01, 1
USERA,SH02, 1
USERA,SH03, 1
USERA,SH04, 0
USERA,SH05, 0
USERB,SH01, 1
USERB,SH02, 1
USERB,SH03, 1
USERB,SH04, 0
USERB,SH05, 0
IT,SH01, 0
IT,SH02, 0
IT,SH03, 0
IT,SH04, 1
IT,SH05, 1
ONDERHOUD,SH01, 0
ONDERHOUD,SH02, 0
ONDERHOUD,SH03, 0
ONDERHOUD,SH04, 0
ONDERHOUD,SH05, 1
My question now is: What should I write in my condition in the property's of the worksheet? Something like =sum(SH1)> 0 ???
Regards
IF(QVUSER() = 'USERA')
What do you mean... I need to make a condition in the worksheet property!
I must call I function like SH01.flag == 1 or something like this
I am doing something similar for separating admins from users:
this is the function i use
=MAX(Match( Admins.Names, UPPER(OSUser())))
You should be able to modify that and put it in your conditional show field
Can you explain me: Admins.Names ?
Is this the USERID or is OSUSER the id?
Can somebody give a specific answer for my problem?
in each of your sheets qlick on "settings" then "Sheet properties" then add a formula in the "Show Sheets " box
something like =sum(SH01)>0 In this case IT & ONDERHOUND would not see the sheet.
Also depending upon how many users you have you may want to set your section access up as a table.
This is how I would do it.
//SH01 is used to control access to the customer profitability tabs on this report
star is *;LOAD * INLINE [ACCESS,USERID,PASSWORD,NTNAME,GROUPADMIN,*,*,GB\GG_QVTAB_QMFV_OWNER,*ADMIN,*,*,GB\GG_QVRL_QMFV_OWNER,*USER,*,*,GB\GG_QVTAB_QMFV_SH01,SH01USER,*,*,GB\GG_QVTAB_QMFV_SH02,SH02USER,*,*,GB\GG_QVTAB_QMFV_SH03,SH03];
T1:
load * inline
[GROUP,SH01,SH02,SH03
SH01,1,0,0
SH02,0,1,0
SH03,0,0,1];
ADMIN, ADMIN, ADMIN, *, *
USER, IT, IT, *, M50103020100
USER, ONDERHOUD, ONDERHOUD, *, M40101020100
USER, ONDERHOUD, ONDERHOUD, *, M40201020100
USERID, SH01, SH02, SH03, SH04, SH05
ADMIN,1, 1, 1, 0, 0
USERA, 1, 1, 1, 0, 0
USERB, 1, 1, 1, 0, 0
IT, 1, 0, 0, 1, 0
ONDERHOUD, 0, 0, 0, 0, 1
The accounts are working, but still he shows every sheet :s
