cognito-forms
I am working on creating a repeating section and I want to set "Number of Items" between 1 and then reference another number field for the top limit. So the top number would be variable to the number field. So far, using the advanced editor and reference the number field does not limit it.
Is this possible? And if yes, how can I do it?
There are a couple of ways to handle this in Cognito Forms:
Include the camper registration fee of $60 for each camper as part of the repeating section. Then add a Price field for the multi-camper discount below the repeating section, using a calculation like =Campers.Count() > 1 ? (Campers.Count() - 1) * -30 : 0. You can hide this Price field or make it only appear when the discount is not zero. This would produce a receipt like:
Camper 1
James Philips $60.00
Camper 2
John Cartin $60.00
Camper 3
Parker Owens $60.00
Multi-Camper Discount ($60.00)
--------------------------------
Subtotal $120.00
You could also charge $30 for each camper and have a separate $30 registration fee that applies to each application. I definitely prefer the first option since it clearly identifies the discount on the receipt.
Long term, it sounds like you would benefit from being able to use the Index of the item in the repeating section within calculations. We are looking at ways to make additional information like this available to calculations. In the mean time, hopefully these suggestions will meet your needs.
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.
Best Answer
Range limits, include repeating section quantity limits, can use calculations in Cognito Forms.
The best way to show this is just to provide an example of a form where this is working. Here is a link to a form where you can enter minimum and maximum limit amounts, which immediately apply as range limits on the repeating section.
Form with calculated repeating section limits https://www.cognitoforms.com/ThomasFamily/RepeatingSectionLimits
Shared template for this form https://www.cognitoforms.com/templates/shared/ThomasFamily/RepeatingSectionLimits