...
Go to the Integrations Shared Lookup to define the new count or sum.
Module → Module Name → Shared Lookups (tab) → IntegrationsSelect +New in the top left to add a new Sum or Count within the Integrations Shared Lookup.
Defined the Name, Description, and select which Module this is for.
Select 'Add a new Connector operation'.
Specify the selection as SQL, Count/Sum, and the Field to be totaled, then Save in the bottom left.
Go to the Field List and select the field which will store the resulting value/total.
Module → Module Name → Forms (tab) → Create/Update Fields… → Field for storing resultSelect Edit in the Field Value section of the Field Properties.
In the ‘Take value from’ section select Execute Integration.
In the ‘Execute an integration’ section select the Name of the Integration defined previously.
If ‘Additional Criteria’ is needed it should be defined here by selecting the required equality statements.
This field should now store the resulting Count/Sum of the defined field based on the described criteria.
Info |
---|
If you have reviewed the above and are experiencing any issue or have any questions contact Stratawise Support |
Related articles
Filter by label (Content by label) | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...