- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sheet level access
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 as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Access should be controlled by security rules on the QMC.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).