Record producer select box show different values based on user language.

[Jim Calhoun]

I have a standard record producer built many years ago just in English.  I need it to work in French but some of the fields are custom and the select box values are in English.  I have had them translated to French, but I am not sure how to have them added and how to get them to be available for the French users.  I have enabled the French plugin.  I was thinking of created a new record producer for the French user and direct them to it upon login.  Not sure what is the best practice is here.

thanks - Jim

[-O- · Accepted solution]

Well, then the question is: do you want to have all options in French too, or do you want to have 32 options for users choosing English as their UI language and 2 options for those choosing French.

If you want to have the same amount of choices in both languages, you should just define all remaining values with French labels too. As you start defining those French labels for existing not-yet-translated values, you should see that the English counterpart will disappear from the list. E.g. if you add the French translation for Drum, the English choice should no longer show up when switching to French. A.s.o.

[Jim Calhoun]

i will do that tomorrow.  I hope it works

[Jim Calhoun]

janos,

your answer worked.  I am on to the next issue.  Some of my questions (variable) will not translate.  I am going in to the definition while French is the language and changing the question text to French and I get an error that it already exists.  What am I doing wrong.

[-O-]

There are various reasons why saving a translation like that could fail. Perhaps there already is a disabled one?

In any case you should open the list of choices (sys_choice.list), filter it down to your table and your field and order it by value and language. You would then be able to have a view of what is going on. You could also create any missing values manually. Or maybe you just need to de-deactivate some deactivated French translation.