How to correctly implement language variable choices on record producer

[sravanku888]

I have a Record Producer with a 'Select Box' variable named 'language'. Its choices are currently static language names like 'Dutch', 'Spanish', 'French', 'Portuguese'. My goal is for these choice labels to display in the user's chosen language (e.g., if a user's profile language is German, 'Dutch' should appear as 'Niederländisch'). I've tried changing my user profile language and then updating the choices, but this just overwrites the original choice label with the new language's label, making it static for everyone regardless of their language setting. What's the correct approach to achieve dynamic translation of these language names?

[Ankur Bawiskar]

@sravanku888 

check this link which talks about the tables involved for translations

Everything you ever wanted to know about the 5 translation tables 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[sravanku888]

The challenge I'm facing is that the choice values themselves are not consistently translating to Spanish. For instance, if I have a choice "Computer" in English, and I've provided the Spanish translation "Computadora", it only displays in Spanish if the user's language is explicitly set to either English or Spanish. If the language is set to anything else (or perhaps defaults to English before switching), it might not show the Spanish translation.

What's working correctly:

The labels of the form variables themselves are translating perfectly to Spanish.