Hello every body, I need your support please
I would like to have a form Excel (below) which will allow to choose for example Admin2 only for a range of household number ranging from 51 and 100:
That is, when we choose an Admin that the household number assigned in this Admin depends on it
Admin1 (1 -50)
Admin2 (51 -100)
Admin3 (101 -150)
Admi4 (151 -200)
Thank you
Welcome back to the community, @masalafortunat! You could do it as outlined in the image shared below:
In the survey tab of your xlsform:
In the choices tab of your xlsform:

Data entry screen as seen in Enketo: when entering an input outside the range
Data entry screen as seen in Enketo: when entering an input inside the range
Data entry screen as seen in Enketo: when entering an input outside the range
Data entry screen as seen in Enketo: when entering an input inside the range
Data entry screen as seen in Enketo: when entering an input outside the range
Data entry screen as seen in Enketo: when entering an input inside the range
Data entry screen as seen in Enketo: when entering an input outside the range
Data entry screen as seen in Enketo: when entering an input inside the range
Reference xlsform:
Constraint.xlsx (13.9 KB)
Thank you Kal_Lam for your quick help
1 Like