What should i do if this information pop up during deployment of the tool "[row : 75] On the 'choices' sheet, the 'name' value is invalid. Choice names must be unique for each choice list"

[r_1]

what should i do if this information pop up during deployment of the tool "[row : 75] On the ‘choices’ sheet, the ‘name’ value is invalid. Choice names must be unique for each choice list

[nat]

Hello @r_1 and welcome to the community!
Do you use XLSForms or the web-based form builder to develop your forms? Either way, when you have select-one or select-multiple questions, the key is for each item in your choice list to have a different “name” (i.e. the name used under-the-hood, which is different from the label that is shown to the enumerator).

If you are able to share your XLSForm to this forum then community members may be able to help troubleshoot.

Here’s the official documentation about choice names:

XLSForm Docs

And here’s a previous community forum response that might help your troubleshooting:

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…

All the best!

[r_1]

Hi Natalie,
Thank you for the feedback. kindly find the excel sheet attached for your review
i would be glad to hear back from you soon

(attachments)

anzjpwtUGMFAXrgBkpsAji.xlsx (28.8 KB)

[nat]

Dear @r_1,
Thank you for sending the Excel so promptly!
I’ve had a look at the “choices” sheet and highlighted the two places where there are duplicates:

These choice lists relate to questions 2.12 and 2.16 - if you go into the answer lists for these two questions and remove the duplicates then you shouldn’t receive this error any more.

For 2.12 you just need to delete the second “Rice” answer.
For 2.16 you will need to edit the “name” fields to be e.g. household_spends_less_on_staples and household_spends_less_on_medical - as currently both are household_spends_less_money_on so both answers have duplicate “names”.

Hope that helps

[r_1]

Dear Natalie,

Thank you so much for the support.

it is now okay for use