You are here:
Custom Formula Fields
To select records based on information in multiple objects, create a custom formula field.

Use more general search terms.
Select fewer filters to broaden your search.
You are here:
To select records based on information in multiple objects, create a custom formula field.
| Available in: Lightning Experience |
| Available in: Enterprise, Performance, Unlimited, and Developer Editions |
You can use custom formula fields for a briefcase to filter records by a value that references fields in more than one object. For example, your briefcase users want records from accounts located in their U.S. state. The account information is stored in the Account object, and the briefcase user's information is stored in the User object.
Your briefcase users need records from the Account object but not the User object. So instead of creating related object rules, you can create a custom formula field that matches the account and the user’s state. After you create a custom formula field, you can use the field in an object rule filter.

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.