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.
#412 - How to Make Use of Related Fields in Word DOCX Template
Hello There,
Lets say I have the following tables: Companies (with Name, and relationship 1-to-many Divisions table) Divisions (with Name, and relationship 1-to-many to Users table) Users (with Name and PhoneNumber fields)
If I wanted to have a Mail Merge that makes use of all this information (from Companies), how can I write this. I had thought something like:
[a;block=w:body;sub1=divisions;sub2=(users)]
Company: [a.name]
Division: [a_sub1;w:p;a_sub1.name]
User: [a_sub1_sub2.name]
But I can't seem to get it to work... I've tried a few other things as well, but alas, no luck!
Any direction would be a huge help!! Mark.
-
"It has improved our processes so much! Admin cut in half! We send a webform to clients to sign up straight into CRM then generate and print their paperwork to sign."
Read More Reviews
WSiedler
6 years ago
This is on version: Version 7.8.1 Sugar Version 6.5.24 (Build 509)
5 years ago
Hi,
Sorry for not answering you. Have you solved already your problems?
Thanks,
Anabel