Formula Fields

Formula Fields

A formula field is made up of three elements: Functions, Arguments and Operators.

A Function expresses the dependence between two quantities, one of which is input and the other which is output. In other words, function performs a specific operation on values that you specify and generates a new value. To compose a function, you need to type the function name, followed by a set of parentheses, which contains information to perform the function. The values within the parenthesis are called arguments.

Examples: Abs(); Ceil(); Timepart()

An Argument is a piece of information within a function that commands the values to act or produce. Arguments appear within the parentheses and are separated by comma (argument 1, argument 2, etc.). The types of argument(s) in a function can be either texts, numbers, field references or even another function.

Examples: Abs(-27.05); Max(12,6,10)

An Operator is a special symbol such as "+" or "%", that acts upon the arguments (literals, numbers, fields references) in the formula and returns a new value.

Examples: Abs(+27.50); (32*25)

Data Types

Numeric | String | DateTime | Boolean

Functions

Numeric | String | DateTime | Boolean

    • Related Articles

    • Fields

      Set Access Permissions for Fields With the field-level security, you can control the access rights of CRM fields for various profiles. This will ensure smooth security at the field-level, allowing users to access the fields that are relevant to their ...

    • Standard Fields

      Following are the list of defined standard fields available in the Products module: Field Name Description Data type Maximum Limit Service Name* Specify the name of the product. This field is mandatory. Text box Alphanumeric(50) Service Owner Select ...

    • Standard Fields

      Following are the list of defined standard fields available in the Leads module: Field Name Description Data type Maximum Limit Lead Owner Select the CRM user to whom the Lead is assigned. Lookup - Salutation Select the salutation from the drop-down ...

    • Custom Fields

      For almost all of the fields that you create, you need to specify the following: Label: Specify a name for the field. Field Properties: Specify properties of the field such as description, field values and so on. Other specifications required for ...

    • Standard Fields

      Field Name Description Data type Maximum Limit Vendor Owner Select the name of the user to whom the Vendor details is assigned. Lookup   Vendor Name* Specify the name of the vendor. This field is mandatory Text box Alphanumeric(50) Phone Specify the ...