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:
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