Difference between revisions of "Functions in Formula Expressions"
From LongJump Support Wiki
imported>Aeric |
imported>Aeric |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Formula functions are logical and programmatic functions, used with [[fields]] and [[operators]] to build [[Formula Expressions]] in any of the following platform elements: | Formula functions are logical and programmatic functions, used with [[fields]] and [[operators]] to build [[Formula Expressions]] in any of the following platform elements: | ||
* [[Formula Fields]] | :* [[Formula Fields]] | ||
*[[Validations]] | :*[[Validations]] | ||
*Formulas in [[Computed Fields]] | :*Formulas in [[Computed Fields]] | ||
*Policy triggering criteria in Action-Based [[Data Policies]] | :*Policy triggering criteria in Action-Based [[Data Policies]] | ||
*[[Data_Policy#Add_Actions_to_a_Data_Policy|Update Record Action in Data Policies]]. | :*[[Data_Policy#Add_Actions_to_a_Data_Policy|Update Record Action in Data Policies]]. | ||
The reference information for each Formula Function includes: | The reference information for each Formula Function includes: | ||
* Format (syntax) of the Function | :* Format (syntax) of the Function | ||
* Argument(s) | :* Argument(s) | ||
* Description(s) | :* Description(s) | ||
* Return Value | :* Return Value | ||
* Examples | :* Examples | ||
==Date | == Date Functions == | ||
See [[Date]] for details about these Day, Date and Time-related formula functions: | See [[Date]] for details about these Day, Date and Time-related formula functions: | ||
| Line 62: | Line 62: | ||
|} | |} | ||
== Logical | == Logical Functions == | ||
See [[Logical]] for details about functions resulting in TRUE/FALSE (YES/NO, 1/0): | See [[Logical]] for details about functions resulting in TRUE/FALSE (YES/NO, 1/0): | ||
| Line 84: | Line 84: | ||
|} | |} | ||
==Math | == Math Functions == | ||
See [[Math]] for details about mathematical functions: | See [[Math]] for details about mathematical functions: | ||
| Line 118: | Line 118: | ||
|} | |} | ||
==Text | == Text Functions == | ||
See [[Text]] for details about text-related formula functions: | See [[Text]] for details about text-related formula functions: | ||
| Line 151: | Line 151: | ||
[[VALUE]]<br> | [[VALUE]]<br> | ||
|} | |} | ||
<!-- | |||
== Aggregate Functions == | |||
{| border="0" cellpadding="5" cellspacing="0" width="50%" | |||
|-valign="top" | |||
| [[Aggregate Functions#MAX|MAXIMUM]] <br> [[Aggregate Functions#MIN|MINIMUM]] | |||
| [[Aggregate Functions#SUM|SUM]] <br> [[Aggregate Functions#AVG|AVG]] | |||
| [[Aggregate Functions#COUNT|COUNT]] | |||
|} | |||
--> | |||
==Uncategorized == | ==Uncategorized Functions== | ||
{| border="0" cellpadding="5" cellspacing="0" width="50%" | {| border="0" cellpadding="5" cellspacing="0" width="50%" | ||
Latest revision as of 20:17, 10 February 2012
Formula functions are logical and programmatic functions, used with fields and operators to build Formula Expressions in any of the following platform elements:
- Formula Fields
- Validations
- Formulas in Computed Fields
- Policy triggering criteria in Action-Based Data Policies
- Update Record Action in Data Policies.
The reference information for each Formula Function includes:
- Format (syntax) of the Function
- Argument(s)
- Description(s)
- Return Value
- Examples
Date Functions
See Date for details about these Day, Date and Time-related formula functions:
Logical Functions
See Logical for details about functions resulting in TRUE/FALSE (YES/NO, 1/0):
Math Functions
See Math for details about mathematical functions:
Text Functions
See Text for details about text-related formula functions:
Uncategorized Functions
Conventions
The following conventions are used in this document:
| Element | Description |
|---|---|
| string | Strings must be enclosed with single quotes |
| dString | Date strings must be enclosed with single quotes |
| int | An integer,for example, a number representing the number of days (or months or years) |
| value | An argument in date- and date/time-related Formula Functions, which defines a unit of time |
| [ ,optional] | Optional values are shown in brackets, as [ ,option1, option2] |