• Consulting
    • Digital Client
    • Digital Financing
    • Digital Business Analysis
    • ECM/DMS
    • Adoption
    • Information Services and Digital
    • Testing Consultancy
    • Sourcing
  • Salesforce Solutions
    • Salesforce
    • MuleSoft
  • EI-Workplace Solutions Employé Digital
  • Training
    • Presentation
    • Salesforce
  • Partners
  • Digitally Driven - Blog
  • AppInovation
  • Company
    • History
    • The Founders
    • Key Figures
  • Join us
  • Blog
  • News
  • Clients
  • Contacts
logo EI-Technologies Adapt your business to the digital revolution
fren
Menu

Formula Field

    • Home
    • Training
    • Abécédaire Salesforce ADX201
    • Formula Field

Formula Field

Formula fields are used to perform calculations and, for example, to copy dynamically text data that is in another field. The formula field can use a simple or advanced formula. In this case, functions (IF, TEXT, TODAY, ISPICKVAL …) are used.

The formula field is updated as soon as one of the source fields is modified and saved. It is read-only and the calculated values are not stored; They can be exploited via reports.

The formula field can be cross-object, that is when creating a formula on an object, you can reference fields from parent objects that are up to 10 relationships away. This allows you to fetch values that are located on other related objects.

 

Nota:

Ex: simple formula = amount * 0.1

Advanced formula:

IF (amount> 8000000, « Hot » , « Cold »)

Ex: I create a formula field on my Opportunity object and in my calculation that references an account field, I need a datum that is on the account object. I will therefore be able to go back to the table of accounts directly from my formula.

  • Company
    • History
    • The Founders
    • Key Figures
  • Join us
  • Blog
  • News
  • Clients
  • Contacts
  • COOKIES PREFERENCES
  • Privacy and data protection policy
  • Legal notices
  • Follow us

We are using cookies to give you the best experience on our website.

You can find out more about which cookies we are using or switch them off in settings.

EI-Technologies
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookies

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.

3rd Party Cookies

This website uses Google Analytics to collect anonymous information such as the number of visitors to the site, and the most popular pages.

Keeping this cookie enabled helps us to improve our website.

Please enable Strictly Necessary Cookies first so that we can save your preferences!