Stores formula field definitions used for calculated values in Salesforce records.

View-Specific Information

SELECT

The connector processes all filters client-side within the connector. The following queries are the only ones processed server side:

SELECT * FROM Formulas WHERE TableName = 'Account'

Note: Querying the table without a TableName filter specified will attempt to retrieve column metadata for all objects in your Salesforce account. Depending on the number of objects, this can take a while.

Columns

Name	Type	References	Description
TableName	String		Name of the Salesforce object or table the formula is associated with. Required when querying or managing formulas.
ColumnName	String		Name of the column or field that the formula is applied to. This represents the output field generated by the formula.
Formula	String		The calculated expression or logic that defines the formula field. This can include field references, operators, functions, and constants.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
GetDefinitions	Bool		Whether or not to retrieve the calculated expression or logic that defines the formula field. When multiple tables are involved and you only intend to get the list of the formulas, disabling this results in better performance because retrieving the definitions requires a lookup per entity. Defaults to true.'