Calculate Fields extension for Vtiger CRM

This is the tool which allows calculating values for numbered fields

The usage of this tool is simple and requires only basic knowledge of the Vtiger CRM custom fields and filters/custom view creation

Calculate Fields features

  • Supported mostly all modules
  • Provides SUM, AVG, MIN, MAX, COUNT values
  • Automatic calculations via Scheduler
  • AfterSave calculations (from version 4.5)
  • Calculation based on fields from related modules
  • Using standard Vtiger functionalities (filters, custom fields)
  • Your own already created filters can be used for Calculated Fields
  • Unlimited number of Calculated Fields
  • Compatible with PDF Maker & Email Maker
  • Easy installation & usage
  • Vtiger 7.x/6.x compatible
  • New feature added for Vtiger 7.x: Calculating Date Fields
  • Included in our packages: Mini, Extended, All Access
calculate fields for vtiger

Start using Calculate Fields now!

Installation & Usage

Installation & Validation is via our Free Extension Installer

For detailed guide how to validate and install our modules visit guide below:

*Guide apply for Vtiger 7.x and Vtiger 6.x versions
*Calculate Fields have same installation package for Vtiger 7.x & 6.x

 Notice: the calculations provided for Calculated Fields are done automatically based on scheduler settings and cannot be initiated manually. Please check the scheduler settings, i.e. check whether the status for Calculate Fields is “Active”. If not, please change it, as well as define frequency as shown in the picture below:
(Frequency time is up to you, but we don’t recommend setting it to less than 15 minutes.)
the calculations provided for Calculated Fields are done automatically based on scheduler

Since August 2021 we also support AfterSave calculations

This is included in version 4.5 and higher

 What is a AfterSave calculation?

The the calculations will be made immediately after saving the record.

For example:

We have an Organization where in the Annual Revenue field, there should be a SUM of all Paid Invoices assigned to the given organization.
So now when you create or edit any Invoice related to this Organization, the Annual Revenue will be instantly recalculated after you press Save button when editing or creating an Invoice.

You can find manual for Vtiger 7.x and Vtiger 6.x below:

*In Vtiger 6. x manual, please skip Installation part and use our Installer instead.

Creating custom field for calculation via Calculate Fields

Creating custom field for calculation via Calculate Fields

 

Creating Calculation Example

Creating Calculation Example

Result:

  • 30 August 2021: 4.5
    • added new AfterSave Scheduling type, where the calculations will be made immediately after saving the record
  • 12 January 2021: 4.4
    • improved Count operation, to count records, for example: Employes in Organization (assigned contacts)
  • 19 August 2020: 4.3
    • fixed issue where calculations were not working for Cashflow extension
    • minor bug fixes
  • 16 June 2020: 4.2
    • fixed issue with calculating values for Invoice module
    • minor bug fixes
  • 20 May 2020: 4.1
    • minor bug fixes
  • January 2020: 4.0
    • new validation system via our FREE extension Installer
  • August 2019: 600.700.1.1
    • extension release for Vtiger 7.x
    • same installation package for Vtiger 7.x & Vtiger 6.x

Try Calculate Fields via our Extension Packages Trial (14 days)

(included in Mini, Extended and All Access packages)

We use cookies to improve our website. By browsing this website, you agree to our use of cookies. More info