gwp_sum_matched_entries
The gwp_sum_matched_entries Modifier can be used to calculate the sum of a field value in multiple entries of a certain form (the same or another), based on a shared value with optional extra filters.
:gwp_sum_matched_entries form_id= match_id= filter1= operator1= value1= filter2= operator2= value2=Supported operators: ‘is’, ‘isnot’, ‘contains’, ‘greater_than’, ‘less_than’, ‘greater_than_or_is’, ‘less_than_or_is’.
Examples
{PROJECT_ID:21:gwp_sum_matched_entries_values form_id=19 match_id=8 return_id=11}
{Textfield:1:gwp_sum_matched_entries form_id=2 match_id=1 return_id=5 filter1=3 operator1=isnot value1=complete filter2=created_by operator2=is value2=1}Matches all entries in Form 2 where Field 1 has the same value as {Textfield:1}. The total sum of Field 5 is returned, but only entries where the Field 3 value is ‘complete’ AND where created_by is the User with user-id 1.
{PROJECT_ID:21:gwp_sum_matched_entries_values form_id=19 match_id=8 return_id=11}Finds all entries where Field 8 in Form 19 has the same value as {PROJECT_ID:21}. The total sum of the values in Field 11 of the matching entries in Form 19 is returned.
Last updated: 26-07-2023
