Custom Word Reporting

  • Updated
  • ~ minute read

What is a custom Word template?

A custom Word template is a dynamic reporting option that allows you to export your captured form data and push it to a Word template of your own design. 
 

Can I download a starting template?

Yes, you can! To download a starting template (which will contain all of the fieldkeys from your form):
  1. Click on the Reporting button in the Form Builder.
  2. Click on the Custom tab.
  3. Select Generate and Download to generate a Word report which you can then edit, stylize, and re-upload.  

2017-02-23_1156.png

Adding Fields

Adding fields to your custom Word template is simple. All you need to do is get your field's fieldkey and put it in your custom Word template surrounded by $ signs.
In the example below, we have Inspector Name, Inspector Phone Number and Client Name in the custom Word template. When the form is submitted, data from the form will replace the fieldkeys.

2017-02-06_1807.png

After saving the Word document, upload it to the Custom tab in the Reporting menu, and then save and publish the form. Here is what the Word report looks like after submitting:

2017-02-06_1809.png

Stylizing

It is important to note that fonts, colors, font sizes, etc. will be mimicked in your reports. If you put your $fieldkey$ as Helvetica with a blue color, it will mimic those on the report. However, it cannot use custom fonts. It is limited to generic Word fonts.
 

Repeating Sections

To create Repeating Sections:
  1. Add a table. You will only need to create the first row.
  2. Right-click on the table and select Table Properties.
  3. In the Alt Text tab, put the fieldkey of the section that is repeating as the Title and Save.
  4. Then for each cell, put the fieldkey in the field that you want to add, surrounded by $ signs.
    • If you would like to create a header row that does not repeat, please see the Header Rows section in this article).
    • Repeating sections do not require a prefix.

rep_section_1.png

rep_section_2.png

 

Subforms

For subforms, you will need to use a table. It is set up the exact same as a repeating section, except that your fieldkeys in the cell will need a prefix. Once you have added the table:
  1. Right-click on your table and select Table Properties.
  2. In the Alt Text tab, enter the fieldkey of your subform field under Title and Save.
  3. Enter your subform fieldkey as the prefix.
    • For example, if your subform fieldkey is subform_1 and your field fieldkey is date_2 you would put this in the cell $subform_1_date_2$
    • Notice the subform fieldkey is the prefix and it is separating the fieldkey by an underscore.
    • If you would like to create a header row that does not repeat, please see the Header Rows section in this article.

subform_2.png

subform_1.png

 

Subform Columns

If you want to use a column format for your subforms, you can do that by setting it up like the picture below. We recommend using the first row as a blank space so there is some separation between the instances.

2017-02-06_1739.png

This is what it looks like on the report with 2 subform instances:

2017-02-06_1746.png

 

Header Rows

If you want to have a header row in the same table as your data, you can do this by specifying header_row in the description of the table properties.

image__6_.png

After uploading and saving this to your form you will now be able to submit a form with a header row that does not repeat in the table. This will give you a fixed row with headers for each column in your table.

2017-03-24_1025.png

Photos and Signatures

For photos and signatures, use a one-celled table. All photos will be put inside that cell. If you want multiple photos per row, make sure you specify the amount in the advanced report settings for that multi-photo field.
Advanced Report Setting
In the example below, we set it to 4 photos per row:

2017-02-06_1750.png

Custom Word Template
In the example below, we have a single-celled table with the fieldkey surrounded by $ signs:

multiphoto_1.png

Word report output: (Screenshot below)

2017-02-06_1800.png

Dynamic Checkboxes

When creating a custom Word report, you have the capability to include dynamic checkboxes that correspond with items checked off from a user's submitted form. For example, if a user checks off items from a list on a form from the App, your report can also show that same list with checkboxes marked accordingly.
To learn how to use dynamic checkboxes in your reports, please see our in-depth dynamic checkboxes guide, which will walk you through each step.
 
If you have any questions or issues, please feel free to reach out to our support team at fastfieldsupport@mergemobile.com

 

Related articles