Print A Word Document with Domo Data Using Word Template
![fhtechllc](https://us.v-cdn.net/6032830/uploads/defaultavatar/nZ5X977MOM3Z6.jpg)
I am not sure if anyone has done something similar, but I am trying to print a WORD document /PDF that contains DOMO information from a row.
For instance, I have a table that contains 10 columns of data, I want to be able to insert data from specific columns to specific fields in the WORD doc and print it as a PDF
Best Answer
-
This is something where you could use workflows to upload the text you want changed and use some simple javascript to modify the text and then download it.
Here is an example:function downloadAsWordDoc(content, filename) {
const zip = new PizZip();
const doc = new Docxtemplater(zip); doc.loadZip( new PizZip( `<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <w:document xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main"> <w:body> <w:p> <w:r> <w:t>${content}</w:t> </w:r> </w:p> </w:body> </w:document>` ) ); const blob = doc.getZip().generate({ type: 'blob', mimeType: 'application/vnd.openxmlformats-officedocument.wordprocessingml.document' }); saveAs(blob, filename); } const template = Hello <USERNAME>!
I wanted to inform you that your <YEAR> <MAKE> <MODEL> vehicle is due for service.
You should contact 801-833-XXXX and plan a date to bring in your vehicle.; const values = {
USERNAME: 'John Doe',
YEAR: '2021',
MAKE: 'Toyota',
MODEL: 'Camry'
}; const result = replacePlaceholders(template, values);
downloadAsWordDoc(result, 'document.docx');
————————
This type of implementation could take just a little bit of custom code to get working in my opinion, but the connecting it up will just take some tweaking.** Was this post helpful? Click 💡/💖/👍/😊 below. **
** If it solved your problem. Accept it as a solution! ✔️ **2
Answers
-
Would all of the values that you wanting to use to populate the Word document be from the same row? Would you only want to pull in a single row at a time?
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**0 -
@david_cunningham
Would all of the values that you wanting to use to populate the Word document be from the same row? Would you only want to pull in a single row at a time?
Yes, to both.0 -
This is something where you could use workflows to upload the text you want changed and use some simple javascript to modify the text and then download it.
Here is an example:function downloadAsWordDoc(content, filename) {
const zip = new PizZip();
const doc = new Docxtemplater(zip); doc.loadZip( new PizZip( `<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <w:document xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main"> <w:body> <w:p> <w:r> <w:t>${content}</w:t> </w:r> </w:p> </w:body> </w:document>` ) ); const blob = doc.getZip().generate({ type: 'blob', mimeType: 'application/vnd.openxmlformats-officedocument.wordprocessingml.document' }); saveAs(blob, filename); } const template = Hello <USERNAME>!
I wanted to inform you that your <YEAR> <MAKE> <MODEL> vehicle is due for service.
You should contact 801-833-XXXX and plan a date to bring in your vehicle.; const values = {
USERNAME: 'John Doe',
YEAR: '2021',
MAKE: 'Toyota',
MODEL: 'Camry'
}; const result = replacePlaceholders(template, values);
downloadAsWordDoc(result, 'document.docx');
————————
This type of implementation could take just a little bit of custom code to get working in my opinion, but the connecting it up will just take some tweaking.** Was this post helpful? Click 💡/💖/👍/😊 below. **
** If it solved your problem. Accept it as a solution! ✔️ **2
Categories
- All Categories
- 1.6K Product Ideas
- 1.6K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 286 Workbench
- 4 Cloud Amplifier
- 6 Federated
- 2.7K Transform
- 91 SQL DataFlows
- 582 Datasets
- 2.1K Magic ETL
- 3.5K Visualize
- 2.4K Charting
- 632 Beast Mode
- 32 App Studio
- 33 Variables
- 619 Automate
- 158 Apps
- 424 APIs & Domo Developer
- 35 Workflows
- 2 DomoAI
- 31 Predict
- 12 Jupyter Workspaces
- 19 R & Python Tiles
- 375 Distribute
- 105 Domo Everywhere
- 266 Scheduled Reports
- 4 Software Integrations
- 104 Manage
- 101 Governance & Security
- 4 Domo University
- 15 Product Releases
- Community Forums
- 39 Getting Started
- 30 Community Member Introductions
- 92 Community Announcements
- 4.8K Archive