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.

[sravya vemula]

This is not allowed in our project. I tried to do widget scripting. This is also not working. Please find below script.

if($scope.data.sysUserModel && $scope.data.sysUserModel.location){
var locationmap = {
'Germany' : 'Deutschland'
};
if(locationmap[$scope.data.sysUserModel.location]){
$scope.data.sysUserModel.location = locationmap[$scope.data.sysUserModel.location];
}
}

[Ankur Bawiskar]

@sravya vemula 

did you try to create record into this table "sys_translated_text" for your language?

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

[sravya vemula]

Yes. I tried this. It is nor working

[Ankur Bawiskar]

@sravya vemula 

Easiest way is to change the field type from String to Translated Text and system will do the work for you

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

[Ankur Bawiskar]

@sravya vemula 

create a message in Messages table

then add this line in cloned widget to get the translated value

getMessage("Your Message Key here", function(msg){
alert(msg); 
});

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