Replacement Fields

Field replacement allows you to select fields from an associated dataform within the workspace from which the task is triggered. Field replacement is available when configuring Email Templates and Workflow Channels. For example, when configuring an Email Template for employee termination, you can select fields for employee-related information such as email, state, city, and SSN. The replacement fields help to customize your message.

  • For Email Template configuration, replacement fields are available from the link See Replace Fields.
  • For Workflow Channel configuration, replacement fields are available from the link Get Replace Fields.

You can use replacement fields for Workflow Channel configuration and Email Templates.

Field replacement includes

  • Any active fields on the triggering dataform

  • The active fields from any additional condition source dataform

  • Task fields when you select Task as the Triggering Form on an Email Template

  • The active fields from the tabbed forms related to the triggering form

  • The active fields from the related Organization and Org Other Info

  • Any fields returned by the Server Data Procs related to the triggering dataform

  • Any field from the most recent parent dataform, even when tasks are multiple levels deep. See Ancestor fields.

To use replacement fields:

  1. For Email Templates, in the Content step, click See Replace Fields. For Workflow Channels, in the Content step, click Get Replace Fields.
    The Replace Fields dialog box opens, displaying fields grouped by source section and expanded.
  2. Collapse the source sections to view the count.


  1. To search for fields, in the Filter by name box, start typing your keyword. As you type, the matching fields display. For example, type name and all entries with name are displayed.

  1. Select as many fields as applicable and then click Copy.
    The Clipboard dialog box opens with the selected fields.


  1. Click Ok.
  2. On the Email Template or Workflow Channel, click in the field (Subject, Body, or Text Area) where you want to insert the replacement fields.
  3. Paste the copied fields (Ctrl+V).
  4. You can move the fields around as appropriate (copy and paste). You can invoke the Replace Fields dialog as often as necessary to paste your required fields.
  5. Click Apply.

Alternate values

The following fields provide alternate values.

Field Value

Contact

TableName.FieldName.FirstName (blank if empty) example Client Master.PrimaryContact.FirstName
TableName.FieldName.LastName
TableName.FieldName returns LastName, FirstName

Users

TableName.FieldName.FirstName example ClientMaster.SalesRep.FirstName
TableName.FieldName.LastName
TableName.FieldName returns LastName, FirstName

Text area

TableName.FieldName returns the first 250 characters (appends "..." if the field contains more than 250 characters)
TableName.FieldName.All returns entire field
TableName.FieldName.<integer> returns first ## number of characters (replace <integer> with the numeric character count). If the field contains more than <integer> number of characters, it appends "..." For example, Clientmaster.DescriptionOfOps.7 returns the first 7 characters from this field. If the field contains more than 7 characters, these will end with ... indicating more info is available.

Lookup

TableName.FieldName returns Decode value displayed in the application
TableName.FieldName.Code returns Code value stored in the field

Integer

TableName.FieldName returns comma formatted value (##,###)

Decimal or Money

TableName.FieldName returns comma formatted value (##,###.##) or 0.00 if blank

Ancestor fields

The following image illustrates pulling ancestor fields as replacement fields into the Body field. The fields are from the nearest dataform ancestor.

Example: 2379 gen_Employee.FirstName

  • The Workflow item is 2379

  • The form is gen_Employee

  • The field is FirstName