Translated text fields allow the same field to display different content based on the user language. In SimpleOne, a special field type named Translated Text was implemented. This field operates the same text field, and it is used all along with the system.
How to perform a translation
......
Administrator information
Technically, the English language text is stored in the master table, but the appropriate values of the other languages are stored in the Translated Text (sys_translated_text) table. Each translated field on every row has one or more entries in the Translated Text table, one per every language provided.
The Translated Text table
The Translated Text (sys_translated_text) table stores translations for fields with the field type translated_text.
Translated text form fields
| Field | Description |
|---|---|
| column_id | The ID of the column containing translated text. |
| record_id | The ID of the record containing translated text. |
| language_id | The ID of the language the text translated into. |
| value | The displayed translated text. |
The English language text in the master table and the translated text are bound with each other by the column_id and record_id fields; these fields' values are used when looking for the translation of the English language text of the specified field, and if found, it is taken as a translation.
