Formula fields and relations

We can define formula fields that reference related objects (from child to parent only, not vice versa). They are called cross-object formulas.

The following is an example of a custom formula field that shows the case's subject on the case detail record:

Case__r.Subject + '(' + Case__r.RecordType.Name +')' 

This formula field will display the parent case's Subject field and the case record type's name:

Cross-object formula example
We can reach a grandparent object that is 10 levels away from the current object.

Think about the account's Parent field. You can create a hierarchy of accounts and you can reach into a custom formula from a child Account to the fields of a parent Account that is the fourth parent.

We can create up to 10 unique relations between a child object and related objects.

This means that if you have 15 different lookups on a given record, you can reference at most 10 different object types in the child object formulas. This limit applies to formula fields, but also formulas on rules (such as workflow rules or validation rules) and lookup filters.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.226.165.247