Section access and exclude fields.

[joris_lansdaal]

‌Hi all,

i've used section access to grant or exclude users access to sheets. Now I'm asked to exclude whole fields. Let's assume I have only two fact fields named volume and profit. what's the best way to exclude users from the field profit?

i've read a lot about section access but could'nt find the answer.

thanks

[trdandamudi · Accepted solution]

You can use the Omit field. In the below script when user DAVID logs in, he will not see the filed "SALES". Hope this helps...

LOAD * Inline [

ACCESS,USERID,OMIT,AUTHID,DISPLAY_SHEET1

ADMIN,ADMIN,,*|*|*,1

USER,JOHN,,JOHN|EMEA|A,1

USER,JOHN,,JOHN|NAM|A,1

USER,JOHN,,JOHN|NAM|B,1

USER,JOHN,,JOHN|NAM|C,1

USER,DAVID,SALES,DAVID|*|*,0

];

[trdandamudi]

Also please go thru the attached file which has examples also:

[joris_lansdaal]

‌thanks! it does ring a Bell. I already have this document printed and in front of me.... I just looked past it I guess.

anyway, again thanks.

Joris.

[trdandamudi]

You are welcome... and yes sometimes we spend lot of time for simple things  even though it is in front of us.....Enjoy your day...