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)

[esy_cari2020]

Hello Kal;
Sorry to come back to it, but I’ve been trying for several months this formula which is essential for me, but I can’t do it? I can’t identify the error either; yet it worked well in the previous form.
Please help me please!
1- when the age is less than 15, then it automatically ticks modality 1
2- when the age is between 15 and 29, it automatically selects modality 2
3- when the age is over 30, then it automatically selects modality 3.
Here is the principle of my request!
Thanks

[esy_cari2020]

hello family
Form_collecteur_draft.xlsx (19.7 KB)
Form_collecteur-C.xlsx (19.9 KB)
Sorry to come back to it, but I’ve been trying this formula for several months, which is essential for me, but I can’t do it? I can’t identify the error either; yet it worked well in the previous form.
Please help me please! I’m really stuck on this project because of this formula!

1- when the age is less than 15, then it automatically ticks modality 1
2- when the age is between 15 and 29, it automatically selects modality 2
3- when the age is over 30, then it automatically selects modality 3.
Here is the principle of my request!

[Kal_Lam]

@esy_cari2020, did you have a chance to play around with the post shared previously? The workaround should help you solve your issue.