How can I make auto select age category option based on Month

[tanzilhuda]

Hello Expert,
I have the child’s Date of Birth (DOB) Field. It works as auto-calculated the age of the child field. But I also have 4 child age category. Is it possible to auto-selected the child category based on the child’s month?

Thanks

[Kal_Lam]

@tanzilhuda, this post discussed previously should help you solve your issue:

Automatic selection of the age group in a multiple choice list

@esy_cari2020, FYR, you could follow this post discussed previously: @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. 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 th…

[tanzilhuda]

I have used that code:
if(${Month} <= 2,1,if((${Month} >= 3 and ${Month} <= 5),2,if((${Month} >= 6 and ${Month} <=8),3,if((${Month} >= 9 and ${Month} <=11),4,if(${Month} >= 12,5,‘’)))))

But it only works on web form review, not ODK app. My app version is: 2022.3.5
What is the problem? I need, that system will work on my ODK mobile app.

[Kal_Lam]

@tanzilhuda, could you share the related part of the XLSform with the community? The community should be able to help you then.