FAQ How do I set the merge fields?
Set the merge field in the template file in the following format. For the merge fields of the child object, enter only o...
FAQ Merge Field How do I output the reference object field?
Cross-Object Formulas that display referenced object fields are available as merge fields. If the user does not have per...
Merge Field How do I set a merge field to the file name?
The merge field can be set to the output file name. Set the "Output File Name" field in the OFC_Template record. e.g. In...
Merge Field Can merge fields be set in the header and footer in Excel/Word?
Merge fields of the master object can be used in the header and footer. Child object fields cannot be used.
Merge Field How do I format a Date field? e.g., Mar. 1, 2024
Formatting can be set for merge fields whose data type is Date or Date/Time. The formatting is set by separating the fie...
Merge Field How do I output the currency symbol?
Formatting can be set for merge fields whose data type is Currency or Number. Available in Ver. 2.0 or later.e.g. {!Case...
Merge Field How do I round a number to a specified number of decimal places?
Formatting can be set for merge fields whose data type is Currency or Number. Available in Ver. 2.0 or later.e.g. {!Case...
Merge Field How do I display negative numbers with parentheses? e.g. (1,000)
Formatting can be set for merge fields whose data type is Currency or Number. Available in Ver. 2.0 or later.Merge Field...
Merge Field How do I output Rich Text Area fields with formatting?
Rich Text Area field values are output with HTML-tagged values stored in Salesforce. The output cannot be formatted as i...
Merge Field How do I set a formula to merge fields?
Formulas such as {!If(xxxxx)} cannot be used for merge fields. Create a formula field in Salesforce and set the formula ...
Merge Field How do I output field B or a fixed value if field A is blank?
It is not possible to set conditional branching logic for merge fields, such as "If field A is blank, output field B or ...
Merge Field How do I change the checkbox field value?
The True/False values of checkbox fields can be replaced with other values.e.g. {!Opportunity.IsDelivery__c, Yes;No}Inst...
Merge Field How do I output today's date and current time?
Today's date and current time can be output. Use the Today() and Now() functions for merge fields. Available in Ver. 2.0...