Output Child Records in Separate Tables for Each Filter Criteria

Output child records of the same object in separate tables for each filter criteria.

*This feature is available in Office File Creator Pro.

Overview

Examples of Use

Output different layouts for open and closed statuses for cases related to the Account record.

Required settings

Determine the child relationship name used to link the merge fields to the OFC_Child Object Option record.

Naming Rules for Child Relation Name

Only alphanumeric characters and underscores are allowed, beginning with the Roman alphabet.

Examples of child relationship names

Cases_Open

Cases_Closed

Set the merge field in the template file in the form of {!ChildRelationName.Field API Name}.

Example: Output child record cases in two tables

Table 1: {!Cases_Open.CaseNumber}

Table 2: {!Cases_Closed.CaseNumber}

Create OFC_Child Object option records for the number of tables to be separated by the filter criteria.

Name: Enter any name. e.g. Case (Open)

Child Relationship Name:　Enter the child relationship name. e.g. Cases_Open

FilterCriteria Field API Name: Enter the field API name for filtering child records. e.g. ClosedDate

FilterCriteria Operator: Select the operator for filtering child records.

FilterCriteria Value: Enter the value for filtering child records.

Object API Name: Enter the object API name of the child object. *Not a child relationship name.

Master Object Id Field API Name: Enter the cross-object formula that references the master object Id.

Refer to the following for cross-object formulas.