蜜豆视频

Microsoft Word Template modules

In an 蜜豆视频 Workfront Fusion scenario, you can automate workflows that use Microsoft Word Templates, as well as connect it to multiple third-party applications and services.

For instructions on creating a scenario, see the articles under Create scenarios: article index.

For information about modules, see the articles under Modules: article index.

Access requirements

Expand to view access requirements for the functionality in this article.

You must have the following access to use the functionality in this article:

table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header
蜜豆视频 Workfront package Any
蜜豆视频 Workfront license

New: Standard

Or

Current: Work or higher

蜜豆视频 Workfront Fusion license**

Current: No Workfront Fusion license requirement.

Or

Legacy: Workfront Fusion for Work Automation and Integration

Product

New:

  • Select or Prime Workfront package: Your organization must purchase 蜜豆视频 Workfront Fusion.
  • Ultimate Workfront package: Workfront Fusion is included.

Or

Current: Your organization must purchase 蜜豆视频 Workfront Fusion.

For more detail about the information in this table, see Access requirements in documentation.

For information on 蜜豆视频 Workfront Fusion licenses, see 蜜豆视频 Workfront Fusion licenses.

Prerequisites

In order to use Miscrosoft Word Templates with 蜜豆视频 Workfront Fusion, it is necessary to have an Office 365 account. You can create one at www.office.com.

Connecting the Office service to Workfront Fusion

For instructions about connecting your Office account to Workfront Fusion, see Create a connection to 蜜豆视频 Workfront Fusion - Basic instructions

NOTE
Some Microsoft apps use the same connection, which is tied to individual user permissions. Therefore, when creating a connection, the permissions consent screen displays any permissions that were previously granted to this user鈥檚 connection, in addition to any new permissions needed for the current application.
For example, if a user has 鈥淩ead table鈥 permissions granted via the Excel connector and then creates a connection in the Outlook connector to read emails, the permissions consent screen will show both the already granted 鈥淩ead table鈥 permission and the newly required 鈥淲rite email鈥 permission.

Using Microsoft Word Templates modules

You can use a Microsoft Word Template module to merge data from multiple web services into a Microsoft Word document.

For example, you could use this Microsoft Word template:

Word template before

To create this document:

Word template filled

About value tags

A Microsoft Word template is a regular Microsoft Word document (.docx file) with special tags in its text that determine where and how to merge or fill in data. There are three types of tags:

Simple value tag simple-value-tag

A simple value tag is simply replaced with a corresponding value. The tag鈥檚 name corresponds with the Key field鈥檚 value, which is placed inside double curly braces; for example, {{name}}.

Example: To create a document that says 鈥淗i, Petr!鈥, you could use a Microsoft Word Template module to create the following template:

> Hi {{name}}!

To do this, you would set up the module as follows:

Word template simple value

Condition tag condition-tag

You can use a condition tag to wrap text that should be rendered only when certain conditions are met. To wrap the text, place it between opening and closing condition tags, such as 鈥渉asPhone鈥 if the condition is whether or not the data includes a phone number. The name of an opening tag is prepended with a hash sign #, the name of a closing tag is prepended with a slash /, as shown in the example below.

Example: To produce a document that includes a customer鈥檚 phone number if the input data includes a phone number, but no email address, you could use a Microsoft Word Template module and create the following template:

> {{#hasPhone}}Phone: {{phone}} {{/hasPhone}}
> {{#hasEmail}}Email: {{email}} {{/hasEmail}}

To do this, you would set up the module as follows:

Word template conditional

In the document, the phone number would appear as follows:

> Phone: 4445551234

Loop tag loop-tag

You can use a loop tag, also known as a section tag, to repeat a section of text. Wrap the text by placing it between the opening and closing loop tags. The name of an opening tag is prepended with a hash sign #; the name of a closing tag is prepended with a slash /.

Example: To produce a document that lists the name and phone number of each contact in a customer list, you could use a Microsoft Word Template module and create the following template:

> {{#contact}}
>     {{name}}, {{phone}}
> {{/contact}}

To do this, you would set up the module as follows:

Fill out a document

The module would create the following document:

> Jan Toman, 4445551234
> Eduard Salo, 4445552345

Microsoft Word Template modules

These modules do not require a connection.

Fill out a document fill-out-a-document

This transformer module lets you fill a document with data you specify. It can be used with simple values tags, conditional tags, or loop tags.

Start delimiter of the text being replaced

Enter the character(s) that you want to mark the beginning of the text being replaced.

Example: Enter [[ to replace [[replace_me]].

End delimiter of the text being replaced

Enter the character(s) that you want to mark the end of the text being replaced.

Example: Enter ]] to replace [[replace_me]]

.

Source file
Select a source file from a previous module, or map the source file's data.
Name of filled out file
Enter a file name (including extension) for the target output file.
Data source
Select an option to indicate whether the data you're using is from a form or from a raw data collection (unprocessed computer data).
Values

This must be an array of collections, where:

  • Each collection corresponds to one data entry and contains one item entry
  • Item entry contains a collection of the key and value
  • Item key contains the tag's name
  • item value contains the tag's value

To add an entry:

  1. Click Add Item.

  2. Select the value type of the entry.

  3. Add the name and value. For more information, see the example for the chosen value type in this article.

Fill a document with a batch of data fill-a-document-with-a-batch-of-data

This aggregator module is useful if your data entries come as separate bundles. With this module, you can easily set up the structure required for the Value field and it map items to each value item. In contrast to the Fill out a document module, the Values field in the Fill a document with a batch of data module allows only a single entry containing variables.

You can also use this module also if your data entries come as an array, by using the Iterator module to transform the content of the array to a series of bundles.

The actual values are created and populated for each incoming bundle. The template is produced after all input bundles are processed.

This aggregator module is especially useful for creating lists or reports.

Source Module
Select the module that is the source of your text.
Start delimiter of the text being replaced

Enter the character(s) that you want to mark the beginning of the text being replaced.

Example: Enter [[ to replace [[replace_me]].

End delimiter of the text being replaced

Enter the character(s) that you want to mark the end of the text being replaced.

Example: Enter ]] to replace [[replace_me]].

Group by
Define an expression containing one or more mapped items. The aggregated data is separated under Groups with the same expression's value. Each Group outputs as a separate bundle containing a Key with the evaluated expression and the aggregated text. By doing this, you can use the Key as a filter in subsequent modules.
Stop processing after an empty aggregation
Enable this option to stop processing when an aggregation contains no bundles.
Source file
Select a source file from a previous module, or map the source file's data.
Name of filled out file
Enter a file name (including extension) for the target output file.
Values

This must be an array of collections, where:

  • Each collection corresponds to one data entry and contains one item entry
  • Item entry contains a collection of the key and value
  • Item key contains the tag's name
  • item value contains the tag's value

To add an entry:

  1. Click Add Item.

  2. Select the value type of the entry.

  3. Add the name and value. For more information, see the example for the chosen value type in this article.

recommendation-more-help
7e1891ad-4d59-4355-88ab-a2e62ed7d1a3