I’m collecting data for a household, and each household can have a maximum of say, 3 plots of land. And for each of these three, they can grow a maximum of 2 crop types. So I want to collect data on crop yields for each plot and it’s important to prevent a situation whereby a user enters a given crop more than once for a given plot, i.e, this is valid:
Plot A
Crop Maize
Plot A
Crop Beans
Plot B
Crop Maize
Plot B
Crop Beans
but not
Plot A
Crop Maize
Plot A
Crop Maize <— duplication
To achieve this kind of data collection I am using nested repeats of questions…can anyone advise on what kind of calculation/constraint would help me achieve the above validation? It seems as though I’d need to use loop logic to check through the values of the repeats and halt/flag on encountering a repeat but I can’t imagine how I’d do that with the XLSX form?
Referring to the requirements laid by @Hussein_Lightwalla1 i have made a workaround which should help solve your issue, Please follow the instructions outlined in the image below: