WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

2020-07-25T02:30:49Z

Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"

2020-07-15T11:44:56Z

Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Bgrenon: Published

2020-06-08T14:36:21Z

Published

New page

{{Article
|Standalone=No
|DisplayName=Using Formulas in Field Codes
|TocName=Using Formulas in Field Codes
|Context=View formula usage in field codes.
|ComingSoon=No
|Platform=PureEngage
|Role=Administrator
|Application=Platform Administration
|Section={{Section
|alignment=Vertical
|structuredtext=In addition to system variables such as <tt>Contact.FirstName,</tt> field codes may contain formulas. This section provides an outline of formula usage. Details on many of these topics are provided in the [https://docs.genesys.com/Documentation:ES:FldCod:welcome:latest Genesys eServices Field Codes Reference Manual].

You must always delimit field codes by using <tt><$ … $>.</tt> If you type a field code directly into the body of a standard response, then you must enter the delimiters yourself. If you select from the list of field codes in eServices Manager, then the delimiters are added automatically. 

The text that appears inside the delimiters is a formula. Field code formulas are very similar to formulas in other applications, such as Microsoft Excel.

A ''formula'' is a sequence of one or more operands (such as numbers and text strings), separated by operators (such as <tt>+</tt> and <tt>-</tt>).

For example, in the following formula, <tt>2</tt> and <tt>3</tt> are operands and <tt>+</tt> is an operator:

:<tt><$2 + 3$></tt>
: 

Operands can be values that do not change (constants), or values that vary based on the context. In the previous formula, all the operands are constants, so the formula always evaluates to <tt>5.</tt> The next formula, on the other hand, evaluates to a different value for each agent who uses it:

:<tt><$Agent.Signature$></tt>
: 

===Field Code Syntax===
To summarize field code syntax:

*A field code must be delimited by <tt><$ ... $>.</tt>
*Alphabetic strings, whether constants in formulas or elsewhere in a field code, must be enclosed in double quotes.
*Numeric constants require no special treatment.
*You must use special characters for some purposes. For example, for your field code to render with a line break, you cannot simply type a carriage return. Instead, you must insert the expression <tt>\n.</tt> [https://docs.genesys.com/Documentation:ES:FldCod:DatTyp:8.1.4#String A list of these special characters] is available.

===HTML in Field Codes===
With special configuration, field codes can contain HTML markup; for example, you could have a field code <$my.agent.signature$> defined as
<pre>
Sam Agent 
Acme Products 
29 Exterior Blvd 
Springfield, CX 09090 
</pre>
To enable this, you must use the Java property <tt>-Dsrl-field-code-allow-html=true,</tt> in one of the following ways:

*Add it to the <tt>JavaArgs</tt> section of <tt>ContactServerDriver.ini</tt>
*Add it as an argument to the startup command line in <tt>contactServer.sh.</tt>
|Status=No
}}{{Section
|sectionHeading=Operator Precedence
|anchor=OperatorPrecedence
|alignment=Vertical
|structuredtext=If you use more than one operator in a formula, the order in which they are evaluated depends on their relative ''precedence'' (higher precedence operators are evaluated first). For example, multiplication (<tt>*</tt>) has a higher precedence than addition (<tt>+</tt> ), so that the formula below evaluates to <tt>14,</tt> not <tt>20:</tt>

:<tt><$2 + 3 * 4$></tt>
: 

You can use parentheses to override the default precedence. The formula below evaluates to <tt>20:</tt>

:<tt><$(2 + 3) * 4$></tt>
: 

For a complete list of operators and their relative precedence, see "[https://docs.genesys.com/Documentation:ES:FldCod:OpePre:latest Operator Precedence]” in the [https://docs.genesys.com/Documentation:ES:FldCod:welcome:latest Genesys eServices Field Codes Reference Manual].

===Data Types===
Operands of several different types may appear in formulas:

*Number
*String (text)
*Date/time
*Boolean (true/false)
*Object (Contact, Interaction, and Agent)

Each data type behaves differently in formulas, and the operators have different meanings when you use them with different data types. For example, the <tt>+</tt> operator means “add” when used with numbers, but “concatenate” (paste together) when used with strings. This formula evaluates to ''Uncle Sam Wants You'':

:<tt><$"Uncle Sam " + "Wants You"$></tt>
: 

In addition, some operators cannot be used with some data types at all. For example, you cannot use the multiplication (<tt>*</tt>) operator on two strings.

All formulas, regardless of their final data type, are converted to strings before being merged into your standard response. This conversion follows a set of default rules that depend on the data type. For example, the default rules for numbers round them off to integers. This formula causes <tt>2</tt> to be inserted into your standard response, even though the real result is <tt>2.25:</tt>

:<tt><$9 / 4$></tt>
: 

You can use the <tt>Text</tt> function (see below) or <tt>format operator</tt>:) to override the default formatting. Either of the following formulas inserts <tt>2.25</tt> into your standard response:

:<tt><$Text(9 / 4, "#.##")$></tt>
:<tt><$(9 / 4):"#.##"$></tt>
: 

For a detailed list of data types and how you can use them, see "[https://docs.genesys.com/Documentation:ES:FldCod:DatTyp:latest Data Types]” in the [https://docs.genesys.com/Documentation:ES:FldCod:welcome:latest Genesys eServices Field Codes Reference Manual]..
|Status=No
}}{{Section
|sectionHeading=Functions
|anchor=Functions
|alignment=Vertical
|structuredtext=When composing formulas, you can use many built-in functions. ''Functions'' are predefined formulas that perform calculations using values, called ''arguments,'' which you supply. To use a function, write its name, followed by an opening parenthesis, the arguments for the function separated by commas, and a closing parenthesis.

Function arguments may be of any data type, although individual functions may place restrictions on their arguments. Function arguments may be constants or formulas. The <tt>Length</tt> function, for example, takes a single string argument and returns its length in characters. This formula evaluates to <tt>13:</tt>

:<tt><$Length("Hello, world!")$></tt>
: 

As another example, the <tt>Date</tt> function takes individual date components (year, month, day, and so on), and constructs a date/time value. The formula below evaluates to <tt>1965-11-23 09:03:10:</tt>

:<tt><$Date(1965, 11, 23, 9, 3, 10)$></tt>
: 

Functions may act as arguments to other functions. The <tt>WeekdayName</tt> function takes a single date/time argument and returns the day of the week as a string. The formula below evaluates to <tt>Tuesday:</tt>

:<tt><$WeekdayName(Date(1965, 11, 23, 9, 3, 10))$></tt>
: 

This formula evaluates to <tt>7:</tt>

:<tt><$Length(WeekdayName(Date(1965, 11, 23, 9, 3, 10))$>)</tt>
: 

For detailed descriptions of all available functions, see "[https://docs.genesys.com/Documentation:ES:FldCod:Fun:latest Functions]” in the [https://docs.genesys.com/Documentation:ES:FldCod:welcome:latest Genesys eServices Field Codes Reference Manual].

===Using Objects===
All object/property pairs are also available in the <tt>Variables</tt> drop-down menu in the Knowledge Manager <tt>Field Code Editor.</tt>

Object properties can be of any data type. <tt>Agent.FullName,</tt> for example, is a string, but <tt>Interaction.DateCreated</tt> is a date/time.

The data type of an object property can even be another object. For example, <tt>Contact.EmailAddresses</tt> yields another object called a <tt>ContactEmailAddressList.</tt> In cases such as this, you can access the properties of the resulting object by entering a period (.), followed by the property name, just as before. For example, the formula below evaluates to the number of e-mail addresses assigned to the contact:

:<tt><$Contact.EmailAddresses.Count$></tt>
: 

Some object properties require arguments just as functions do. For these properties, write the arguments, enclosed in parentheses after the property name, just as before.

For example, the ContactEmailAddressList object has a property named <tt>Exists,</tt> which you can use to test whether a particular e-mail address is assigned to a contact. The data type of this property is Boolean (true/false), and it takes one argument, the e-mail address to test. For example:

:<tt><$Contact.EmailAddresses.Exists("samd@acme.com")$></tt>
: 

For detailed descriptions of all objects and their properties, see "[https://docs.genesys.com/Documentation:ES:FldCod:Obj:latest Objects]” in the [https://docs.genesys.com/Documentation:ES:FldCod:welcome:latest Genesys eServices Field Codes Reference Manual].
|Status=No
}}
}}

@@ Line 5: / Line 5: @@
 |Context=View formula usage in field codes.
 |ComingSoon=No
-|Platform=GenesysEngage-onpremises
+|Platform=GenesysEngage-cloud
 |Role=Administrator
 |Application=Platform Administration

PEC-ES/Current/Administrator/FCanatomy - Revision history

WikiSysop: Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Bgrenon: Published

WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"