Document Generation – Word and Excel Templates

Business Background

Easily configure Salesforce document generation with Titan Web.

Titan Solution

• Configure document generation by adding Microsoft Word and Microsoft Excel templates to a project.
• For Word and Excel templates, you can do the following:
  • Preview
  • Download
  • Interactive
  • Email
  • Edit
  • Push to Salesforce
• Editing this uploaded template does not impact or alter the original document.

How to Guide

1. Drop a Word or Excel document in the block from your file explorer. The file is added to the screen.
2. Alternatively, click in the block to upload a document. The standard Microsoft Open screen opens.
   • Browse to the file destination and click on the required file.
   • Click on the Open button. The file is added to the screen.

3. Do the following if necessary:
   • Click the X icon next to the document name to delete the document.
   • Click on the Download Template option to download the template.
   • Use the Drop document here block to replace the uploaded template.
     • You will see a confirmation message: “Please confirm: You are about to replace the template.”
     • Click the required button.
   • Click on the View Versions option to view the version of the template. The View Versions screen opens.

4. Click the Next button on the Configure Project Document Generation Settings screen.
5. Use the checkboxes to select option/s. The document in each option will be in DOCX or PDF format:
   • Preview: Preview a generated and populated document.
   • Download: Download a dynamic document.
   • Generate Interactive: Generate a document containing interactive fields that your end user can edit.
   • Email: Send the template as an email attachment.
   • Edit: Generate an editable document in DOCX or PDF format. The edited document can be pushed to Salesforce.
   • Push to Salesforce: Push a DOCX or PDF document to Salesforce in the desired output format.
6. Click the Next button.

7. Under General, change the label of the template if necessary. The document name is added by default.
8. Use the drop-down list to add a Record ID.
   • The Record ID is mandatory.
   • This is either an input field or a custom variable that you added to the project.

9. Configure the options that you selected:
   • Preview
   • Download
   • Interactive
   • Email
   • Edit
   • Push to Salesforce
10. Change the captions if necessary.
11. View where the template was used.

Preview

1. Click the Preview option.
   1. Use the toggle switch to enable the Preview functionality.
   2. Use the drop-down list to select an output format:
      • docx
      • xlsx
      • pdf
   • Use the drop-down list to select a program to view the Word (docx) document.
     • Microsoft
     • Google
     • Titan (recommended)
       • Use the Zoom drop-down list to select an option.
         • Fit to device
         • Select a zoom percentage.

2. Under the Preview option, do the following for Excel (xlsx) spreadsheets:
   1. Use the drop-down list and select the xlsx option.

3. Under the Preview option, do the following for PDF documents.
   1. Use the drop-down list and select the pdf option.
   2. Use the drop-down list to select a program to convert the pdf document.
      • Libre Office
      • Office 365
      • Google
      • Titan (recommended)
        • Use the Zoom drop-down list to select an option.
          • Fit to device
          • Select a zoom percentage.
      • Titan 2
   3. For the Titan (recommended) option, use the checkbox to activate the PDF/A option if necessary. This is the ISO-standardized PDF.
   4. For the Titan (recommended) option, use the checkbox to activate the Bookmarks option if necessary. This is the navigation tool for documents.
   5. Use the drop-down list to select the option to view the document.
      • Microsoft
      • Google
      • Titan 1 (Recommended)
        • Use the Zoom drop-down list to select an option.
          • Fit to device
          • Select a zoom percentage.
      • Titan Mini
        • Use the Zoom drop-down list to select an option.
          • Fit to device
          • Select a zoom percentage.

4. If necessary, do the following:
   1. Click the Add action option and add button text.
   2. Click the Configure Action button to configure an On Click Action.
   3. Click the checkbox to hide the download button.
   4. Click the checkbox to optimize the image quality for better performance.
      • This will reduce the image quality to 80% of the original and will therefore reduce the file size.

Download

1. Click the Download option.
   1. Use the toggle switch to enable the Download functionality.
   2. Use the drop-down list to select an output format:
      • xlsx
      • docx
      • pdf
        • Use the drop-down list to select a program to convert the pdf document.
          • For the Titan (recommended) option, use the checkbox to activate the PDF/A option if necessary. This is the ISO-standardized PDF.
          • For the Titan (recommended) option, use the checkbox to activate the Bookmarks option if necessary. This is the navigation tool for documents.
   3. Use the toggle switch to add a dynamic file name if necessary.
      • The Custom Name field changes to a drop-down list where you can select the dynamic file name.
   4. Type a custom name.
   5. Use the toggle switch to enable the actions while waiting: Freeze the screen while the template is generating.
   6. Click the checkbox to optimize the image quality for better performance.
      • This will reduce the image quality to 80% of the original and will, therefore, reduce the file size.
   7. Use the toggle switch to enable the actions while waiting: Show a progress bar.

