Apsona Conditional Template configuration supports template selection using a single Condition Field. If the requirement involves evaluating multiple fields, such as Appeal and GL Code, with one field taking precedence over the other, create a Calculated Field in the report to combine the required business logic.
For example, the calculated field can first evaluate the Appeal value and return EXHIBITION_SUPPORT if it matches the specified value. If it does not match, the calculation can evaluate the GL Code and return the corresponding template identifier, such as CAPITAL_CAMPAIGN, UNRESTRICTED_GIFT, BOARD_GIFT, GALA_SPONSORSHIP, or GALA_TICKET_PURCHASE. If none of the conditions match, it can return MANUAL_REVIEW.
Once configured, use this calculated field as the Condition Field in the Merge Action's Conditional Template settings and map each returned value to its corresponding Word template.
This approach allows a single Merge Action to evaluate multiple field values, apply precedence rules, and automatically select the appropriate template for each record.