What are Formula Fields and Managing them

What are Formula Fields?

Formula fields are read-only type fields for which the values are calculated automatically based on the formula or the expression that is set up by you. You can create formula fields across all the modules (Contact, Company, Activity, and Deal).

• How to create Formula Fields?
• How to delete Formula Fields?

How to create Formula Fields?

In order to create a formula field, you can follow the steps listed down below

• Navigate to the Profile icon in the top right corner.
• Click on Setup.
• Head over to the Customization section and select the module for which you wish to create the field.
• Click on New Custom Field.
• Select Formula under field type.

• After clicking on the Formula type field, a pop-up will open where you can set up the following things-
  • Label - Name for your reference.
  • Section Name - select the layout of the appearance.
  • Formula Return Type - Return the type of data.
  • Formula - Define / Insert the required formula.

• You can return the formula result in 6 ways-  
  • Number
  • Currency
  • String
  • Date
  • Date Time
  • Boolean

• While inserting the formula, you will be able to choose from the available list of functions, operators, and the fields using which you wish to calculate the value.

• Once you have entered your formula, you can check if the Syntax is valid or not by clicking on the Check Syntax button.

• Once you have verified the expression, click on Save.

How to delete a Formula Field?

• Navigate to the Profile icon in the top right corner.
• Click on Setup.
• Head over to the Customization section and select the module for which you wish to create the field.
• Click on the Three Dots against the field you want to delete.
• Click on Delete.

• A pop-up warning block will open confirming if you wish to delete the field or move it to the inactive section.

• Click on Yes to proceed further or No if you don't want to delete the field.