Auto Select Country based on city select

[kobo7805]

Hi, I want automatically select the country based on the city typed by the user.
e.g
Texas = USA
Tokyo = Japan
most solutions use a calculate such as “if(${city} = ‘Texas’ , '1__USA,‘nochoice’)”
however, I have over 1000 cities so I’d prefer something more dynamic.
(P.S my choices sheet contains both city & country)
How can I do this?

[Kal_Lam]

@kobo7805, these posts discussed previously should help you solve your issue:

Cascade in reverse way

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 screen as seen in Enketo: [Image 3] Data entry screen as seen in Enketo: [Image 4] Data entry screen as seen in Enketo: [Image 5] Data entry screen as seen in Enketo: [Image 6] Reference xlsform: Cascading Select.xlsx (12.3 KB)

And this post too …

Displaying choices based on previous group (reverse cascading)

Hi @pashches, Welcome to the community! You could also try this out apart from what @NoelCartONG has advised. In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry screen as seen in Enekto: [Image 3] Reference xlsform: Cascading Select.xlsx (12.0 KB) Have a great day!