I have a repeating section, that is for camp registration. This is pretty simple. The complexity arises in that each camper is counted by day and by family. For instance a single person is $00 for one day - a couple is $01 for a day, three people is $ 002 etc.

Then we also have an early bird discount of 10% for anyone paying and registering before June 1. From there we charge a late fee for anyone after June 1 the fee is fixed - meaning a flat fee.

We also have t-shirts and various other things on the form. I would love to have this calculate based on the number of people and the days they are staying. Then calculate the apparel order - that part again is easy. But from there adding the discount on registration fees only not on apparel or donations.

We would also like to have a pivot table sort - that shows us how many shirts in what size are ordered etc. Currently I have the item in a column , and then the sizes in another column - so if someone orders 2 t-shirts and three sweatshirts, we would like a place that shows us how 2 XL t-shirts are ordered and 1 l sweatshirt, 2 medium - etc.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.