How to Generate Summary Calculations using Field Values in a Repeater Field?

By: Dan Zahlis | Asked: 10/27/2022
ForumsCategory: How-toHow to Generate Summary Calculations using Field Values in a Repeater Field?
Dan ZahlisDan Zahlis asked 1 year ago
I have created a "Referral" form with a repeater field called "Additional Services" that contains a Radio Button field called "Service Provided." The "Service Provided" field contains three options: Regulation Space, Crisis Intervention and Family Inclusion. I would like to create a view that includes a summary count of the Services Provided (e.g. Regulation Space 6; Crisis Intervention 2; Family Inclusion 3). I thought this kb article would allow me to achieve this but I cannot seem to get it to work:  I'm also curious whether individual calculated fields using some manner of short code might work (i.e.; [220="Regulation Space"; 220="Crisis Intervention", 220="Family Inclusion"). Any help will be greatly appreciated.
Dan ZahlisDan Zahlis replied 1 year ago

I was successful in getting the total of the values of a repeater field to work. Using the [foreach] short code to display a series of attended services within a view is even better because it allows me to include a distinguishing date (i.e. Regulation Space 02/22/2022 Regulation Space 03/10/2022 etc.).

I'm getting somewhere with the field totals and statistics method but I am still unable to produce a count of the Services Provided per Referral. I am using [frm-stats id=x type=count 220_contains="Regulation Space"] in the Default (calculation) box and I'm still getting a 0 when I should be seeing a 2.

Dan ZahlisDan Zahlis replied 1 year ago

I found my solution! I'm using [frm-stats id=220 parent_id="[id]" type=count 220_contains="Regulation Space"] within a view. Sorry to pester everybody.

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community