Formula Field is a custom field generated by system of data type Formula.
It is a Read only field.
This field will display only in Detail page. It cannot display in Edit page.
We can create formula fields on Standard & Custom Objects.
We can use parent fields in the formula formation.
Formula values are case sensitive.
Formula Return values are 8 types..
- Checkbox
- Currency
- Date
- Date/Time
- Number
- Percent
- Text
- Time
Formulas are of 2 types..
- Simple formulas (It will use just operators like +,-,*, etc…)
- Advanced formulas (It will use Operators & functions)
Some basic function examples are
If( ), CASE( ), AND( ), OR( ), DAY( ), MONTH( ), TODAY( ), YEAR( ), ISPICKVAL( ), ISNULL( ), MAX( ), MIN( ), CONTAINS( ), TRIM( ) etc…….
TRIM( ) –> It eliminates spacebar in the middle only, one char allows. Syntax:trim(text).
For Navigation
Setup –> Build –> Create –> Objects –>select Object –> Click New( Custom Fields & Relationships) –> select Formula
Formula Editor and its Features