Hide Formula: Multiple Evaluation Problem

HCL Domino Domino Forum
1

I need to hide a field if conditions are not met in two fields with multiple options in one of the fields. So, if a value exists in FieldA (true) then hide FieldC, or if FieldB does not equal “sample1”, or if FieldB does not equal “sample2”, or if FieldB does not equal “sample3” then FieldC should also hide.

I tried the following but it doesn’t seem to work:

FieldA = “True” | FieldB != “sample1”:“sample2”:“sample3”

I did get the following partial to work:

FieldA = “True” | FieldB != “sample1”

Any ideas how to evaluate multiple fields and for multiple values?

2

Subject: Hide Formula: Multiple Evaluation Problem

Perhaps this would work?

FieldA = “True” | FieldB != “sample1” | FieldB != “sample2” | FieldB != “sample3”

3

Subject: Hide Formula: Multiple Evaluation Problem

try using @contains. This might help you…

4

Subject: RE: Hide Formula: Multiple Evaluation Problem

The expression FieldB != “sample1”:“sample2”:“sample3” means, FieldB != “sample1” or FieldB != “sample2” or FieldB != “sample3” (assuming FieldB is a scalar).

What you want instead is:

!(FieldB = “sample1”:“sample2”:“sample3”)

Do not use @Contains as Thiyagarajan suggested; it doesn’t do what you want. You could do it with @IsMember.