Validation Code - additional condition

User Support Form Building
, , , ,
1

Dear Community,

I have question relate to validation code with two condition A and B
if A = 0 then B Should 0, if A>0 then B should more than 50 miliion

image
image780×375 3.33 KB

then the code is (${A}=0 and .=0) or (${A}!=0 and .>=50000000)

Let me know if I’m wrong

Best,
Thank You

2

You could do it as outlined in the image shared below:

In the survey tab of your xlsform:

Image 1
Image 11093×130 4.84 KB

Data entry screen as seen in Enketo: when a condition is not satisfied

Image 2
Image 2726×694 11 KB

Data entry screen as seen in Enketo: when a condition is satisfied

Image 3
Image 3728×693 8.94 KB

Data entry screen as seen in Enketo: when a condition is not satisfied

Image 4
Image 4730×693 11.5 KB

Data entry screen as seen in Enketo: when a condition is satisfied

Image 5
Image 5726×692 8.73 KB

Reference xlsform:

Constraint.xls (37.5 KB)

3

Hi @Kal_Lam

Thank you so much for help. Just confirm for message, we cannot define dynamic message by if then else right?

Best,
Budi

4

If this is what you wish to design, you could do it as outlined in the image shared below:

In the survey tab of your xlsform:

Image 1
Image 11270×150 5.95 KB

Data entry screen as seen in Enketo: when a condition is not met

Image 2
Image 2729×694 10.3 KB

Data entry screen as seen in Enketo: when a condition is met

Image 3
Image 3730×697 9.91 KB

Data entry screen as seen in Enketo: when a condition is not met

Image 4
Image 4730×695 11.5 KB

Data entry screen as seen in Enketo: when a condition is met

Image 5
Image 5728×695 8.76 KB

Reference xlsform:

Constraint.xls (38 KB)

5

Thanks @Kal_Lam very help me so much.

Best,
Budi

1 Like