Difference between revisions of "Introduction to Expressions"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 1: | Line 1: | ||
An ''expression'' is any valid set of literals, variables and operators that evaluates to a single value | An ''expression'' is any valid set of literals, variables and operators that evaluates to a single value. | ||
The | An expression is used to build Filter criteria or a Formula. | ||
Two different kinds expressions are used in the platform: | |||
:* '''Filter Expressions''' | |||
::* Used to select records. | |||
::* The value of the expression is always a Boolean (true or false) value. | |||
::* Expressions are created using fields, values, comparison operators, and logical operators. | |||
::* Simple field selector | |||
::* No functions. | |||
:* '''Formula Expressions''' | |||
::* Used to return a value. | |||
::* The resulting value can be a number, a string, a date/time, or a Boolean (Logical: TRUE/FALSE). | |||
::* A wide variety of [[Formula Functions]] are available.<br>For example: | |||
::: <tt>ROUND( amount * 0.02, 2)</tt> (rounds the variable to the nearest 2 decimal places) | |||
::* Fields in Lookup target records can be referenced | |||
::* Logical operations are done with functions <tt>AND()</tt> and <tt>OR()</tt> | |||
The simplest expression is a literal value, a variable, or a formula function.<br>For example: | |||
:* <tt>972</tt> (a numeric literal) | :* <tt>972</tt> (a numeric literal) | ||
:* <tt>'Steve'</tt> (a string literal) | :* <tt>'Steve'</tt> (a string literal) | ||
:* <tt>creation_date</tt> (a variable value) | :* <tt>creation_date</tt> (a variable value) | ||
:* <tt>TODAY</tt> (a formula function that returns the current date) | |||
More complex expressions are created by combining values with operators--for example, to multiply a variable by a literal value: | |||
::<tt>amount * 0.02</tt> | ::<tt>amount * 0.02</tt> | ||
Revision as of 01:04, 10 May 2014
An expression is any valid set of literals, variables and operators that evaluates to a single value.
An expression is used to build Filter criteria or a Formula.
Two different kinds expressions are used in the platform:
- Filter Expressions
- Used to select records.
- The value of the expression is always a Boolean (true or false) value.
- Expressions are created using fields, values, comparison operators, and logical operators.
- Simple field selector
- No functions.
- Formula Expressions
- Used to return a value.
- The resulting value can be a number, a string, a date/time, or a Boolean (Logical: TRUE/FALSE).
- A wide variety of Formula Functions are available.
For example:
- ROUND( amount * 0.02, 2) (rounds the variable to the nearest 2 decimal places)
- Fields in Lookup target records can be referenced
- Logical operations are done with functions AND() and OR()
The simplest expression is a literal value, a variable, or a formula function.
For example:
- 972 (a numeric literal)
- 'Steve' (a string literal)
- creation_date (a variable value)
- TODAY (a formula function that returns the current date)
More complex expressions are created by combining values with operators--for example, to multiply a variable by a literal value:
- amount * 0.02