robg
Canvas Initiate

Forms - Using Validation rules

Hi

Struggling with the validation rules and using to fields to Validate.

Both conditions when true - field required.

 

Form breakdown

Control  A - Choice Drop down control (used for filtering a large list over 4000 entries)

Values are  0-9,A-D,E-H,I-M,N-Q,R-U,V-Z

 

Control B - Lookup control

if Control A choice is '0-9', this control is visible (working). It should also be invalid if '0-9' is selected AND isNullOrEmpty.

 

Separately the following rules work: IsNullOrEmpty({Self}) - control B required

Contains(Control A, "0-9") - Control B required

 

I have tried the following formulas on control B:

isNullOrEmpty({Self}) && contains(Control A, "0-9") - Does not make Control B required

and(isNullOrEmpty({Self}), contains(Control A, "0-9")) - Does not make Control B required

 

I know it must be something basic I have missed but I struggling at this one.

Thoughts anyone ?

Thanks

Rob

 

0 Kudos
Reply