Correlate prices to items, and have them total at end of form?

  • Chrouton
    Asked on November 20, 2017 at 9:14 AM

    Hello:


    Our company using JotForm as an order form.  Currently we are going to launch with no pricing, just a way for people to choose what they want us to process.  It would be GREAT if we could correlate pricing to each item, and based off of the quantity they pick in the drop down, the total would be calculated.  


    Is that possible with our current set up and layout?


    https://form.jotform.com/73197001317147


    Thanks!

  • Elton Support Team Lead
    Replied on November 20, 2017 at 11:34 AM

    It is possible to perform calculation out of the field values in your form. Here's a guide: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

    However, if you want to collect payments and process it into a payment gateway like Paypal, you just have to add Paypal payment field to your form. In the payment window, you can create the products you want, add quantities, tax, coupons and etc. It comes with total calculation too. Guide: https://www.jotform.com/help/391-How-to-Integrate-Form-with-Paypal

    If you need further assistance, please let us know.


  • Chrouton
    Replied on November 20, 2017 at 12:10 PM

    Thank you for your reply.  I read through, and watched the videos but I'm still a bit confused on how this apply with my current forms set up.  

    For instance, in the example below we would need each column to have a different price associated with it, and that price to change based off of the quantity chosen from the drop down.  The combined total would then calculate under the section.

    i.e.

    Acai column one ("46oz Bottle...") would have $13.38 associated with it.  If someone chose a quantity of (2), it would calculate at the bottom of that section as $26.76.  

    Acai column 2 ("Case 6/46oz bottles") would have $80.25 associated with it.  If someone chose a quantity of say 3, it would calculate at the bottom of that section as $240.75.

    If the person placing the order, placed from both columns, they would combine at the bottom as one total.  In the above example(s), it would total at $321.00.

    Hope this makes sense... And hope we can do this without having to redo the entire current layout.

    Correlate prices to items, and have them total at end of form? Image 10


    Thank you!!!


  • Elton Support Team Lead
    Replied on November 20, 2017 at 1:07 PM

    I assume each of the fruits has different pricing? If yes then it would require a lot of calculations but still doable.

    Here's a demo: https://form.jotform.com/73234952070958I added calculations on Acai and Apple only.

    Feel free to clone this form so you can check the calculations.

    So here's how to do it.

    1. Add form calculation widget to your form. You can label it "Acai subtotal" as an example.

    2. To get the Acai total, you have to use the following formula in the Acai calculation field.

    (first_column_price * first_column_field) + (second_column_price * second_column_field)

    Here's a visual guide:

    Correlate prices to items, and have them total at end of form? Image 1 Screenshot 20

    3. Repeat the same calculation in the next product.

    And to get the final total, just add another calculation widget and sum the subtotals.

    If you still need clarifications, let us know.


  • Chrouton
    Replied on November 22, 2017 at 3:09 PM

    We would only want a "Total" to show, at the bottom of the order form on the last page.  Therefore all of the products selected, from all of the separate input tables, would need to add up together and show in the "Total".

     

    Also; we would not want the subtotals to be visible.  The form itself would look the same as it does now, but simply have a "Total" at the end, which would be sum of all products chosen through the form.

     

    Please let me know if you need me to further clarify.

     


    Thanks!

  • jonathan
    Replied on November 22, 2017 at 3:39 PM

    You can sum up each of the calculations (via the calculation widget) of the table (see previous instruction of EltonCris on how to use the Calculation widget) using another Calculation widget.

    Just put the Calculation widget (Total) at the last page.

    You can integrate this as well to payment field i.e. Paypal. Check the user guide: 

    How to Pass a Calculation to a Payment Field

    Let us know if you need further assistance.



  • Chrouton
    Replied on November 22, 2017 at 3:43 PM
    We would only want a "Total" to show, at the bottom of the order form on the last page. Therefore all of the products selected, from all of the separate input tables, would need to add up together and show in the "Total".
    Also; we would not want the subtotals to be visible. The form itself would look the same as it does now, but simply have a "Total" at the end, which would be sum of all products chosen through the form.
    Please let me know if you need me to further clarify.
    Thanks!
    ...
  • jonathan
    Replied on November 22, 2017 at 3:43 PM

    It will be much simpler to do also if you will assign calculation values to the items in the table.

    Check this guide: How to Perform Form Calculation in the Matrix Field

    So at the end, all you need to do is to summarize all the calculation widget for the Total.


  • Chrouton
    Replied on November 27, 2017 at 11:59 AM

    We are so confused!  I've tried all of these reccomendations and still can't figure it out. 

     

    Can you please set up the first two input tables ("Dr. Smoothie 100% Crushed Fruit Puree" & "Dr. Smoothie Organic Puree")  with generic pricing ($10.00 for column 1 "46oz Bottle…" & $50.00 for column 2 "Case…") so we can see how you did it and copy those calculations to complete the form?

     

    Please keep in mind that we would only want a total amount at the end of the form, after the Input Table titled "Modern Oats Oatmeal - 12ct".

     

    Here's the current form: https://www.jotform.com/build/73246215917155

     


    THANK YOU for your help!  If we can figure this out it will be lifechanging for our team and customers.

  • Chrouton
    Replied on November 27, 2017 at 12:00 PM

    Please keep in mind that if someone selected "2" from column one, it would have to multiply the $10.00 it by 2.  And so forth for whatever quantity is chosen, for either column.  Hope that makes sense!

  • Elton Support Team Lead
    Replied on November 27, 2017 at 12:29 PM

    In response to your previous concern about the subtotal, it was only showed for demo purposes. You can hide them in the form builder (Right-click the field > Hide field). The subtotal gets the total amount of each input table. This method makes it easier for the calculations to maintain later on. Consolidating all the calculation in just a single form calculation field might possibly break the calculation formula or you will possibly encounter lags along the way as you add operations.

    So for clarifications, here's what you need to do.

    1. Add a form calculation widget that calculates the field "Dr. Smoothie 100% Crushed Fruit Puree". You can name is as "Crushed Fruit Puree Subtotal" like the following.

    Correlate prices to items, and have them total at end of form? Image 1 Screenshot 30

    In the calculation wizard, since you have the same pricing for each column, 10 for the first and 50 for the second, do the following.

    a. Get all the first column quantity and add them then multiply them by 10.

    b. Get all the second column quantity, add them then multiply by 50.

    Here's the formula:

    ((sum_first_column_quantity)*10) + ((sum_second_column_quantity)*50)

    Correlate prices to items, and have them total at end of form? Image 2 Screenshot 41

    2. Do the same for the field Dr. Smoothie Organic Puree. Add another form calculation widget then name it "Organic Puree Subtotal". Follow the same steps for creating the calculation formula.

    3. To get the final total, add another form calculation widget on the last page of your form. In the calculation wizard, sum the 2 subtotal field.

    Hope this makes sense.

  • Chrouton
    Replied on November 27, 2017 at 1:43 PM
    This was not what I was looking for… I don't know how else I can ask the question… Does JotForm assist over the phone? Please let me know either way. If not; I'll try and retype or re-ask my question.
    Thanks
    ...
  • David JotForm Support
    Replied on November 27, 2017 at 2:52 PM

    I believe the calculation my colleague referenced would be the correct way to set up your total calculation.  Though using an input table causes the calculation to be much more complex than it would be if you used regular drop down fields instead. 

    If you use regular drop down fields, you can assign calculation values to the quantities in your drop down:

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

    Then simply use the field in your calculation and the assigned value will be used:

    https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

    If you use an input table, it would require performing further calculations to get the total quantities and then multiple those quantities by their cost.