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

Help needed: Translation of answers of drill down question leading to wrong results

  • September 18, 2023
  • 6 replies
  • 207 views

Forum|alt.badge.img+1

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!

 

6 replies

Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+29
  • QPN Level 8 ●●●●●●●●
  • 1091 replies
  • September 18, 2023

@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.


Naman_Savla
QPN Level 4 ●●●●
Forum|alt.badge.img+9
  • QPN Level 4 ●●●●
  • 37 replies
  • September 18, 2023

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


Forum|alt.badge.img+1
  • Author
  • 3 replies
  • September 18, 2023
dxconnamnguyen wrote:

@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).


Forum|alt.badge.img+1
  • Author
  • 3 replies
  • September 18, 2023
Naman_Savla wrote:

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.


vgayraud
QPN Level 5 ●●●●●
Forum|alt.badge.img+48
  • QPN Level 5 ●●●●●
  • 373 replies
  • September 18, 2023

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.


TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • Level 8 ●●●●●●●●
  • 5929 replies
  • September 18, 2023

@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