Hide when problem

HCL Domino Domino Forum
1

HI ALL

I have small problem in hiding filed

lik i want to hide afield based on two field values and if it is newdoc

i written code like this

!fielda=“” & fieldb=“” & @isnewdoc it is not workimg

my requirement is

if field a is not equal to null and fieldb=“” and if doc is new means

i want to display fieldc how to do this

2

Subject: hide when problem

Try the following code:

@IsNewDoc & fielda != “” & fieldb = “”

HTH

3

Subject: RE: hide when problem

not working

4

Subject: RE: hide when problem

He probably meant to say…

“Thanks Geoff for your response. I have tried it and it does not appear to be working. I am posting the exact formula below that is in my hide-when window. Does anyone possibly have any other suggestions?”

But he didn’t

5

Subject: RE: hide when problem

Hey Mike.

IT is a thankless job.

Geoff

6

Subject: RE: hide when problem

Geoff,

It sure is

Keeps the bailiffs from the door temporarily though

7

Subject: hide when problem

With hide when formulas it is always good to think the other way around.

Do not think “when do I want to show the field”, but think “when do I want to hide the field”.

You want to show fieldc if fielda is not equal to null and fieldb=“” and if doc is new.

This means you want to hide fieldc if fielda=“” or fieldb!="’ or ig it is not a newdoc.

Hence, your hide-when formula will be

fielda=“” | fieldb!="’ | !@isnewdoc

8

Subject: RE: hide when problem

Actually, I find it much easier to think in terms of a “show-when” formula – because that’s the more natural way, and it is how requirements are usually expressed.

To turn a show-when formula into a hide-when, all you have to do is surround it with !( ). I find that a lot easier than turning the 'and’s into 'or’s without getting all tangled up in 'not’s :wink:

Thus, his formula is:

! ( fielda!=“” & fieldb=“” & @isnewdoc )

9

Subject: hide when problem

Having looked at your explanation again, this is how I translate it.

if fielda is not empty and fieldb is empty and if the document is new, then you want to show the field.

The hide when formulas are actually identifying when to hide the field not show it therefore a quick and dirty way is to work out when to show is via the formula:

@IsNewDoc & fielda != “” & fieldb = “”

This identifies when to show the field, but the hide when identify when to hide the field therefore merely negate the formula:

!(@IsNewDoc & fielda != “” & fieldb = “”)

HTH