Formulas in Hide-Whens

Author: Tripp W Black

Created: 08/26/1999 at 07:51 PM


Notes Developer Tips

These are probably obvious to everyone, but here goes:

1) Some of our forms require a lot of hide formulas. When writing such formulas, it
sometimes can be hard to think in terms of "when you want something hidden". We have
often wished we could write such formulas from a "when you want something seen"
perspective. Especially if the criteria is complex, in which case coding the converse of
"when you want something seen" can be tricky.

In such cases, where "when seen" is easier than "when hidden" we simply write the
formula as "when seen", surround it with parentheses and preface with "!". This forces
Notes to figure out the converse situation for when something should be hidden.

Example: !( field1 = "A" & ( field2 = "B" |( field3 = "B" & field1 = "C") ) )

2) We stumbled upon a list shorthand for writing formulas containing OR's using colons.
The following 2 statements give the same results:

@If( field1 = "A" | field1 = "B"; ...
@If( field1 = "A" : "B"; ...

This seems to work on both sides of the equation. For example, when testing multiple
fields for the same value...

@If( field1 : field2 : field3 = "Yes"; ...

Personally, I think this is a lot shorter and easier to read than

@If( field1 = "Yes" | field2 = "Yes" | field3 = "Yes";...


previous page