topic Re: Hiding Users Sheet in App Development

Hiding Users Sheet

Noor51 — Fri, 15 Nov 2024 21:05:12 GMT

Hello,

I trying to hide sheet for some user. I use the formal =MixMatch(OSUser(),'XXXX') to hide the users, but I have to put everyone individual name in the expression or load script.

I was wondering if I can be able to use custom properties department list for this instead of putting individual.

Or is there a different function I have to use to use the department list.

Re: Hiding Users Sheet

Vegar — Thu, 01 Feb 2024 23:43:25 GMT

Take a look at SectionAccess. There you can use usernames or ad group to configure the access.

Let the section access filter down on a data Island containing one value per sheet you want to configure. Use the Island values to define the show condition and the section access to limit which users that should be able to access which values.