Translate a field value

[RSSG]

I want to change field value language from english to other language. Already installed plugins for language translation i.e Internationalization language pack and individual language pack like Japanese,Swedish.

Tried to follow the procedure given on ServiceNow Product Document-Translate a field value, but it is not clearly understood, Steps are not clear to me.

Can anyone help to explain in simple way?

thanks

[Sandeep Rajput · Accepted solution]

@RSSG 

Here is my solution. The field Capability on u_ot_floc should be a translated text field instead of string. Also, I am assuming that this is a normal string field and not choice field.

I tried to replicate the exact same scenario like yours and translation work perfectly in my case.

Here is my table structure.

This is the sample data in English language. Please note all the capabilities are in English here

Now in order to provide translation in Portuguese, I changed the language from preference and moved back to my table. 

Here I initially see Capability in English, here I change the values of each capability field and add their translation in Portuguese

This is how the entire table looks after providing the translation in Portuguese Language.

Now when I change the language again back to English from preference, this is how my table looks in English.

Hope this helps. In case if the capability is a choice field then the translation would be provided in a different way. Please let me know if your capability field is a choice field or not.

[Flavia Margaret]

Hi @Sandeep Rajput, I've tried the methods you mentioned for the string field conversion to translated text field. However, the value is still not updated to the other language even after I changed my preferred language.

I tried this in the OOB Users table and I created a custom field with type=translated text. So I wonder if this method will work only for custom table? TIA!

[Sandeep Rajput]

@Flavia Margaret I verified this by creating a custom field on sys_user table on my PDI and the translation on the custom field on the sys_user table is working perfectly fine. Here are the snapshots.

[Flavia Margaret]

Hi @Sandeep Rajput , I'm still not able to get it translated even after installing Portuguese language.

This is the English version:

This is the Portuguese version where I thought the "Last name custom" value would be translated to Portuguese. 

Also, I checked the sys_translated_text table and I found that there is no record created for the User's record. Could you please advise me what might go wrong? Thank you.