I am new to KoboToolbox. I am developing a questionnaire for a quantitative survey in an XLSForm. We have three kinds of Informed Consent forms (adult, parent, child). If the participant is over 18, he/she fills out the adult consent. If the participant is under 18, a parent must fill out a consent from and the child must fill out an assent form.
I have created two text options in Kobo so the data collector can manually input the letter/number code of the consent/assent forms. For example, if the participant is an adult or parent, the data collector inputs AL001 or PL001 (A=adult; P=Parent). If the participant is under 18, a second text option that is not mandatory appears and the data collector can input CL001 (C=child).
I’d like to know if I can do the following.
If the data collector fills in the text box for an adult 18+ informed consent, I would like a conditional date of birth option where it will not allow the participant to enter a date of birth that would make him/her under 18.
If the data collector fills in the text boxes for a parent consent and child assent, I would like a conditional date of birth option that will not allow the participant to enter a date of birth that would make him/her 18 or older.
My questions are:
Can you setup conditional codes in excel for text options? If so, how?
Can you setup validation criteria for text options that would allow for text/number combinations?
I know how to setup the date-month option constraint, but I don’t know how to setup validations or conditionals with text.