Conga Product Documentation

Welcome to the new doc site. Some of your old bookmarks will no longer work. Please use the search bar to find your desired topic.

download

Format Merge Fields in a Conga Email Template

Similar to merge fields in Microsoft Word templates, merge fields in HTML email templates provide several formatting switches (called “picture switches”) that affect the appearance of your merged data – this is invaluable, particularly for numbers and dates. You can use the Template Builder to add these picture switches to your merge fields so the merged data is correctly formatted in your email. Alternately, you can manually add a picture switch to your field by simply typing it into your merge field in the HTML email template.

To manually add a picture switch to a merge field:

  1. Click after the merge field name, but inside the double curly braces.
  2. Type a space and picture switch.

Example: {{ACCOUNT_CREATEDDATE \@ MM/dd/yy}}

You can format the following types of fields:

Date Fields

Parameter

Description

Month (M)

Displays the month.

M

Displays the month as a number without a leading zero for single-digit months.

February is shown as 2.

MM

Displays the month as a number with a leading zero for single-digit months.

February is shown as 02.

MMM

Displays the month as a three-letter abbreviation.

February is shown as Feb.

MMMM

Displays the full name of the month.

February.

The letter M must be uppercase to distinguish months from minutes.

Day (d)

Displays the day of the month or the day of the week.

d

Displays the day of the week or month as a number without a leading zero for single-digit days.

The sixth day of the month is shown as 6.

dd

Displays the day of the week or month as a number with a leading zero for single-digit days.

The sixth day of the month is shown as 06.

ddd

Displays the day of the week or month as a three-letter abbreviation.

Tuesday is shown as Tue.

dddd

Displays the full name of the day of the week.

Tuesday.

The letter d can be either uppercase or lowercase.

Year (y)

Displays the year as two or four digits.

yy

Displays the year as two digits with a leading zero for years 01 through 09.

1999 is shown as 99; 2006 is displayed as 06.

yyyy

Displays the year as four digits.

1999 or 2006

The letter y can be either uppercase or lowercase.

Hours (h)

A lowercase h bases time on the 12-hour clock.

An uppercase H bases time on the 24-hour clock.

h

Displays the hour without a leading zero for single-digit hours.

9 A.M. is shown as 9.

H

Displays hours without a leading zero for single-digit hours on the 24-hour clock.

9AM is shown as 9. 9PM is shown as 21.

hh

Displays the hour with a leading zero for single-digit hours.

9 PM. is shown as 09.

HH

Displays the hour with a leading zero for single-digit hours on the 24-hour clock.

9 AM. is shown as 09. 9 PM is shown as 21.

Minutes (m)

Displays minutes.

m

Displays minutes without a leading zero for single-digit minutes.

{{TIME \@ "m"}} is shown as 2.

mm

Displays minutes with a leading zero for single-digit minutes.

{{TIME \@ "mm"}} is shown as 02.

The letter m must be lowercase to distinguish minutes from months.

A.M. and P.M. (AM/PM)

am/pm

Displays A.M. and P.M.

AM/PM

Displays A.M. and P.M. as uppercase.

{{NOW \@ "h AM/PM"}} and {{NOW \@ "h am/pm"}} are both shown as 9 AM.

Number Fields

When Conga Composer populates a numeric value, the digit grouping symbol (the “thousands separator”) is defined according to your Locale settings (as defined in Salesforce’s Setup > Personal Information) or according to the &Culture or &CurrencyCulture Conga Composer parameters.

Despite the cultural settings that govern the output from Conga Composer, within an appearance parameter you must use a comma (",") for the digit grouping symbol (for thousands) and a period (".") as the decimal symbol.

Parameter

Description

0 (zero)

Specifies the requisite numeric places to display in the result. If the result does not include a digit in that place, Word displays a 0 (zero).

{{Points \# 00.00}} appears as 09.00.

#

Specifies the requisite numeric places to display in the result. If the result does not include a digit in that place, nothing appears in that place.

{{Cost \# $### } appears as $15.

, (digit grouping symbol)

Separates a series of three digits.

The digit grouping symbol is always entered as a comma into the formatting code, regardless of the country’s cultural preference. Conga Composer will format the output according to the cultural preference.

{{= NetProfit \# $#,###,###}} appears as $2,456,800.

%, $, *, and so on

Includes the specified character in the result.

{{= NetProfit \# "##%"}} appears as 33%.

[positive value];[negative value]

Specifies different number formats for results with positive or negative values.

{{Sales95 \# "$#,##0.00;-$#,##0.00"}} Positive values appear as $1,245.65. Negative values appear as -$1,245.65.

Currency

Formats the value according to the Salesforce Locale, including a currency symbol, digit grouping symbol, and two decimal places

{{OPPORTUNITY_AMOUNT \# Currency}}

Currency0

Also available:

Currency1, 2, 3, 4

Formats the value according to the Salesforce Locale, including a currency symbol, digit grouping symbol, and zero decimal places (or 1 decimal place, 2 decimal places, 3, 4, or 5 if using Currency1, Currency2, Currency3, etc.)

{{OPPORTUNITY_AMOUNT \# Currency0}}

Number

Formats the value according to the Salesforce Locale, excluding a currency symbol, but including a digit grouping symbol, and two decimal places.

{{OPPORTUNITY_AMOUNT \# Number}}

Number0

Formats the value according to the Salesforce Locale, including a digit grouping symbol, but excluding two decimal places and a currency symbol.

{{OPPORTUNITY_AMOUNT \# Number0}}

Can also be used with SUM fields.

Percent

Formats the value according to the Salesforce Locale, by multiplying the value by 100 and including a digit grouping symbol, two decimal places, and a percent sign.

{{OPPORTUNITY_PROBABILITY \# Percent}}

Cannot be used with SUM fields.