Hi,
I have started to use suiteCRM for a migration, and I would like to manage contacts titles (functions) in several languages (EN / FR).
To achieve this, I have created a new module called ācontact_titleā :
- ID (uuid)
- code_title (old id CRM)
- name
- language
Exemple of data :
[table]
[tr]
[td]ID[/td]
[td]code_title[/td]
[td]name[/td]
[td]language[/td]
[/tr]
[tr]
[td]929a5b58-feab-483a-a39a-a3b583680eec[/td]
[td]S123[/td]
[td]Developper[/td]
[td]en[/td]
[/tr]
[tr]
[td]a835016a-a7e5-4f6a-8463-001bae752fd9[/td]
[td]S123[/td]
[td]Developpeur[/td]
[td]fr[/td]
[/tr]
[/table]
ācode_titleā is a same for the 2 languages.
But I have an issue with this solution.
In āContactā, I need to use ācode_titleā information and not āIDā, because I need to show āDeveloppeurā if my PDF is displayed in French, or āDevelopperā if it is displayed in english.
The title to be displayed must not depend on the Contact language but on the PDF display language.
Can I link Contact to Contact_title with ācode_titleā information instead of UUID ? Or do I need to change the table structure or even my approach ?
Here would be my other solution for the table structure, but I donāt know if this is a better solution :
- ID (uuid)
- code_title (id old CRM)
- name_fr
- name_en
Thank you for your help !