Translated Text Fields
The Translated Text field is a special field type that provides translations of different content depending on the user locale. This field operates as a text field and is used throughout the system.
Manage Translated Text fields via tables
English source texts are stored in the Source Message (source_message) table. Corresponding localized versions are maintained in the System Translation (sys_translation) table, with a separate record created for each target language.
When you clear a field of type Translated Text, only the value for the current language is deleted. The values for other languages remain. In such cases, you delete only one record in the System Translation (sys_translation) table, without deleting the others.
System Translation form fields
| Field | Mandatory | Description |
|---|---|---|
| Column | Y | Select the column whose value you need to translate. |
| Language | Y | Specify the language of the translation. |
| Value | N | Add a translation of the original value. |
| Record | Y | Specify the Unique ID number of the record. The value is filled in automatically, if you create the translation via the Related Lists of the record. If the ID field is empty, type the ID of the record. |
The English text in the Source Message (source_message) table and the translated text are linked with the Column, Language, and Record fields. Use these values when searching for an English translation of the specified field. If found, it is taken as the translation. It works likewise for the translations into any other languages.
Manage Translated Text fields via API
You can manage translations for Translated Text fields and REM attributes in the SimpleRecord class via API:
- Set and edit translations with the setTranslation() method for one language and the setTranslations() method for multiple languages at once.
- Get the existing translations with the getTranslation() and getTranslatedText() methods for one language, as well as the getTranslations() method for all the translations that exist for this field or attribute.