Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I use section access script to control access to application tabs for different users?
Example will be really appreciated!
Thanks,
Prashant
here is what u want
section Access;
Load * inline [
Access,UserID,Password,SHEETID
Admin,sunil,sunil,*
user,sumit,sumit,SH01
user,vishesh,vishesh,SH02
];
section Application;
Load
SHEETID, // Required to be in capital
.
.
.
from path;
and in document properties->
check initial reduction based on section access
in general of ur tab-> check conditional -> count( 'SH01')>1
thanks
Sunil Chauhan
Hi Prashant,
Check my attached file for your reference.
Regards,
Sokkorn
but I have 35 users and 21 sheets
ur solution is becoming laborious thing to maintain....
is there any alternative?
can you use this section access along with initial load reduction with strict exclusion. I am using section access to reduce data by values in specific fields like Project Manager. can I add the hide tab section access to this same load script