I have a quantity field in a repeating section. I need to determine the total of that field outside of the section. How do I sum up the quantity of items inside the repeating section in Cognito Forms.
Cognito-forms – How to sum quantities in a repeating section
cognito-forms
Related Solutions
I am a developer for Cognito Forms.
This is an idea that has been brought to our attention and a feature that we do plan to add in the future, you can follow the progress for this over on our Idea Board.
Cognito Forms allows you to post a JSON document to webhooks when new entries are submitted that accurately reflects the data being collected. Forms can be hierarchical with multiple repeating sections and even nested repeating sections, so it naturally lends itself to being expressed using JSON. Repeating sections are not stored in a single field--they are actually arrays of child entities that have their own fields and children.
For example, the form you described might look like this:
And the corresponding JSON looks like this:
As you can see, the Children repeating section is represented correctly in JSON as an array of child entities, each of which have Name and Gender fields.
Related Topic
- Cognito-forms – Calculations and repeating sections
- Cognito-forms – Custom repeating section in Cognito Forms
- Cognito-forms – Multiple repeating section calculation
- Cognito-forms – Cognito Forms: Referencing a field in a repeating section
- Cognito-forms – How to insert page breaks after each repeating section item in custom document merge templates with Cognito Forms
- Cognito-forms – How to a user eliminate a repeating field
Best Answer
I am a developer with Cognito Forms
The easiest way to total up the quantity across all items in a repeating section is to leverage a calculation field to sum up the total.
For example, if you have a repeating section called "Products" and within each item you have a number field called "Quantity", you can create a calculation field outside of the repeating section. The calculation would simply be
=Products.Sum(Quantity). Make sure to set the Type of the calculation field to be "Number" so that the value is formatted correctly.I've included a screen shot a basic form that illustrates this setup.
You can also find this, and other powerful calculations in our help documentation at: http://help.cognitoforms.com/calculations-overview, check out the section on "Working with Repeating Sections".