Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can you perform section access for tabs? So if I was authenticating users by their AD login information, can I say what tabs within a document they can see?
Thanks
Ok, first of all you need a common field between the Section Access and the Section Application... this way you can use the configuration "Initial Data Reduction based on Section Access", the field could be the NTNAME for example. In the Section Application you'll have your access table, so the script may look like this:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME
ADMIN, JOHN.DOE
USER. JANE.DOE
USER. JOE.SMITH
];
Section Application;
ACCESS:
LOAD * INLINE [
NTNAME, APPLICATIONS,USER,MANAGER
JOHN.DOE,X,X,X
JANE.DOE,X,X,
JOE.SMITH,,,X
];
Finally, you put the expressions on the sheets show conditions:
Only(APPLICATIONS)='X' , Only(USER)='X' and Only(MANAGER)='X'
Hi,
I've attached a document with Section Access control, here is an idea for tab controlling based on user access:
Users/Passwords:
Cesar / 1234
Pedro / 1234
Hi Cesar,
Can you explain how you added the view-specific security in your document?
Thanks!
Hi, for this I'm using the "Initial Data Reduction based on Section Access", this configuration is made under the Document Properties / Opening tab. By using this, when a user opens the document all the unrelated values (other user access) are erased... also the tabs are defined to be conditionally shown with the expression Only(Access) = 'X',making the other tabs hidden. Got it?
Okay, I will have to try that. Thank you!
Where are you putting the "Only(Access)='x'?
I dont see it in your script.
I'm putting in the tab show condition.
And where is the tab show condition located?
Thanks
At the Sheet properties, first tab.
When I put that in, my tab disappears. So how do I get it back? I need to put an 'X' underneath that tab name in the application access portion of the script?