Microsoft Word activity

Display Name

Function:

Specifies the activity name that shows in your process.

Accepted Values:

One line of text that can have spaces.

Default Value:

None

Accepts Process Data Variables:

No

Example:

This is a common configuration field that is used in many examples. Refer to:

• Examples - Step-by-step use case examples, information about what types of examples are provided in the AgilePoint NX Product Documentation, and other resources where you can find more examples.

Description

Function:

Specifies an optional text description for your activity.

Accepted Values:

More than one line of text.

Default Value:

None

Accepts Process Data Variables:

No

Amazon S3

Function:

Specifies that Amazon S3 is the source location of your Microsoft Word template file.

To select your Microsoft Word template file in the source location, complete the fields on Microsoft Word > Source Repository > Amazon S3.

Box

Function:

Specifies that Box is the source location of your Microsoft Word template file

To select your Microsoft Word template file in the source location, complete the fields on Microsoft Word > Source Repository > Box.

Dropbox

Function:

Specifies that Dropbox is the source location of your Microsoft Word template file

To select your Microsoft Word template file in the source location, complete the fields on Microsoft Word > Source Repository > Dropbox.

File System

Function:

Specifies that the file system on the AgilePoint Server machine the source location of your Microsoft Word template file

To select your Microsoft Word template file in the source location, complete the fields on Microsoft Word > Source Repository > File System.

FTP

Function:

Specifies that FTP is the source location of your Microsoft Word template file

To select your Microsoft Word template file in the source location, complete the fields on Microsoft Word > Source Repository > FTP.

Google Drive

Function:

Specifies that Google Drive is the source location of your Microsoft Word template file

To select your Microsoft Word template file in the source location, complete the fields on Microsoft Word > Source Repository > Google Drive.

Example:

Refer to:

• (Example) Create a Word Document and PDF File with Data from an App

NetSuite

Function:

Specifies that NetSuite is the source location of your Microsoft Word template file

To select your Microsoft Word template file in the source location, complete the fields on Microsoft Word > Source Repository > NetSuite.

OneDrive

Function:

Specifies that OneDrive is the source location of your Microsoft Word template file

To select your Microsoft Word template file in the source location, complete the fields on Microsoft Word > Source Repository > OneDrive.

OneDrive for Business

Function:

Specifies that OneDrive for Business is the source location of your Microsoft Word template file

To select your Microsoft Word template file in the source location, complete the fields on Microsoft Word > Source Repository > OneDrive for Business.

Salesforce

Function:

Specifies that Salesforce is the source location of your Microsoft Word template file

To select your Microsoft Word template file in the source location, complete the fields on Microsoft Word > Source Repository > Salesforce.

SFTP

Function:

Specifies that SFTP is the source location of your Microsoft Word template file

To select your Microsoft Word template file in the source location, complete the fields on Microsoft Word > Source Repository > SFTP.

SharePoint

Function:

Specifies that SharePoint is the source location of your Microsoft Word template file

To select your Microsoft Word template file in the source location, complete the fields on Microsoft Word > Source Repository > SharePoint.

Amazon S3

Function:

Specifies that Amazon S3 is the target location for your output Microsoft Word file or PDF file.

To configure the target location for your output Microsoft Word file, complete the fields in Microsoft Word > Target Repository > Amazon S3.

Box

Function:

Specifies that Box is the target location for your output Microsoft Word file or PDF file.

To configure the target location for your output Microsoft Word file, complete the fields in Microsoft Word > Target Repository > Box.

Dropbox

Function:

Specifies that Dropbox is the target location for your output Microsoft Word file or PDF file.

To configure the target location for your output Microsoft Word file, complete the fields in Microsoft Word > Target Repository > Dropbox.

File System

Function:

Specifies that the file system on the AgilePoint Server machine is the target location for your output Microsoft Word file or PDF file.

To configure the target location for your output Microsoft Word file, complete the fields in Microsoft Word > Target Repository > File System.

FTP

Function:

Specifies that FTP is the target location for your output Microsoft Word file or PDF file.

To configure the target location for your output Microsoft Word file, complete the fields in Microsoft Word > Target Repository > FTP.

Google Drive

Function:

Specifies that Google Drive is the target location for your output Microsoft Word file or PDF file.

To configure the target location for your output Microsoft Word file, complete the fields in Microsoft Word > Target Repository > Google Drive.

Example:

Refer to:

• (Example) Create a Word Document and PDF File with Data from an App

NetSuite

Function:

Specifies that NetSuite is the target location for your output Microsoft Word file or PDF file.

To configure the target location for your output Microsoft Word file, complete the fields in Microsoft Word > Target Repository > NetSuite.

OneDrive

Function:

Specifies that OneDrive is the target location for your output Microsoft Word file or PDF file.

To configure the target location for your output Microsoft Word file, complete the fields in Microsoft Word > Target Repository > OneDrive.

OneDrive for Business

Function:

Specifies that OneDrive for Business is the target location for your output Microsoft Word file or PDF file.

To configure the target location for your output Microsoft Word file, complete the fields in Microsoft Word > Target Repository > OneDrive for Business.

Salesforce

Function:

Specifies that Salesforce is the target location for your output Microsoft Word file or PDF file.

To configure the target location for your output Microsoft Word file, complete the fields in Microsoft Word > Target Repository > Salesforce.

SFTP

Function:

Specifies that SFTP is the target location for your output Microsoft Word file or PDF file.

