Validation of Non Qualifier -Boolean field

[Former Member]

Hi Guru's,

I am trying to create a Validation for Qualified field (Field is Qualifier and Field type---Boolean)...It has two values Yes and No

I want validation warning if Value is "Yes"..and Also when Value is "No"..

I created both validations (set to automatic execution) and when i changed value in this field to "Yes"..I do get warning message ,but I get warning message for both values..

I.e Warning messages--

Filed XYZ has Value "Yes

Field XYZ has Value "No"..

What i was expecting was it will give only first warning message as value was set to "Yes"..

Validation Expression:-

IS NOT NULL (Marketing.XYZ) AND Marketing.XYZ= Yes

Is what i am doing something wrong?

Regards

Vikrant M Kelkar.

[Former Member · Accepted solution]

Hi Vikrant,

try righting these two validation:

Marketing.XYZ = TRUE ( Warning msg : Value set to No)

Marketing.XYZ = FALSE ( Warning msg : Value set to Yes)

Thanks,

Maheshwari

[Former Member]

Hi Vikrant,

You do not need to check for null values in case of booleans as the default is false.

Try using if(marketing.XYZ,false,true)

Select the true and false values from the operators.Do not type them.

Hope it helps.

Thanks,

Minaz