Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Any active fields on the triggering dataform

  • The active fields from any additional condition source dataform
  • 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.

The following image is an example of the Replace Fields dialog.

...

FieldValue
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 will append "..." For example Clientmaster.DescriptionOfOps.7 will return 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


Anchor
Ancestor
Ancestor
Ancestor fields

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

...