- ClintonvilleQuestAsked on February 18, 2016 at 11:56 AM
I would like to be able to separate the information in the payment wizard when it is exported as an excel file. Currently, this is the information I have (this is a registration form for an event). I would also like to have some of the information automatically populated from responses earlier on in the form.
The information we gather in the form includes age, which determines the cost for each participant. Is it possible for the payment wizard (or something else) to populate a number based on these answers?
Age: (drop down with options, "5-17", "18-25", "26-35", "36+")
There are four of these entries, so a total of up to four teammates possible. We also want to allow people to order tshirts (one design, but 5 different sizes). And finally, we have coupon codes to include.
Can we have the payment wizard automatically populate a total cost based on the ages they fill in above? And we want the excel sheet to have SEPARATE columns for:
# Adults, # Children, Coupon Code Used, #Small Tshirts, # Medium Tshirts, #Large Tshirts
And one last thing (sorry) - we do not actually COLLECT money on this site, just provide a total.
Thanks for any advice!
- JotForm SupportdavidAnswered on February 18, 2016 at 02:52 PM
You can assign calculation values to your options:
Then total them up in a calculation field:
Since you will not be using a payment field, each field would be in their own separate column when exported to a spreadsheet. Since you do not need to collect payments, you would not need to forward the total to a payment field.