Issue with Translating Reference Field Values

[Ramya1206]

Hi All,

I've been trying to translate the values of a reference field, but it doesn't seem to be working as expected.

The reference field values display the user's name and position — the position value needs to be translated. This field refers to the Position field in the HR Profile table. I attempted to create translations using the Translated Text table, but the values do not change when I switch the user's language.

Could you please advise if translating reference field values is supported in this scenario? If so, what would be the correct approach to make it work?

Thank you in advance for your help.

Best regards,
Ramya

[Mark Manders]

Did you try to translate the 'Position' field, or the reference field? Because a reference field only shows the display value of the record you are referencing, so that's the field that needs to be translated.

[Ramya1206]

Hello Mark,

The reference field uses the HR Profile table, which contains a field called Position. In the screenshot below, we need to translate the value marked in red — which is the user's position.

[Mark Manders]

That doesn't answer my question. You said you tried to translate some field. Was that the position field on the HR Profile table, or the position field that references the HR Profile table? Because you should translate the source: the position field on the HR Profile table (as swapnali ombale already said).

[swapnali ombale]

Hi @Ramya1206 

 Reference field value translations: Usually, the reference field shows the values from display field of the table referenced in the reference field. In order to allow translation on your display field, you need to change the field type to sys_translated_text and provide the translation of values in the desired languages. Once done values will be translated depending on the chosen language,

Imagine you have a custom table called u_my_table that is referenced in a field on the incident table. If the name field on u_my_table is the display value and you haven't translated the name field, then when a user changes the language to French, the reference field on the incident form will still show the English name of the record from u_my_table. To fix this, you would need to: 

Set the name field type to sys_translated_text. 

Provide translations for the name field values in the desired languages. 

Verify that name is still set as the display value for u_my_table. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway.