Submit a request Sign In
  • Logout
    Home  >   Articles   >  Formula Fields
    Articles in this section
    Authenticate Emails with SPF, DKIM, and SenderID Auto forward your emails to Vtiger Automate Outgoing Emails in Email Settings Managing User Profiles Automation - Approvals Setting up User Roles Automation - Assignment Rules Set up Multi-path Workflows Creating a Scheduled Workflow Automation - Scheduler Creating a Workflow Webforms in Vtiger CRM Set up a Workflow Action to Create Event Set up a Workflow Action to Create Records Set up a Workflow Action to Create Task Set up a Workflow Action to Invoke Custom Function Set up a Workflow Action to Create an SMS Task Set up a Workflow Action to Send Mails Set up a Workflow Action to Update Fields Automation - Workflow Action - Webhook Automation - Workflows - Vtiger Expressions Configuration - Business Hours Configuration - Company Details Configuration - Consents Configuration - Customer Portal Maps in Vtiger CRM Configuration - Usage Details Configuring Encrypted Data Fields in Vtiger CRM Configure Picklist Dependencies Considerations for Deactivating Vtiger Users Control Fields and Record Displays using Configuration Editor Create Reminders for Records and Inbox Create a field of a Grid type Dealing with Currencies and Taxes Enable Desktop Notifications on Chrome Web Browsers Vtiger CRM Add-ons IMAP Configuration - 2-way sync between Vtiger and IMAP providers Setting up Autopay & Payment Gateways Inventory - Tax Management Inventory - Terms and Conditions Login to Vtiger on SSO SAML using ADFS Mailroom Functionality for Different Scenarios Manage Multiple Currencies Marketing and Sales - Deal to Project Mapping Marketing and Sales - Lead Conversion Data Mapping Marketing and Sales - Profile Scoring Module Management - Labels Editor Module Management - Module Numbering My Preferences My Preferences - Calendar Settings Tags in Vtiger My Preferences - Notification Preferences SAML Support in Vtiger CRM Set up Mailroom Settings - Configure Module Settings Settings - Create Dynamic Fields and Layouts Module Management - Creating a Relationship Between Modules Settings - Customize Records and Fields for your Business Settings - How to set email autoresponder to Webform submission? Settings - Left Menu Settings - Manage Global Picklists in Vtiger Settings - Set up your Support Team Settings - Start Up Page Settings - Working with Picklist Values Module Management - Module Builder Support - SLA Policies Troubleshooting Login Issues Add-Edit Unsubscribe Links in your Email Template User Management - Authentication User Management - Encrypted Field Access Logs User Management - Groups User Management - Login History User Management - Profiles User Management - Roles User Management - Settings Log User Management - Sharing Rules User Management - Users User Management - Vtiger Support Access Vtiger Buzz - Chrome Extension for Notifications Vtiger Implementation wizard Vtiger Language Support Configuring Websense Trackers Websense - Widgets Auto forward Emails from Microsoft Office 365 Configuration - Storage Guard Customizing your Self-Service Portal Theme Using CSS Styles Adding Hidden Fields to a Webform Login Page Customization Creating App-specific Password for Gmail Outgoing Server Module Management - Module Layouts & Fields Settings - Personalize Module Layouts Module Management - Modules Adding Custom Module Automation - SMS Reply Actions Duplicate Prevention in Modules Configuring Dependent Fields and Blocks for Modules Creating Custom Filters Adding a local DNS Entry

    Formula Fields

    In this article, you will learn how to create and access Formula fields for CRM modules!
    S
    Shreya Kulkarni
    1 Jun, 2023 - Updated 10 months ago
    Table of Contents

    Introduction

    Creating a formula means setting up a mathematical or any module-specific rule for a module to attain a specific result. Vtiger CRM lets you create formula fields for CRM modules. Once a formula field is created for a module, the formula is applied by default every time you add new records or edit old records. Formula fields are also available for Custom modules. You can create a formula field from Settings >  Module Layouts & Fields settings. You can create a formula by selecting and evaluating the following: 

    • A module section’s fields or Vtiger Expressions or both.
    • The equation (formula) to be executed.

    You can create a formula for the following data types:

    1. Text
    2. Decimal
    3. Integer
    4. Percent
    5. Date
    6. Textarea
    7. Time
    8. DateTime

    Note:

    The formula fields:

    • Allow all mathematical expressions available for workflow expressions.
    • Let you generate reports using the values.
    • Are not updated on import or export of records.

    Benefits of Formula Fields

    • A formula field is auto-updated for created modules.
    • Facilitates quick and convenient mathematical calculations or rules.
    • Saves time for users.
    • Requires low implementation efforts.

    Feature Availability

    Click here for the availability of the Formula Fields for different editions of Vtiger CRM.

    Creating Formula Fields

    In this section, let us learn how to create formula fields in Vtiger CRM. In this instance,  you will create the formula field, Price, for the Invoices module. You can create a formula for any module.



    Follow these steps to create a formula field:

    1. Login to your CRM account.
    2. Click the User Menu.
    3. Click Settings on the left corner of the screen.
    4. Look for Module Management.
    5. Click Module Layouts & Fields.
    6. Select a module for which you want to create a formula field - Invoices.
    7. Select a section for which you want to create a formula field - Item Details.
    8. Click +Add Custom Field. This will take you to the Create Custom Field window where you can create a formula field.
    1. Enter or select the below information:
    1. Select Field Type - Select Formula.
    2. Label Name - Enter a name for the formula Price.
    3. Max digits allowed - Enter the maximum digits you want to allow for the formula field 10.
    4. Decimals - Enter the number of decimals you want to allow for the formula field 2.
    5. Value data type - Select a suitable data type for the formula field Decimal.
    6. Expression - Select the fields and functions to be evaluated for the formula:
      1. Use Field - Select the fields to be evaluated, or, 
      2. Use Function - Select the functions to be evaluated. Or both if required.
      3. Enter the formula to be executed in the Expression box. For instance, we have selected the following:

    1. Fields - Quantity and Unit Selling Price.
    2. Function  - Roundoff(field, precision). This function is used to round off
      a number to the specified precision.
    3. Formula - Quantity multiplied (*) by Unit Selling Price rounded off to 2
      decimal values. Hence the Formula is     roundoff(Quantity * Unit
      Selling Price,2)    .
    4. Follow these steps to enter the formula roundoff(Quantity * Unit
      Selling Price,2)    :

    a. Select the roundoff(field, precision) function.
    b. Select Quantity, Unit Selling Price fields as field values.
    c. Enter 2 as the precision value.
    d. Enter Quantity * Unit Selling Price.

    10. Click Save.


    You have now successfully created the formula field Price for Invoices.

    Note:

    Once you create a formula field for a module, the formula field will be applied only to the following:

    • New records that were created and saved from then on.
    • Old records that are edited.

    Accessing Formula Fields

    In this section, let us learn how to access the formula fields you created.

    Note: In this instance, we have considered the Invoices module and the Formula field, Price.

    Follow these steps to access a formula field: 

    1. Log in to the CRM.
    2. Go to Inventory.
    3. Go to Order Fulfillment.
    4. Go to the Invoices module.

    Note: The Formula Field will reflect in new or edited records. 

    1. Create an Invoice record with formula field details. For instance, we have created a tender record with Quantity 165 and Unit Selling Price 850.86.
    2. Click Save.
    3. Go to the Item Details section for which you have created the formula.

    8. You can now view the created formula field Price in the chosen section.
     

    Note:

    Formula fields  created for:

    • Line item fields are applied at an individual line item row level.
    • Normal (other) fields are applied at the record level.
    Was this article helpful?
    0  out of  0  found this helpful.
    Comments 0
    Be the first to comment
    Home
    Privacy Policy
    Terms of Service
    Security Center
    Policy & Legal Center
    Contact Us
    © Copyright 2023 Vtiger. All rights reserved.
    Powered by Vtiger