Newer Version Available

This content describes an older version of this product. View Latest

FormulaFunction

Represents a function used when building a formula, including examples and uses. This object is available in API version 47.0 and later.

Supported Calls

describeSObjects(), query()

Fields

Field Details
CategoryId
Type
string
Properties
Filter, Group, Nillable, Sort
Description
The ID of the FormulaFunctionCategory.
This is a relationship field.
Relationship Name
Category
Relationship Type
Lookup
Refers To
FormulaFunctionCategory
Description
Type
string
Properties
Filter, Group, Nillable, Sort
Description
Description of the formula function.
DurableId
Type
string
Properties
Filter, Group, Nillable, Sort
Description
Unique identifier for the field. Always retrieve this value before using it, as the value isn’t guaranteed to stay the same from one release to the next. To simplify queries, use this field.
ExampleString
Type
string
Properties
Filter, Group, Nillable, Sort
Description
Describes the function and what arguments you can use with it.
IsAllowedInEntityContext
Type
boolean
Properties
Defaulted on create, Filter, Group, Sort
Description
Indicates whether you can use the formula function on an Entity (true) or not (false). For example, you cannot use the PRIORVALUE function in a custom Account formula field. The default value is false. This field is removed in API version 48.0 and later. Use the FormulaFunctionAllowedType object instead.
IsAllowedInFlowContext
Type
boolean
Properties
Defaulted on create, Filter, Group, Sort
Description
Indicates whether the formula function is allowed in a Flow (true) or not (false). The default value is false. This field is removed in API version 48.0 and later. Use the FormulaFunctionAllowedType object instead.
IsAllowedInVisualforceContext
Type
boolean
Properties
Defaulted on create, Filter, Group, Sort
Description
Indicates whether the formula function is allowed in Visualforce (true) or not (false). The default value is false. This field is removed in API version 48.0 and later. Use the FormulaFunctionAllowedType object instead.
Label
Type
string
Properties
Filter, Group, Nillable, Sort
Description
The formula function label that appears in the user interface.
Name
Type
string
Properties
Filter, Group, Nillable, Sort
Description
The name of the formula function.

Usage

Query FormulaFunction to search for available formula functions, such as AND(), ISBLANK(), MAX(), MIN(), and others.