topic Re: Sheet level access in App Development

Sheet level access

nvijay5757 — Wed, 09 Nov 2022 07:24:05 GMT

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.

Re: Sheet level access

Mark_Little — Wed, 09 Nov 2022 07:30:27 GMT

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

Re: Sheet level access

rubenmarin — Wed, 09 Nov 2022 07:34:45 GMT

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

Re: Sheet level access

nvijay5757 — Wed, 09 Nov 2022 09:47:33 GMT

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.

Re: Sheet level access

rubenmarin — Wed, 09 Nov 2022 10:15:28 GMT

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"

Re: Sheet level access

Or — Wed, 09 Nov 2022 10:31:12 GMT

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).