Interactive

1. Click the Interactive option.
   1. Use the toggle switch to enable the Interactive functionality.
   2. Click the checkbox to optimize the image quality for better performance.
      • This will reduce the image quality to 80% of the original and will therefore reduce the file size.
   3. Use the toggle switch to enable the Zoom Settings.
      • Click the Gear icon to open the Document Generation Device Zoom screen.
        • Use the drop-down list to select general zoom options. This is the default option.
        • Click the Custom zoom radio button to configure the custom zoom options for desktop, laptop, tablet (L), tablet, mobile (L), and mobile (S).
   4. Use the toggle switches to enable the Interactive Viewer options:
      • Show Header
      • Show Footer
      • Show Toolbar
      • Show Next Step
      • Allow Print
   5. Use the toggle switches to enable the Ensure filled % option.
      • When this option is enabled, the signer will be required to make a signature larger than the percentage specified in the “Ensure Fill Value” field in the signature box.
      • This will prevent the signer from simply making a dot in the mandatory signature field.
        • Add a positive integer number in the Ensure Filled Value field. One or two percent is sufficient.
   6. Use the toggle switches to enable the Auto Clear Signature option.
      • The signature field will be cleared after the document was submitted.
   7. Use the toggle switches to enable the Configure Actions options:
      • On Submit Action
      • On Close Action
   8. Use the Gear icons to configure the actions:
      • On Submit Action
      • On Close Action

Email

1. Click the Email option.
   1. Use the toggle switch to enable the Email functionality.
   2. Use the drop-down list to select an output format:
      • xlsx
      • docx
      • pdf
        • Use the drop-down list to select the program to convert the document.
   3. Use the toggle switch to add a dynamic file name if necessary.
      • The Custom Name field changes to a drop-down list where you can select the dynamic file name.
   4. Type a custom name.
   5. Click the checkbox to optimize the image quality for better performance.
      • This will reduce the image quality to 80% of the original and will therefore reduce the file size.

Edit

1. Click the Edit option.
   1. Use the toggle switch to enable the Edit functionality.
   2. Click the checkbox to optimize the image quality for better performance.
      • This will reduce the image quality to 80% of the original and will therefore reduce the file size.
   3. Use the toggle switches to enable the Configure Actions options:
      • On Submit Action
      • On Close Action
      • Allow Print
      • Allow Download
      • Hide toolbar options
   4. Use the Gear icons to configure the actions:
      • On Submit Action
      • On Close Action
      • Hide toolbar options: Use the modal to hide the accessibility settings.
   5. If necessary, click the Add action option to configure another action you may need.

Push to Salesforce

1. Click the Push to Salesforce option.
   1. Use the toggle switch to enable the Push to Salesforce functionality.
   2. Use the drop-down list to select an output format:
      • xlsx
      • docx
      • pdf
        • Use the drop-down list to select the program to convert the document.
   3. Use the toggle switch to add a dynamic file name if necessary.
      • The Custom Name field changes to a drop-down list where you can select the dynamic file name.
   4. Type a custom name.
   5. Click the checkbox to optimize the image quality for better performance.
      • This will reduce the image quality to 80% of the original and will, therefore, reduce the file size.

6. Make sure that you configure the Salesforce Push.

Captions

1. Click on the captions option to change any of the captions.

Where Used

1. Click the Where Used option to view where the document generation is triggered.

2. Click the Apply button. The Word or Excel template is added.
3. Use the Edit icon to edit the template.
4. Use the Kebab icon to do one of the following:
   • Turn Off
   • Delete

Add the Document Generation to an action flow

1. Configure an On Click Action on an element.
2. Click the + icon to add a node.
3. Under User Interaction, select the Document Generation option and click the Next button.

4. Use the drop-down lists to select the following:
   • Template
   • Action
5. Click the Next button.
6. Add a tag if necessary and click the Insert button.

If you are interested, check out our Salesforce document generation article for a comparison of the 10 best tools in the market.