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.
English texts are stored in the master table, while the Translations (sys_translation) table stores localized texts. The Translation table contains several entries of a translated field – one per every language provided.
When you clear a field of the Translated text type, 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 Translations (sys_translation) table, without deleting the others.
Translations 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 master table and the translated text are linked with the Column, Language, Record fields. Use these values when searching for a translation of the English text of the specified field, and if found, it is taken as the translation. It works likewise for the translations into any other languages.