What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Separating information in the Payment WizardAsked by ClintonvilleQuest 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!
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.