Hidewhen Formula Made Easy

I'm sure many of you has had nightmarish Hide-When formulas written
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
such as:

@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!!

Dig Deeper on Lotus Notes Domino Administration Tools

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...