Dan Zahlis asked 3 years 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:
https://formidableforms.com/knowledgebase/repeatable-section/#kb-get-the-total-of-the-values-of-a-repeater-field
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.
Please login or Register to submit your answer
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.).
https://formidableforms.com/knowledgebase/repeatable-section/#kb-displaying-repeater-fields
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.
https://formidableforms.com/knowledgebase/add-field-totals-and-statistics/
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.