I have created a simple application to bulk register youth for an event. The Adult leader fills in their info in the Parent Form, the parent form data is copied into each subform entry where the adult lists each youth that is attending by adding a new row for each.
I need to produce a Success email to that adult leader that has a total cost reminder. Basically multiplying the number of rows submitted by $140.
I have created a hidden field for each youth that pre-populates with 140 - so I would assume I could script the form to sum the "Cost_Per" column into the Parent form's "Total_Cost" field and then publish that value into the email.
Any help would be appreciated!