Problems hiding layers, any ideas? Or have I found another bug?!

I have a form that I am using for a dialog box. This has a 1 cell table and several layers, which I hide depending on circumstances.

I can’t use a layout region for this, because of a bug I found previously:

http://www-10.lotus.com/ldd/nd6forum.nsf/DateAllThreadedweb/041640277549aa5e8525700500633f57?OpenDocument

So I am using layers and hide-whens.

The problem is that I have three layer tags all on the same line (i.e. paragraph) and I have one hide-when formula that affects all three layers.

When they are supposed to be un-hidden, only one of the layers show up, even though they all use the same formula (they can’t have different formulas, being on the same paragraph - one formula to rule them all!)

For the life of me I can’t figure out why, as under certain other conditions they do all show.

The hide formula is as follows:

docs:=@Unique(@DbLookup(“”;“”;“vwSystemLookup”;“ShiftReason”+Reason;2));

@If(@IsError(docs);1;@If(@Elements(docs)=0;1;0))

|(!Documentation=“1”:“2”)

I have used the first two lines of the formula to hide the “Documentaion” field and this always works. The second part:

|(!Documentation=“1”:“2”)

works when Reason is anything but “9” and when it is “9” that’s when the problems start, but it doesn’t make sence as this part of the formula does not reference “Reason” anywhere! And as I mentioned before they should all hide or all show, not just some of the layers.

Any suggestions would be greatly appreciated as I’m running short on hair now!

I have a sample database with the code, if anyone wants to see for themselves what I’m talking about!

Charlie

Subject: Problems hiding layers, any ideas? Or have I found another bug??!

The !Documentation=“1”:“2” looks scary; I have to think a lot to understand what that means…

Send the db to herbert@vliet.net?

Subject: Problems hiding layers, any ideas? Or have I found another bug??!

I am not clear on what you mean by the layers being in the same paragraph. Why don’t you just put each in a separate paragraph? It won’t be visible anyway. For example, see the layers below and click on the actions to hide and unhide. Now, the other thing to remember is that there are paragraphs inside the layer, and there may be bleedthrough if those are not hidden with the same formula. (Note that this example will work on the web, but works better in the Notes client since it doesn’t have to do a round trip to the server and since the popups show up)

Show Morning meetings Show Afternoon meetings

07:00

08:00

09:00

10:00

11:00

12:00

01:00

02:00

03:00

04:00

05:00

06:00

07:00

08:00

09:00

Meet with John

Budget meeting

Meet with ACE Mfg

Sales motivational

Subject: RE: Problems hiding layers, any ideas? Or have I found another bug??!

Got it.

Hide-whens in the layers themselves!

Don’t know how they got there mind, but the “bleed-through” you talked about is it.

So simple when you think about it!

Thanks muchly.

Charlie.

PS By the same paragraph, I meant that the layer tags were next to each other in the same line of text and so were affected by the same hide-whens.

Subject: Do know how they got there - copy and paste text from my original layout region!!

Subject: *LOL. I guess that can happen. Glad it worked out.