How to: Format custom email templates

Email templates can be found and edited in the workflow. There are many useful variables available within the emails templates and functions to format them.


Variables able to be easily accessed by their references

%(LoggedInUsersEmailAddress)% - Can be used to reference the Email address of the User.

%(LoggedInUsersID)% - Can be used to reference the ID of the User.

%(LoggedInUsersFirstName)% - Can be used to reference the First Name of the User.

%(LoggedInUsersLastName)% - Can be used to reference the Last Name of the User.

%(ConfigTimeZoneAbbr)% - Can be used to reference the Time Zone Abbreviation.

%(ConfigTimeZone)% - Can be used to reference the Time Zone.

%(SiteURL)% - Can be used to reference the Tenancy Site URL.

%(SiteTitle)% - Can be used to reference the Tenancy Site Title.

%(SiteHeader)% - Can be used to reference the Tenancy Site Heading.

%(SiteID)% - Can be used to reference the Tenancy Site ID.

%(ModuleName)% - Can be used to reference the Module Name.

%(ModuleID)% - Can be used to reference the Module ID.

%(LastChargeAmount)% - Can be used to reference the Charged Amount in the most recent purchase.

%(LastChargeCCType)% - Can be used to reference the Credit Card Type in the most recent purchase.

%(LastChargeCCLast4)% - Can be used to reference the Credit Card Last 4 Digits in the most recent purchase.

%(DirectLinkToRequest)% - Can be used to reference a link to the request

    For additional information about direct links visit: How to: Direct external links to module, views, or requests


Variables related to Tenancies organization information.

%(OrganizationName)% - Can be used to reference the Organization Name.

%(OrganizationEmail​)% - Can be used to reference the Organization Email.

%(OrganizationPhone​)% - Can be used to reference the Organization Phone​.

%(OrganizationWebsite​)% - Can be used to reference the Organization Website​.

%(OrganizationAddress​)% - Can be used to reference the Organization Address.

%(OrganizationCity​)% - Can be used to reference the Organization City.

%(OrganizationRegion​)% - Can be used to reference the Organization Region​.

%(OrganizationZipCode​)% - Can be used to reference the Organization Zip-code.

%(OrganizationCountry)% - Can be used to reference the Organization Country.


Formatting for variables 

%(<VariableHere>:UrlEncode)% - 

Can be used to format a variable for use within a URL, for example this replaces spaces which are not valid in a URL with the proper "%20" value.


%(<DateTimeHere>:ToLocalTimeZone:Format"{0:MM/dd/yyyy}")% - 

This formatting suffix is used to decide which portions of the DateTime value are displayed and in what order. 

Example - ("MM/dd/yyyy hh:mm tt") = 05/29/2018 03:59 AM

CharacterFormatting Functionality
dRepresents the day of the month as a number from 1 through 31. 
ddRepresents the day of the month as a number from 01 through 31. 
dddRepresents the abbreviated name of the day. (Mon, Tues, Wed etc).
ddddRepresents the full name of the day. (Monday, Tuesday etc).
h12-hour clock hour. (e.g. 4).
hh12-hour clock, with a leading 0. (e.g. 06)
H24-hour clock hour. (e.g. 15)
HH24-hour clock hour, with a leading 0. (e.g. 22)
mMinutes.
mmMinutes with a leading zero.
MMonth number. (eg.3)
MMMonth number with leading zero. (eg.04)
MMMAbbreviated Month Name. (e.g. Dec)
MMMM

Full month name. (e.g. December)

sSeconds.
ssSeconds with leading zero.
tAbbreviated AM / PM. (e.g. A or P)
ttAM / PM. (e.g. AM or PM)
KRepresents the time zone information of a date and time value. (e.g. +05:00)


yYear, no leading zero. (e.g. 2015 would be 15)
yyYear, leading zero. (e.g. 2015 would be 015)
yyyYear. (e.g. 2015)
yyyyYear. (e.g. 2015)
zRepresents the signed offset of the local operating system's time zone from.
zzAs z, but with leading zero. (e.g. +06)
zzzWith DateTime values, represents the signed offset of the local operating system's time zone from UTC,measured in hours and minutes. (e.g. +06:00)
fRepresents the most significant digit of the seconds fraction; that is, it represents the tenths of a second in a date and time value.
ffRepresents the two most significant digits of the seconds fraction in date and time.
fffRepresents the three most significant digits of the seconds fraction; that is, it represents the milliseconds in a date and time value.
ffffRepresents the four most significant digits of the seconds fraction; that is, it represents the ten thousandths of a second in a date and time value. 
fffffRepresents the five most significant digits of the seconds fraction; that is, it represents the hundred thousandths of a second in a date and time value. 
ffffffRepresents the six most significant digits of the seconds fraction; that is, it represents the millionths of a Second in a date and time value.
fffffffRepresents the seven most significant digits of the seconds fraction; that is, it represents the ten millionths of a second in a date and time value.