Help needed: Translation of answers of drill down question leading to wrong results | XM Community
Skip to main content

Hi all,

Following the guidance on this thread, I’ve managed to translate a drill down list of countries for respondents to answer where they come from. However, the alphabetical order of the country list in English and French is different (see image attached). I’ve tested my survey and it looks like this will lead to wrong results. For example, when I input “Azerbaïdjan” in French, the results (shown in English, the base language) read it as “Bangladesh” because of the place they have in the alphabetically ordered list.

Can you think of a way around it without having to show French-speaking respondents a non-alphabetically ordered list?

Thanks in advance!

 

@pilieli I’m afraid you have to match the translation with your survey’s base language. So you have to change the FR name according to EN.


Hi @pilieli , could you try to export the file first and then add the translations and then upload it.


@pilieli I’m afraid you have to match the translation with your survey’s base language. So you have to change the FR name according to EN.

Thank you for your answer. It’s a pity but it looks like I will have to do this and offer my French-speaking respondents a list that is not in alphabetical order (I’ve added a note in the question to bring this to their attention).


Hi @pilieli , could you try to export the file first and then add the translations and then upload it.

Thank you for your answer. That is what I did to upload the translations in the first place and what I used now to update them to make sure they match the base language. Unfortunately, as I said, it doesn’t provide the best experience to my French-speaking respondents but it will do.


Hi @pilieli , 

You can either add custom JS to your question to sort the answer choices when language and drill down choices are selected.

If you don’t want to or can’t use JS, the simpler way would be to have multiple drill down questions (one for each language) and to use display logic to show the right one based on the selected language. The con with that is that your answers will be split between multiple variables. You can still unite them with logic in the survey flow, but depending on the number of languages and possible answers, that could get heavy to program.


@pilieli,

To sort the options in the current language (e.g., French), you would need to use JavaScript to do it dynamically.

For example, I have functions to do it for multiple choice (mcAlphabetize) and side-by-side drop downs (sbsSelectAlphabetize). Drill downs would be a bit different.


Leave a Reply