Create documents in docx, xlsx (MS Office Word and Excel), odt, ods (LibreOffice and OpenOffice) and pdf format without MS Office or others plugins installed from any module and subpanel using templates.
#508 - Mail Merge Reports & Custom Modules
I have custom modules relates to each other three levels deep, (i.e. client header (1st table), client contact (2nd table) and client contact address (3rd table), I want to be able to create mailmerge letters to send to each client contact address but the Available variables list & Generate basic template page only seems to go two levels deep. How can I do this please? Thanks.
-
"The single biggest downfall of the community edition of SugarCRM or SuiteCRM is the lack of creating a report form a custom module for a single event...." - ian
Read More Reviews
- Most Recent Love from Users
HMM Deutschland GmbH- Gregory
- ian
- raskew
- ian
- federicoalejomarco
10 years ago
You need to create a new calculated field for client contact (2nd table) where you will compose the contact address for the client. This calculated field will be filled with the related contact address (3rd table) of the current client contact (2nd table). Please, take a look at the "Calculated Fields" section in the "README.txt" file (in installation zip) where we explain how to create calculated fields, and also the "custom/modules/Opportunities/DHA_DocumentTemplatesCalculatedFields.php" file, where you can get an example of using the calculated fields for the Opportunities module.