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.

Object Reference for Salesforce and Lightning Platform

FormulaFunction

Supported Calls

Fields

Usage