Product purchase and donation in same form

  • templesolel
    Asked on November 12, 2015 at 2:01 PM

    Help

    my calculations are not showing up in the total box

    trying to do 3 things in one form

    1. option to purchase dinners

    2. option to just rsvp without a payment

    3. option to make a donation with a dinner purchase or without a dinner purchase

  • Kevin Support Team Lead
    Replied on November 12, 2015 at 6:00 PM

    Hello,

    Thank you for contacting us.

    I've checked your form and I found a way to do it, follow the steps below  : 

    1. First, you have to remove the Calculation Values for each Dinner Option for Hanuplex, click on the field, next , cilck on the properties icon and then click on Edit Properties.

    Product purchase and donation in same form Image 1 Screenshot 140

    2. A popup window will appear , there you have to change the current values for Options and Calculation Values , removing the numbers inside the parenthesis and the parenthesis , the Calculation Values must be empty.

    Product purchase and donation in same form Image 2 Screenshot 151

    3. Now, you should calculate the value for each option and then pass the value to the calculation field widget, i.e for the first option Family Dinner Adult @ $18 per person , you need to add the condition to calculate the value depending on the selection, do it as the image below : 

    a). Click on the field and then on the conditions icon : 

    Product purchase and donation in same form Image 3 Screenshot 162

    b). Click on the New Condition button and then on the Update/Calculate Field option  :

    Product purchase and donation in same form Image 4 Screenshot 173 

    Product purchase and donation in same form Image 5 Screenshot 184

    c). Now you must add the field you will calculate, in this case, the Family Dinner Adult ($18 per person ) :

    Product purchase and donation in same form Image 6 Screenshot 195

    Product purchase and donation in same form Image 7 Screenshot 206

    d). Now your condition should look like this: 

    Product purchase and donation in same form Image 8 Screenshot 217

    Do note, here I'm multiplying the selected value by 18, due to the individual amount for Family Dinner Adult is $18 , for the other two conditions you must multiply by 11 (Family Dinner Child $11 per child) and by 25 (Adult Dinner $25 per person).

    4. Add a Calculation field and here you will take the values of the three calculation fields of each option above, click on the wizard icon  : 

    Product purchase and donation in same form Image 9 Screenshot 228

    5. Now, simply sum the values of each individual total : 

    Product purchase and donation in same form Image 10 Screenshot 239

    6. Open the wizard of the payment field and in the Get Amount From field select Total : 

    Product purchase and donation in same form Image 11 Screenshot 2410

    Now, with the donation you can add a field :

    Product purchase and donation in same form Image 12 Screenshot 2511

    And add it to the calculation in the Total : 

    Product purchase and donation in same form Image 13 Screenshot 2612

    You can set the calculation field as hidden , you can take a look to my sample form and you can clone it : 

    https://form.jotform.com/53156074982966

    I hope that helps.

    If you have more questions, feel free to contact us, we will be glad to help you.

    Regards.

     

  • templesolel
    Replied on November 12, 2015 at 6:46 PM
    Please review my form, I can not seem to get rid of an amount in the payment box
    [cid:9C54D0EF-5A8B-4F21-A253-972F1444BF05]
    Beth Cates | Graphic Design
    Temple Solel | 3575 Manchester Avenue | Cardiff by the Sea, CA 92007
    760.334.1457 | templesolel.net
    ...
  • Kevin Support Team Lead
    Replied on November 12, 2015 at 8:16 PM

    Hi again,

    Add three Calculation fields , one for each select : 

    Product purchase and donation in same form Image 1 Screenshot 50

    You can rename them as I did , now change the output for each condition : 

    1. For Family Dinner Adult @ $18 per person the output should be Total Family Dinner Adult

    Product purchase and donation in same form Image 2 Screenshot 61

    2. For Family Dinner Child 3+ @ $11 per child the output should be Total Family Dinner Child

    Product purchase and donation in same form Image 3 Screenshot 72

    3. For Adult Dinner @ $25 per person the output should be Total Adult Dinner

    Product purchase and donation in same form Image 4 Screenshot 83

    Now, change the operation on the Total , replace the current field with each Total : 

    Total Family Dinner Adult +  Total Family Dinner Child + Total Adult Dinner 

    I hope that helps.

    Let us know if you have more questions.

  • templesolel
    Replied on November 13, 2015 at 4:45 PM
    I put in a calculation field for each dinner (total of 3), but the "output" dialogue box is not the same as you have in your sample below. See my screen shot. Then I am still getting a huge total in my "live" form. Help!
    [cid:2BB87D71-A324-4AA3-A8AC-B328874309A8]
    Beth Cates | Graphic Design
    Temple Solel | 3575 Manchester Avenue | Cardiff by the Sea, CA 92007
    760.334.1457 | templesolel.net[cid:61327854-B0E6-48A3-80AA-BFF0C5557E49]
    ...
  • Kevin Support Team Lead
    Replied on November 13, 2015 at 5:34 PM

    You must chage the Output field as the images above.

    1. For Family Dinner Adult @ $18 per person the output should be Total Family Dinner Adult.

    2. For Family Dinner Child 3+ @ $11 per child the output should be Total Family Dinner Child.

    3. For Adult Dinner @ $25 per person the output should be Total Adult Dinner.

    You are currently passing the result to the same field, change it and the calculation will work, also you must clear the Calculation Values for each Select, clear the value for the second select : 

    Product purchase and donation in same form Image 1 Screenshot 20

    Also, you can clone my form and adjust it to your needs, here is the link to my Form : 

    https://form.jotform.com/53156074982966

    Here is the guide to clone a Form : 

    http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    Thanks.

     

  • templesolel
    Replied on November 16, 2015 at 2:46 PM
    OK, I cloned your form as I just could not get the dollars out of the total box.
    BUT, when I test the form, the donation amount does not show up in the total.
    https://form.jotform.com/53195217300952
    Beth Cates | Graphic Design
    Temple Solel | 3575 Manchester Avenue | Cardiff by the Sea, CA 92007
    760.334.1457 | templesolel.net
    ...
  • Kevin Support Team Lead
    Replied on November 16, 2015 at 4:45 PM

    Hi,

    You have to add the donation amount to the total :

    Product purchase and donation in same form Image 1 Screenshot 40

    Product purchase and donation in same form Image 2 Screenshot 51

    Now the donation amount will be added to the total, also you should remove the Donation Amount field on the Form, since the correct field is Yes, I would like to help sponsor Hanuplex , I just added the Donation Amount for test : 

    Product purchase and donation in same form Image 3 Screenshot 62

    Here is my sample Form :

    https://form.jotform.com/53156074982966

    Let us know if it works.

    Thanks.

     
  • templesolel
    Replied on November 16, 2015 at 6:45 PM
    Yeah!!
    My form is finally working, this was the the most complicated form yet that I have had to create, I thank you all for your help.
    I would like to save the emails on how to reconstruct this form if I need it in the future. When I go to print, the pictures nor the complete text prints. What is the best way to reproduce the instructions? I guess I can save the actual emails, but sometimes I work better from the printed page.
    thanks
    Beth Cates | Graphic Design
    Temple Solel | 3575 Manchester Avenue | Cardiff by the Sea, CA 92007
    760.334.1457 | templesolel.net
    ...
  • Kevin Support Team Lead
    Replied on November 16, 2015 at 9:15 PM

    Hi,

    You're welcome.

    I'm glad to know your Form is working fine now,in regards to print the instructions, you should acces to this link on your Web Browsert and then use some of these Keyboard Shortcuts :

    Windows : Ctrl + P

    Mac : Cmd + P

    Now, you will be able to download a PDF file with the images and texts of the instructions on this thread.

    The link to this thread :

    http://www.jotform.com/answers/703593

    I hope that helps.

    If you have more questions, feel free to contact us.

    Regards.