to get a button or whatever element to hide when you don't want it and to appear
when you do.
Sometimes the solution is to turn your thinking inside-out.
If you have a situation where an element needs to be hidden for only one or two
writing the formula can be easy. But what if you DON'T want it hidden for but a
few situations and
need it hidden for a multitude of others. Trying to write the formula with all
kinds of NOT , AND's, ORs, etc.
can be frustrating - there always seems to be an instance where the element will
or will not hide when desired or doesn't show up at all.
Try reversing your thinking and write your formulas AS IF it was SHOW WHEN. You
probably can come up with a relatively simple formula
@IsNewDoc | (Status="Approved" and Location!="Local")
Now, simply NOT the entire expression:
!(@IsNewDoc | (Status="Approved" and Location!="Local"))
and Presto - the expression is in effect a Show-When since it now hides for all
instances where you don't want to see it!!
This was first published in November 2000