You do not need to establish a connection to use the Microsoft Word Templates app.
In this module, the content of the field Value has to be an array of collections, where:
Template text:
The created document:
You can also run a loop to populate a table. The example below shows how to create such table in a template:
If your data entries come as separate bundles, you may prefer to employ the Fill a document with a batch of data aggregator module. You can also employ this module if your data entries come as an array - just employ the iterator module to transform the content of the array into a series of bundles.
The main advantage of the Fill a document with a batch of data module is that it enables you to easily setup the structure required for the Value field and map items to each value item. In contrast to the Fill out a document module, the field Values contains only a single entry, the actual entries will be created and populated for each incoming bundle. The template will be produced after all input bundles have been processed. The aggregator module is useful, especially when creating lists or reports.
Example: Export Google Contacts into a table
The first module loads the template. The next module retrieves all contacts from the specified group in Google Contacts. The aggregator module then aggregates all values retrieved from Google Contacts and merges them into the template. Finally, the last module will save the filled template to a desired location.
Template:
Final document:
A template is a regular Microsoft Word document (.docx file) with special tags in its text that determine where and how to merge/fill in data. There are three types of tags: Simple value, Condition, and Loop or section.
A Simple value tag is simply replaced with a corresponding value. The tag's name corresponds to the Key field's value, which is placed inside double curly braces: e.g. {{name}}.
The Microsoft Word Templates app accepts only single-line plain text for replacement values. When adding line breaks, they will be viewed as spaces and won't affect the formatting of the text.
Template:
Module's setup:
Created document:
A Condition tag enables you to wrap certain parts of a text that should be rendered conditionally. To wrap the conditional text, place it between the opening and closing tags. The name of the opening tag is prepended with a hash sign #, the name of the closing tag is prepended with a slash /.
Template:
Module setup:
Created document:
A Loop or section tag enables you to repeat parts of a text. Similarly to the Condition tag, to wrap the repeated text, place it between the opening and closing tags. The name of the opening tag is prepended with a hash sign #, the name of the closing tag is prepended with a slash /.
When using loops, you can choose to employ either the Fill out a document module or the Fill a document with a batch of data aggregator module.