Section Access

[#1]

Hi all,

In my Current application contains, 4 script tabs i.e; User1, User2, User3, User4.

And i provided the section access for the application.

Now what i am trying is , Based on user login that user "Edit Script" should be visible and the rest should be disable.

EX1: IF User Login by USer1, then only User1 and Main Script tab should visible.

EX2: IF User Login by USer2, then only User2 and Main Script tab should visible.

Section Access:

UserID, Password

User1, User1

User2, User2

User3, User3

User4, User4

Is this possible ?

Pls see the attached qvw file.

Regards

Venkat

[#2]

Hi,

This is not possible because there is now way to hide a tab with a expression.

Halmar

[#3]

Hi, Halmar is correct in my opinion. Hiding tabs through an expression is not a solution. Please see enclosed (document to hopefully provide a solution to your question (credits to J. Fourman). Feel free to let me know if you have any further questions. Hoping to have been of help and best wishes. Barbara Brouwer

[SunilChauhan]

Section Access:

Load * inline [

UserID, Password,SHEETID

User1, User1,SH01

User2, User2,SH02

User3, User3,SH03

User4, User4,SH04

];

section Application;

Reload the application

in document propertied select checkbox-> Intial data resuction based on section access

go to all sheet properties and in genral tab-> conditional

and write

=Sum(if(SHEETID='SH01',1,0))>=1 for sheet 1

=Sum(if(SHEETID='SH02',1,0))>=1 for sheet 2

=Sum(if(SHEETID='SH03',1,0))>=1 for sheet 3

=Sum(if(SHEETID='SH04',1,0))>=1 for sheet 4

hope this helps

[khadeer]

Hi Venkat,

I hope its not possible to hide "Edit Script" by using section access. U can use hidden script and u can give password to that, so who known the password will see that script.

We can do section access in data level, sheet leve, and document level in front end.

Hope it will help you.

Regards,

Khadeer