Help adding up multiple values at same time using calculation

  • Profile Image
    HandPicked212
    Asked on March 16, 2017 at 04:42 PM

    I need to add multiple values up a the same time on a form. what is the best way to go about this?

    https://form.jotform.us/70736215073149

     

    In my form I am working on I have it currently configured to add up the total monetary value of each item but I also would like to have totals for "number of beads" and "number of bars"

     

    Thank you for your help!

    Melanie

     

  • Profile Image
    EltonCris
    Answered on March 16, 2017 at 07:38 PM

    You can't achieve that with the payment tools.

    You can only achieve this when you use regular checkboxes as the product field.

    Then perform calculation on the field by following this guide http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form. You can use multiple calculation widgets to get the total in each product category.

    If you want to pass the total calculation field to the payment field after, follow this guide http://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field

    If you need further assistance, let us know.

  • Profile Image
    HandPicked212
    Answered on March 17, 2017 at 09:16 AM

    thank you Elton,

    By using check boxes thought can't you only check each box once? what if a boxes value needed to be added up 3 times?  (like if there were 3 letter As that needed to be counted)

  • Profile Image
    BDAVID
    Answered on March 17, 2017 at 12:49 PM

    If you want to select that product 3 times, you simply need to setup a quantity option: https://www.jotform.com/help/225-How-to-Add-Options-to-Payment-Forms 

    I checked your form, and it looks like you have set it up in your payment field already:

    Let us know if you need more help.