Translate Location Germany Value which is displayed on user profile in service portal

[sravya vemula]

Hi Everyone,

I have a requirement where I should translate the word Germany which is shown for users with Germany as Location in User Profile on Service Portal. But Servicenow did not provide translations for cmn_location table. So how can we write a script on user table such that this can work for only Germany Word ? The translation for only Germany should be done and not touching other values in the table.

[Ankur Bawiskar]

@sravya vemula 

which field and table you want to translate?

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

[sravya vemula]

HI,

This is for cmn_location table. The Name field to be translated for Germany. 

[Ankur Bawiskar]

@sravya vemula 

did you try updating the field type for Name on cmn_location from String to "Translated Text"?

If you did it then system will automatically translate the name field

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

[sravya vemula]

Yes. I tried this. This is not working.