Automatic selection of the age group in a multiple choice list

[esy_cari2020]

Good evening dear friends!
I have a problem with my form design, especially with a calculation I would like to make.
Indeed, I want to determine (calculate) the age of the respondent according to the year with this formula:
year()-${Year_of_Birth}
Is the formula correct?
My second concern, I would like to automatically select the age range in which the respondent is located, according to his calculated age. I have inserted the following formula, but it displays an error:

’'if(${Age} < 21,1,if((${Age} >= 22 and ${Age} < 30),2,if((${Age} >= 30 and ${Age} < 35,3),if(${Age} >= 35 and ${Age} <40),4,if(${Age}>=41 and ${Age} < 50),5 if(${Age}>50,6 ‘’))))))

Can you help me?
automatic selection of the age group in a multiple choice list.xlsx (5.3 KB)

Finally, is it possible to generate a QR code automatically for each target surveyed?
Attached is the form and the screenshot of the enketo version

[Kal_Lam]

@esy_cari2020, FYR, you could follow this post discussed previously:

Automatic selection of one answer based on another

In this case you could do it as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry as seen in Enketo: condition that meets the first criteria [Output 1] Data entry as seen in Enketo: condition that meets the second criteria [Output 2] Data entry as seen in Enketo: condition that meets the third criteria [Output 3] Data entry as seen in Enketo: condition that meets the fourth criteria [Outp…

@esy_cari2020, I could also see some age group being overlapped like (21, 35). Maybe you will also need to fix the criteria.

Your formula used for calculating age also seems OK. But we too have other workarounds to calculate age if you wish to try out.

Want to hide the DOB after calculating age once the forms is submitted to the server

Welcome back to the community, @cprosperi! You could do this as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: you still have not triggered the submission [Image 2] Data entry screen as seen in Enketo: you have now triggered the submission [Image 3] Data as seen in DATA>Table: age seen but DOB has been hidden [Image 4] Reference xlsform: Age Calculation.xlsx (9.8 KB)

Sorry, I did not get the last one regarding the QR code. BTW, it’s always good to have a separate topic if you have separate issues. This should help the community with the search index.

[esy_cari2020]

Hello kal
I have received guidance on the last post on automatic age range selection. However, when I reproduce the same scheme following your guidance of course, the function does not work. I don’t know why?
Nb: I use google sheet

Furthermore, to calculate the age, I want to retrieve the current year, and not define a year myself.
Current age = current year (2022) - Year of birth (year entered by the user)
For precision, I want the current year to be updated systematically over the years.

Merci
Form_collecteurs_V2.1.xlsx (24.9 KB)

[Kal_Lam]

@esy_cari2020, you should be able to calculate the age as you wish by following this post discussed previously:

How to constrain a date entry that allows an enumerator to input age between 15 to 24 years?

@lamo, you could do it as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enekto: when a date is entered outside a range [Image 2] Data entry screen as seen in Enekto: when a date is entered within a range [Image 3] Data entry screen as seen in Enekto: when a date is entered outside a range [Image 4] Reference xlsform: Constraint Age.xlsx (9.8 KB)