Cognito-forms – Cognito Forms: Referencing a field in a repeating section

There are a couple of ways to handle this in Cognito Forms:

1. 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
   

2. 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.

I am a developer for Cognito Forms.

You are very close to getting the calculation to work, AddDays takes an integer value and the value and what you were generating is a decimal value. You will need to add a little extra code to your Due Date calculation to get it running correctly.

=DateTime.Today.AddDays(Int32(CalculatedTime))

One other change I would make to your calculation in the CalculatedTime field would be to remove the quotation marks (") from around the numebrs, so your calculation looks like this:

=ProjectType = "Flyer: Up to 30 Products" ? 7 : ProjectType = "Flyer: Up to 60 Products" ? 12 : ProjectType = "Flyer: 60+ Products" ? 18 : 7