To configure the target location for your output Microsoft Word file, complete the fields in Microsoft Word > Target Repository > SFTP.

SharePoint

Function:

Specifies that SharePoint is the target location for your output Microsoft Word file or PDF file.

To configure the target location for your output Microsoft Word file, complete the fields in Microsoft Word > Target Repository > SharePoint.

Word Template Name

Function:

Specifies the name of the Microsoft Word template file your process uses when it runs.

Accepted Values:

• A valid Word template file name.
• A process data variable.

  You can use Process Data screen to specify a process data variable.

Default Value:

None

Accepts Process Data Variables:

Yes

Example:

Refer to:

• The videos on this page

Destination File Name

Function:

Specifies the file name of the output file.

Accepted Values:

• One line of text that can have spaces.
• A process data variable.

  You can use Process Data screen to specify a process data variable.

Default Value:

None

Accepts Process Data Variables:

Yes

Example:

Refer to:

• The videos on this page
• (Example) Create a Word Document and PDF File with Data from an App

Save as PDF

Function:

Specifies that the generated file will be saved as a PDF file, and not a Microsoft Word document.

Accepted Values:

• Deselected - The output file is saved as a Word document.
• Selected - The output file is saved as a PDF document.

Default Value:

Deselected

Example:

Refer to:

• The videos on this page
• (Example) Create a Word Document and PDF File with Data from an App

Display Literal Boolean Value

Function:

Determines whether the generated Word document displays the literal value of a Boolean field — for example, display the words Yes or No for a boolean field.

By default, the Word activity displays the Boolean values as a selection box — X for True, and empty for False.

Accepted Values:

• Deselected - Displays the Boolean values as a selection box.
• Selected - Displays the literal value of a Boolean field.

Default Value:

Deselected

Sort Configuration

Opens this Screen:

Sort Configuration screen.

To Open this Field:

1. On the Microsoft Word Configuration screen, configure a repeatable word field on the Basic Mapping tab or the Advanced Mapping tab.

Function of this Screen:

Specifies a repeatable word field to sort the data in ascending or descending order in the Microsoft Word document or PDF document, generated as output.

Example:

Refer to:

• (Example) Create a Word Document and PDF File with Data from an App

Click to Load Word Fields

Function:

Moves the dynamic fields specified with the Microsoft Word template to the Word Fields box.

To Open this Field:

1. On the Microsoft Word Configuration screen, select Basic Mapping.

Example:

Refer to:

• (Example) Create a Word Document and PDF File with Data from an App

Move All

Function:

Moves all the fields in the Word Fields box at one time.

To Open this Field:

1. On the Microsoft Word Configuration screen, select Basic Mapping.

Word Field

Function:

Specifies the word field that is to be mapped to the process value. The mapping is performed to update the fields in the Microsoft Word document or PDF document, generated as output.

To Open this Field:

1. On the Microsoft Word Configuration screen, select Basic Mapping.

Accepted Values:

The list of Word fields to use in your target document.

You can drag fields one by one the Load Word Fields box to the Word Field box, or click Move All to move all the fields.

Default Value:

None

Example:

Refer to:

• The videos on this page
• (Example) Create a Word Document and PDF File with Data from an App

Process Value

Function:

Specifies the process value to be mapped to the Microsoft Word field to update each field in the Word document.

To Open this Field:

1. On the Microsoft Word Configuration screen, select Basic Mapping.

Accepted Values:

• A number or a text string that can contain spaces.

  This must be in accordance with the data type of the word field.

• A process data variable

Note:

• Once a Word field is in the Word Field column, to map a Word field to a process value, select the row, and use Process Data screen.

Default Value:

None

Example:

Refer to:

• The videos on this page
• (Example) Create a Word Document and PDF File with Data from an App

Map Word Fields

Function:

Connects the AgilePoint process schema to the Microsoft Word field.

To Open this Field:

1. On the Microsoft Word Configuration screen, select Advanced Mapping.

Accepted Values:

Click the Schema Mapping button to open the Schema Mapper.

Use this screen to connect the response to the data model for your process.

Default Value:

None

Example:

Refer to:

• (Example) Schema Mapper
• (Example) Create a Word Document and PDF File with Data from an App

Repeatable Word Fields

Function:

Shows the repeatable Microsoft Word fields specified on the Basic Mapping or Advanced Mapping tab on the Microsoft Word Configuration screen.

Accepted Values:

Read only - A repeatable Microsoft Word field.

Example:

Refer to:

• (Example) Create a Word Document and PDF File with Data from an App

Word Field

Function:

Specifies the word field to sort in the Microsoft Word document or PDF document, generated as output.

Accepted Values:

The repeating fields from the Repeatable Word Fields box.

You can drag only 1 field from the Repeatable Word Fields box to sort the rows of a table. If the Word document has 2 or more tables with repeating rows, you can drag a field from each table to sort the field.

Default Value:

None

Example:

Refer to:

• (Example) Create a Word Document and PDF File with Data from an App

Sort by

Function:

Specifies whether to sort the fields in ascending or descending order.

Accepted Values:

• Ascending - Sorts the fields in ascending order.
• Descending - Sorts the fields in descending order.

You can sort based on 1 field from each table. If the Word document has 2 or more tables with the repeating rows, you can sort a field from each table. Tables are identified by TableStart and TableEnd mail merge fields in Word.

Default Value:

Ascending.

Example:

Refer to:

• (Example) Create a Word Document and PDF File with Data from an App