Data Quality check

Support
1

Please am trying to ensure data quality check in ODK XLS,
What I want to achieve is that, there is a previous question Q12 which ask for number of staff and there is Q13. that ask how many staff work as nurses. I want to ensure that number of staff who work as nurses is not more than number of staff
Please how can I achieve that in ODK xls

2

You have to add a logical test in the constraint column of the Q13 question :
. <= ${Q12}

Means that current value (.) must be less or equal to the Q12 value
You can use constraint_message column to show an alert on error.

https://docs.opendatakit.org/form-logic/#validating-and-restricting-responses

1 Like
3

Thank you very much Mathieu,
It works perfectly

1 Like