Skip logic Problem and Functionality error

Dear friends.
Please am currently having a serious issue in the kobotools form.
I want a person who select say:

Ques. What Diocese are you collecting data for

    1. Accra
    1. Cairo
    1. Vietnam
    1. China
    1. USA

Now is a person select Cairo then this question should display with the following choices

Ques. Name of. Deanery

  • Goodland
  • lakeside
  • spaworld
  • Dreams

But if a person selects say Accra I want this same question to display Name of. Deanery but now different option set like this:

Ques. Name of. Deanery

  • Volta
  • Greater Accra
  • Cape coast
  • Ho

and then if a person selects say China I want this same question to display Name of. Deanery but now different option set like this:

Name of. Deanery

  • Benjing
  • xing tai
  • lowfalls
  • waterlands

Now, here is the error, I’ve set all the question to “Name of. Deanery” and I’ve displayed the options for each of the question name Name of. Deanery. But when i set the logic say:

This question will only be displayed if the following conditions apply:

Name of. Deanery = Accra
it repeat through even all the conditions although ive changed the options for different for example:
Name of. Deanery = Accra. keeps repeating Although ive change it to

Name of. Deanery = Cairo
Name of. Deanery = China
Name of. Deanery = Vietnam
Name of. Deanery = USA etc.

Please can i get a quick support and answer.
Thanks

Hi

Solve it with choice_filter like this :
https://ee.kobotoolbox.org/x/#fMfcAJ9k

Follow this link :
http://support.kobotoolbox.org/creating-forms/general/adding-cascading-select-questions

Thanks

Regards
Tulus

Please can you share the xlsform you’ve used for me to see… Also can it be done directly in koboforms, if so, can you show me how.

Thanks for the fine support

Ya, sure.
aET8DvauqDw2nJxn5S7KZe.xls (9.5 KB)

I think it can be created only in excel …

Regards
Tulus

Very good, I am happy this is solved.