Difference between revisions of "Formula Functions"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
Line 2: | Line 2: | ||
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: | ||
:* [[Rules#Execution Criteria]] | :* [[Rules#Execution Criteria]] | ||
:* [[Macros]] | :* [[Macros#Visibility Criteria]] | ||
:* [[Formula Fields]] | :* [[Formula Fields]] | ||
:* [[Validations]] | :* [[Validations]] |
Revision as of 23:00, 25 March 2014
About the Formula Functions
Formula functions are logical and programmatic functions, used with fields and operators to build Formula Expressions in any of the following platform elements:
Conventions
The following conventions are used in these functions:
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]
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: