Preview problem

[mitikuk]

Hello, When I try to preview my form, I get the error message: “There does not seem to be a allow_choice_duplicates column header defined in your settings sheet. You must have set allow_choice_duplicates setting in your settings sheet to have duplicate choice list names in your choices sheet.”

I know that others have asked this question before me and gotten help from you to resolve the problem, but I’m unable to use the previous conversation to solve my problem. Perhaps it’s because I am on the insight level of “chose and click”, and don’t really understand how the program works…

My form worked fine until two days ago, when I added some questions to it. The research team is set to start the data collection next week, so I’m a bit desperate to fix this fast.

Help would be highly appreciated!

Regards,
Mitiku

[Kal_Lam]

Welcome to the community, @mitikuk! Kindly please be informed that it’s an issue with your xlsform, which you should be able to fix by validating the same through this online validator.

You should also be able to learn more by following the post discussed previously:

Choice duplicate

Hi @maggib, I found the duplicate that i have highlighted with yellow and marked the font with red within list_name lf3sx85 whose name prefer_not_to_answer is seen repeated twice within list_name lf3sx85. For your ease check row number 89 and 93 under choices tab. [Image 1] The principle behind this is that each list_name should have unique code under it’s associated name. e.g. this is not allowed … list_name name test a test a test a … but this is allowed … list_name na…

If you still have issues, please feel free to share your xlsform with the community.

[mitikuk]

still can’t be fixed.

[Kal_Lam]

Maybe the community should be able to help you out if you share your xlsform with the community.

[mitikuk]

here is the xls form

[Kal_Lam]

@mitikuk, would you mind sharing your xlsform instated of the link?

[mitikuk]

ar6jSkXAnhZ3TEEMhqLp3q.xlsx (31.8 KB) this is the xls form

[Kal_Lam]

@mitikuk, while validating your xlsform with the online validator, i found this issue:

This means, if you go to the choices tab of your xlsform and then search tn9om40 which is located in row 101 to 107, you will see row 106 and row 107 with the similar name:

The best option to overcome this is by providing a unique name as shared in the second post (linked above). So basically, you will need to keep fixing and validating it again until the online validator no more shows any issue.

[mitikuk]

thanks a lot.

[mitikuk]

Dear
how to allow_choice_duplicates setting kobocollect in settings?
can you show the steps please?

[Kal_Lam]

@mitikuk, you could set this as outlined in the post that has been discussed previously:

How to keep some choice(s) visible at all times with the aid of a cascading select function?

Well this is very clear now. You could do the same as outlined in the image below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] In the settings tab of your xlsform: [Image 3] Data entry screen as seen in Enketo: (when a condition is not met) [Image 4] Data entry screen as seen in Enketo: (when a condition is met) [Image 5] Reference xlsform: Cascading Select.xlsx (13.3 KB)