Field Validation

[jono332]

Hello

 

How do set up a field validation for the following scenario:

 

Field A - Drop-down list with "Good" and "Poor"

Field B - Comment text field

 

Can I force the user to enter a comment in Field B if Field A is "Poor"? 

 

I am pulling my hair out, I must be missing something in the calculation to validate the field .

 

Thanks for the help 

[comment]

Can I force the user to enter a comment in Field B if Field A is "Poor"?

 

Try validating Field B by a calculation =

not ( IsEmpty ( Self ) and Field A = "Poor" )

Deselect the 'Validate only if field has been modified' option.

[jono332]

That work thanks

 

Is this still valid if I were to insert an "or" statement:

not ( IsEmpty ( Self ) and Field A = "Poor" or "Bad" )

[comment]

It may be valid, but it won't do what you think it does. Try =

not ( IsEmpty ( Self ) and ( Field A = "Poor" or Field A = "Bad" ) )

Note the extra set of parentheses required because and comes before or in the default order of evaluation.