Separating information in the Payment Wizard

  • Profile Image
    ClintonvilleQuest
    Asked 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?

    -------------

    Example Form:

    Name:

    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!

    Julie

  • Profile Image
    david
    Answered on February 18, 2016 at 02:52 PM

    You can assign calculation values to your options:

    http://www.jotform.com/help/301-How-to-Assign-Calculation-Value

    Then total them up in a calculation field:

    http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    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.