Formulas fields

Formulas fields-salesforce

Q: Formulas are fields return types?

Force.com platform allow you to create formula is similar to an equation that is executed at run time.

Depending on the context of the formula, it can make use of various data and operation to perform the calculation

The data type of a formula determines the type of data you expect returned from formula.

This document contains the following categories of custom formula samples:

• Account Management

• Account Media Service Links

• Case Management

• Commission Calculations

• Contact Management

• Data Categorization

• Date Calculations

• Discounting

• Employee Services

• Expense Tracking

• Financial Calculations

• Image Links

• Integration Links

• Lead Management

• Metrics

• Opportunity Management

• Pricing

• Project Management

• Scoring Calculations

Formulas are fields return types

·        Currency

·        Data

·        Data/time

·        Number

·        Percent

·        Text

OPERATORS AND FUNCTIONS:

Math OPERATORS

·         *

·         /

·         +

·         -

·         ^

·         ()

Logical Operators

·         = and ==

·         <> and! =

·         < 

·         > 

·         <=

·         >=

·         &&

·         ||

Text Operators

·         &

Date and Time Functions

·         DATE

·         DATEVALUE

·         DATETIMEVALUE

·         DAY

·         MONTH

·         NOW

·         TODAY

·         YEAR

Informational Functions

·         BLANKVALUE

·         ISBLANK

·         NULLVALUE

·         PRIORVALUE

Logical Functions

·         AND

·         CASE

·         IF

·         ISCHANGED

·         ISNEW

·         ISNUMBER

·         NOT

·         OR

Math Functions

·         ABS

·         CEILING

·         EXP

·         FLOOR

·         LN

·         LOG

·         MAX

·         MIN

·         MOD

·         ROUND

·         SQRT

Text Functions

·         BEGINS

·         BR

·         CONTAINS

·         FIND

·         GETSESSIONID

·         HTMLENCODE

·         HYPERLINK

·         IMAGE

·         INCLUDES

·         ISPICKVAL

·         JSENCODE

·         SINHTMLENCODE

·         LEFT

·         LEN

·         LOWER

·         LPAD

·         MID

·         RIGHT

·         RPAD

·         SUBSTITUTE

·         TEXT

·         TRIM

·         UPPER

·         URLENCODE

·         VALUE

·         GETRECORDIDS

·         INCLUDE

·         LINKTO

·         REGEX

·         REQUIRESCRIPT

·         URLFOR

·         VLOOKUP

Encoding Functions

·         HTMLENCODE

·         JSENCODE

·         JSINHTMLENCODE

·         URLENCODE