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. 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. Automatically filled, if you translate viaRelated Listsof the record. If the ID field is empty, type theIDof the record.
The English text in the master table and the translated text are linked with the Column, Language, Record fields. These values of these fields are used when searching for a translation of the English text of the specified field, and if found, it is taken as the translation. This is applied to translations into any other language.
