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.