Sheet level access

[nvijay5757]

Hi,

i am trying to sheet level access using show condition in sheet properties.

but not working for me.

Requirement is i have 4 sheets, 2 sheets will see everyone and 2 sheets will see only some of them.

please help me. thanks.

[Mark_Little]

Hi
Access should be controlled by security rules on the QMC.

[rubenmarin]

Hi you can use section access, add a flag so each user has 1 or 0, and use that flag in the show condition of the sheet:

Section access:

Section access;
load * Inline [
USERID		,SEESALL
FDS\VNALAMOT	,1
FDS\JSARKAR1	,0
];

Section application;
// The app script

Sheet show condition

=SEESALL

[nvijay5757]

Thanks Rubenmarin,

Sheet show condition will give as SEESALL, then for example JSARKAR1 will give the access to another sheet how.

like sheet1-SEESALL

sheet2-SEESALL.  how will give the access to sheet2 for other user.

[rubenmarin]

You can add additional fields to give access by user/sheet:

Section access;
load * Inline [
USERID		,SEESALL, SH1, SH2
FDS\VNALAMOT	,1 ,1 ,1
FDS\JSARKAR1	,0 ,0 ,1
FDS\OTHER	,0 ,1 ,0
];

Section application;
// The app script

The expression for SH1 would be "=SH1" or "=SH1 or SEESALL"

[Or]

Just chiming in with something here - do keep in mind that this is not security and any user with a Professional license will be able to duplicate the hidden sheet if they wish to. Any user regardless of license will be able to access the information contained within the sheet unless that information is otherwise blocked (using data access permissions / OMIT fields).