Flagging or automatically correcting inconsistent responses

[vincentkayemba]

Dear friends,
I have tried searching an answer to my issue but couldn’t find one from those already existing.

I have two questions

1. In which year were you born?
2. How old were you at your first birthday?

I want to set the validation criteria such that;

• In Question 1, the system does not accept answers beyond the year 2004. And so does not allow the interviewer to proceed to the next question.
• In Question 2, if the respondent says 22 years in 2018 (assuming it was the last birthday he remembers) and yet in Question 1 he said was born in 2000, the system detects this inconsistency, flags it OR the system detects it and adjusts the answer in Question 1 to 1996.

Thank you

[hakan_cetinkaya]

Hi @vincentkayemba,

1- You need to put a constraint:

.<=date(‘2004-01-01’)

This will let the system doesn’t allow answers beyond the year 2004. You can find more info in this forum post:

How to limit the display of years to certain ranges

Welcome to the community, @mjemal! Maybe you could design your xlsform as outlined below, which should restrict users to select the date from within a specified range: In the survey tab of your xlsform: [Image 1] Data entry as seen in Enketo: (when a date is entered outside the range) [Image 2] Data entry as seen in Enketo: (when a date is entered within the range) [Image 3] Reference xlsform: Date Constraints.xls (37.5 KB)

2- I think the question is not right in here? Can you try to explain this?

@vincentkayemba

How old were you at your first birthday?

[vincentkayemba]

The question “How old were you at your last birthday” means how old was the respondent as of December 2021 assuming their birth month is December OR how old was the respondent as of June 2022 assuming their birth month is June?

[wroos]

Has been discussed in several previous postings, which can be found with the search function of this forum, please, see Search results for 'calculate age from birth year' - KoboToolbox Community Forum

[Kal_Lam]

@vincentkayemba, in addition to what @hakan_cetinkaya has advised, you should also be able to solve your issue by going through this post discussed previously:

Restrict the response base on a possible empty question (the answer for this question might be empty)

@manh_nguyen, you should be able to do it as outlined in the image shared below: In the survey tab of your XLSForm: [image] Data entry as seen in Enketo: when date 2 is smaller than date 1 [image] Data entry as seen in Enketo: when date 2 is equal to date 1 [image] Data entry as seen in Enketo: when date 2 is greater than date 1 [image] Reference XLSForm: Constraint Date.xlsx (9.7 KB)