Knowledge Base

Configuration of Calculate Fields

#

Configure Settings #

Once you installed the module, you can find the module under Extensions by visiting User Profile → Settings

  • Select SmackCalculateFields module under Extensions.
  • The module automatically turns on once it gets installed.
  • To configure a new calculation, SelectNew Calculate Field button.

Create New Calculate Field using Joforce Calculate Fields module

  • Select the target module from the dropdown in which the new calculated field is created.

Select target module to configure with Calculate Fields

  • Select the target field from ‘Select target field’ where the calculation results are stored.

Select-target-field

  • Choose Source Module and short add a description if needed.

choose-source-module

  • Then select the Column or related field of the source module.

choose-column-joforce-calculate-fields

  • Select Operation.

Select-operation-joforce-calculate-fields

  • You can select operations like SUM(value1+value2+…+valueN), AVG(SUM/COUNT), MIN(minimal value from all values, i.e. value1 …valueN), MAX (maximum value from all values, value1 …valueN), and COUNT (the count of the values, i.e. N)
  • Select filter for the related or source module.

select-filters-joforce-calculate-fields

  • You can also create new custom view/filters by setting up your own conditions. The calculations are done using the group of related records only which satisfies the filter conditions.

create-conditions-with-filters

  • Click On Save button.

save-calculate-field-configuration

  • Run cron.php with joforce root path in your web browser. For example, type the path ‘localhost/joforce/cron.php’ in your browser.
  • You’ll get the calculated values in the destined field of the target module record after you run the cron.

joforce-contact-detail-view

  • The configurations can be edited and deleted whenever necessary.