Inserting data

To insert data from a record,,into an email, the following syntax is used. 

 {FIELDNAME} 

 Custom functions 

 A couple of functions are implemented, allowing minor modification of data from fields, before inserting it. 

 Syntax:  @[FUNCTION]({FIELDNAME} [PARAMETER]) 

 Function: FALLBACK 

 Sample:  @FALLBACK({NAME} Friend) 

 If the given field does not have a value, or is not found, the PARAMETER value will be used instead. 

 Function: DATEADD 

 Sample:  @DATEADD({DATE} 3 weeks) 

 If the given field is a Date, Time or DateTime field, the value is modified by the given amount (positive or negative) 

 Supports wrapping inside FORMAT (see below). 

 Supported periods: minute(s), hour(s), day(s), week(s), month(s), year(s) 

 Function: DATESUB 

 Sample:  @DATESUB({DATE} 3 weeks) 

 If the given field is a Date, Time or DateTime field, the value is modified by the given amount (positive or negative) 

 Supports wrapping inside FORMAT (see below). 

 Supported periods: minute(s), hour(s), day(s), week(s), month(s), year(s) 

 Function: FORMAT 

 Sample:  @FORMAT({NUMBER} 000.000)  or  @FORMAT({DATE} MMM, d YYYY) 

 Formats a given number or date to the specified format. 

 Number formatting uses  DecimalFormat  and date formatting uses  SimpleDateFormat . 

 It is possible to wrap this function around DATESUB and DATEADD like this:  @FORMAT(@DATEADD({DATE} 3 weeks) MMM, d YYYY)