Two condition Hide-When

HCL Domino Domino Forum
1

Greetings, all

After spending all morning in here trying to find a solution to make this seemingly simple Hide-When work, I’ve given up. Here’s what I need . . .

I need to display a cell in a table only if BOTH of the following conditions are TRUE:

Shared field (State) = “CA” or “FL” or “PA”, AND

Checkbox field (CH) = “Risk exposure”

Otherwise, the cell and its contents are to remain hidden. I have tried numerous syntax styles and hide-when arrangements, but nothing has worked thus far.

All suggestions welcome!!

Thanks very much.

2

Subject: Two condition Hide-When

State != “CA” & CH != “Risk exposure” try to use this for more call me on ajitnarayan123@gmail.com

3

Subject: RE: Two condition Hide-When

Congratulations – you got it wrong even with the correct answer available (and a confirmation from the original poster that the problem has been solved).

4

Subject: Two condition Hide-When

So you want to hide the field if CH != “Risk exposure” and !@Contains(State); “CA”:“FL”:“PA”.

I like to use an if statement for something like this:

@If(!@Contains(State); “CA”:“FL”:“PA”; @True; CH != “Risk exposure”; @True; @False)

So if it doesn’t contain one of these states, the field is hidden. If it does, it checks CH. If that isn’t Risk exposure, it is hidden. If both are true, it is available.

If this doesn’t work, try using just the state part first and then adding the CH part to see what breaks.

5

Subject: Two condition Hide-When

So you have a show-when formula already:

(State = “CA”:“FL”:“PA”) & (CH = “Risk Exposure”)

To make a show-when into a hide-when, just negate the whole thing:

!((State = “CA”:“FL”:“PA”) & (CH = “Risk Exposure”))

or use De Morgan’s rules to construct an equivalent negation:

!(State = “CA”:“FL”:“PA”) | !(CH = “Risk Exposure”)

6

Subject: RE: Two condition Hide-When

Thanks, Stan

You are, as always, “the man”