Reference behaving different in different languages

[Natalia Arvizu]

Hello all, 

I have a question which is a reference of Question Choices table. Everything works in English but I started with localization to Spanish and the reference behaves different in each language. 

1. The order in english is A-Z, but in Spanish they're not (values aren't translated)
2. When searching in spanish doesn't retrieve any result. I was checking directly in the table and even tho the question is there, if I filter the table by that question I don't get any results (when I switch to spanish)

Any guidance will be appreciated, thanks. 

[Ashish Narwal]

Hi Natalia,

Have you translated the Question Choices on which you are facing this issue ?

[Natalia Arvizu]

Hi, 

No, it looks like that was the issue, we imported the information into the Question Choices and therefore it was a lot of info to be translated, I ended up changing from Referent to Lookup Select Box and now it's solved. Otherwise I would had to translate all the options. 

[SumanthDosapati]

Hi,

In which table did you translate the values?

Use appropriate table as below for translation

• [sys_documentation] - this holds field labels for all languages (including the English)
• [sys_choice] - this holds drop-down choices for all languages (including the English)
• [sys_ui_message] - this holds the messages called in scripts being sent to the Message API (ideally also including the English)
• [sys_translated] - this holds "translated_field" values (not including the English)
• [sys_translated_text] - this holds "translated_text" values (also not including the English)

Mark as correct and helpful if it solved your query.

Regards,

Sumanth

[Natalia Arvizu · Accepted solution]

It seems like in order to behave in the same way as in English values has to be translated in all languages. Since we had a lot of options I was expecting to take the english ones by default. 

I changed from Reference to Lookup Select Box, and with this type of field I don't need to translate them to behave the same as in English. 

Thanks to the other 2 replies to pointing me into the right direction