I’ve discovered a data integrity issue in our household survey dataset where over 1000 records contain blank values in the country field while having populated values in the dependent province and municipality fields. This appears to violate the form’s cascading logic and mandatory field requirements.
Form Configuration
- Form type: Household survey
- Field setup:
- Country field:
select_onetype - Province field: Cascading select (dependent on country selection)
- Municipality field: Cascading select (dependent on province selection)
- Both province and municipality are set as mandatory fields
- Country field:
Expected Behavior
Based on the form logic:
- User must select a country to activate province field
- User must select a province to activate municipality field
- Since province and municipality are mandatory, the form should not allow submission without a country selection
Actual Behavior
- Affected records: Over 1000 records
- Issue: Records show:
- Country field: Blank/empty
- Province field: Contains values
- Municipality field: Contains values
Impact
This data inconsistency affects our analysis reliability and suggests a potential bypass of the form’s validation logic.
Questions for Investigation
- Could this be related to form version changes during data collection?
- Are there known issues with cascading select validation in specific KoboToolbox versions?
- Could offline data collection have contributed to this validation bypass?
- Is there a way to identify when/how these records were created?
Request
Could the development team investigate this validation issue? I’m happy to provide additional details or form specifications if needed.
Has anyone else experienced similar issues with cascading select fields and mandatory field validation?
Thank you for your assistance.
