Hide Sheets

[#1]

Hello all,

I have discovered a lot of posts concerning " hide the sheets", but I don't see any solution for my problem:

I have implemented relatively easy a section access:

***

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, USER, USER
];
Section Application;

***

Then there is a shet "XY" which I want to hide:

I go to Sheet Properties / General Tab -->

"Show sheet" with the condition: (QvUser () = 'ADMIN')

After saving and perhaps reloading I start the application and enter my ADMIN credentials and I see the sheet.

When I log in with the user information it is the same. The sheet is visible.

What do i wrong?????

I have tested with the condition 1=2. This has worked the first time for me. After adjusting the section access, it doesn't work anymore.

Could someone please help m?!!

Thanks in advance

Regards Christoph

[#2]

Hi Hasenclc

You can use OMIT for this purpose.

Example:

LOAD * INLINE [
ACCESS, USERID, PASSWORD, OMIT
ADMIN, ADMIN, ADMIN,
USER, USER, USER, <TableFieldName>
];

Then make a table including <TableFieldName> with the value "Yes".

Set Show Sheet -> Conditional to "<TableFieldName>='Yes'"

The sheet will thus only be shown to the people who dont have <TableFieldName> included in the inline load.

[#3]

Hi,

What u do is pass one additional column "ShowSheet" to section access part where u have defined your users & give a value either 0 or 1 & on the sheet general tab put "ShowSheet" in the condtional box.

This can probably help.

[#4]

Hello Santosh,

and with which command can I get the status of the ShowSheet in the conditional box?

Regards Christoph

[#5]

Hi Christoph

Have you considered using Conditional show off sheets?

Right Click the sheet and in the "Show Sheet" settings you select "Conditional" - then you can do something like, if(CheckField=1) or similar.

/Martin

[#6]

With each user one value for ShowSheet field(either 1 or 0) will come then sheet will be visible or hidden depending on value

[#7]

Hello all,

thanks for your answers.

It is not so easy to follow you, so I will sumarize my way.

I have inserted additionally in script the "ShowSheet"

*****

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, SHOWSHEET
ADMIN, ADMIN, ADMIN, 1
USER, USER, USER, 0
];
Section Application;

*****

So the admin has for Showsheet the number 1.

If I go to the conditions, how is my command?

=If (ShowSheet='1') OR

=(ShowSheet='1') OR what ?????

I am a little bit confused.

[#8]

Hi Frederik,

your way I haven't tested yet.

Could you please give me some details concerning the table TabelField Name.

I think I am really a bit confused.

Thanks in advance

Regards Christoph

[#9]

hasenclc wrote:Section Access;
LOAD * INLINE [
 ACCESS, USERID, PASSWORD, SHOWSHEET
 ADMIN, ADMIN, ADMIN, 1
 USER, USER, USER, 0
];
Section Application;

You can use the above script in section access and in the sheet conditional show property, add either of the following expressions:

SHOWSHEET=1

if(SHOWSHEET=1,true(),false())

This should resolve your issue.

[#10]

Hello Haneesh,

thanks for your answer.

I have set up the same as you have proposed. If I login as USER and I check the status of "if(SHOWSHEET=1,true(),false())", it is false. .As Admin the status is displayed as true, so I think with the section access is everything ok.

Perhaps there are some other settings I have overseen? In the document settings? In the sheet settings??

regards Christoph