translate choice fields with choices

[tushar_ghadage]

Hi , 

I have a choice field which I want to translate to Norwegian.... 

choice field name is Third party name......I want to translate it to norwegian it has choices like CHA , CHB, CHC ..

But when I create a record with below details in " sys_translated "  table it won't work in the table...

but it's not showing up translated on the portal...

can you please help me on this.

thanks!! 

[Alex Coope - SN]

hi @tushar_ghadage,

If it's a choice field that you're trying to translate then it would be an entry in [sys_choice] and not [sys_translated],

I have a blog post here on how the 5 translation tables work. However, as it looks like you're trying to translate a value on [sc_req_item] table, if you trying to translate a Catalog Item, it would be better to translate using the Localization Framework,

Many thanks,
kind regards

[tushar_ghadage]

okay i have tried translating for the single line text ( by creating a record in translated table ) its working but for multiline text it's not 

can you point out the issue here please as well

[Ankur Bawiskar]

@tushar_ghadage 

translation for choice are stored in sys_choice only

You need to create new choices with Norwegian choice label for the same field and table in sys_choice.

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

[tushar_ghadage]

okay ankur for the multiline text field is the table sys_translated or its sys_translated_text is used ?