Inserting Constraint in XLSForm 1

Support
1

Hello
I am creating a form in XLS and I want to include a validation rule for the questions below;
Question 1: How many cases of Cholera were reported?
Question 2: How many Cholera related deaths were reported?

I want to insert a validation rule such that the response for question 2 should not be greater than the answer for question 1.

2

Please try this sample: constraintTest.xml (986 Bytes) constraintTest.xlsx (5.4 KB)

1 Like
3

Hi @Marsha0285,

With the sample form provided, you can add a custom message using
constraint_message eg. the Number of deaths is greater than the number of cases. Please confirm only cholera-related deaths are required.

4

Thanks a lot, this helps. Got it.

5

Yes, only cholera deaths are required.

Thanks