Calculate Fields for Vtiger CRM

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.)

Since August 2021 we also support AfterSave calculations

This is included in version 4.5 and higher

What is an AfterSave calculation?

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.

Creating custom field for calculation via Calculate Fields

Creating Calculation Example

Result:

• 14 February 2024: 4.16
  • fixed a problem where the CRON calculation does not stop when the organization or other records are deleted
  • fixed problem where After save Product action into Opportunity did not work
• 23 January 2024: 4.15
  • improved compatibility with Vtiger 8.0
  • other minor improvements

--- 2022 ---

• 21 September 2022: 4.14
  • improved compatibility with our extension Convert Sales Order to Purchase Order
  • other minor improvements
• 25 February 2022: 4.13
  • supported Item/Inventory Details operations
    (example, SUM for all Invoices in the Organization and their quantities)
  • Vtiger 7.5 and PHP 8.x compatibility
  • other minor improvements
• 4 January 2022: 4.12
  • Calculate fields aftersave action will no longer remove products from Inventory modules

--- 2021 ---

• 8 December 2021: 4.11
  • the condition "current month" for module Calendar, will do a calculation properly now
• 26 October 2021: 4.10
  • custom conditions will be no longer removed when editing existing Calculated Fields
  • added Module Requirements link
• 11 October 2021: 4.9
  • Cron settings will not be removed when Updating the Calculated Fields
• 8 October 2021: 4.8
  • List view labels translation fixed
  • After save calculation minor improvements
• 29 September 2021: 4.7
  • resolved cron issues
  • resolved issues with decimal separators used in fields
• 7 September 2021: 4.6
  • fixed ajax calculations related to workflow calculations
• 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: Employees in Organization (assigned contacts)

--- 2020 ---

• 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

--- 2019 ---

• August 2019: 600.700.1.1
  • extension release for Vtiger 7.x
  • same installation package for Vtiger 7.x & Vtiger 6.x