Is there any widget to calculate matrix fields

  • BruceDavis
    Asked on September 22, 2016 at 2:31 AM

    And can calculate total weight and cubic meters

    Jotform Thread 938905 Screenshot
  • Rose
    Replied on September 22, 2016 at 3:59 AM

    Thank you for contacting us.

    You can use matrix field to collect inputs from your user and form calculation to calculate wanted result for items. 

    This is a sample form for your evaluation. Feel free to clone it. 

    https://form.jotform.com/62651506723959

    Following guidance can help you to clone above form. 

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

    I'm going to also show you what I did step by step here below. 

    1. Go to "Survey Field" on Builder, "Drag & Drop" Matrix

    Is there any widget to calculate matrix fields Image 1 Screenshot 60

    2. Configure it according to how you would like to see it. To do that; Click the Matrix field on the form>> preferences>>Fields. You can see my configuration here below. 

    Is there any widget to calculate matrix fields Image 2 Screenshot 71
    Is there any widget to calculate matrix fields Image 3 Screenshot 82

    3. Now, the time is to add & configure form calculation.  You need to drop 2 form calculation for each item. One is to calculate total weight and the other one is to calculate cubic meter.  To add form calculation; Click "More Fields", Search "Form Calculation" and Drag&Drop to the form. 

    Is there any widget to calculate matrix fields Image 4 Screenshot 93

    4. This guidances can assist you about how to set up your calculation. However, If you are stuck somewhere, do not hesitate to contact us. 

    https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field

    https://www.jotform.com/help/259-How-to-Perform-Calculation-in-the-Form


    This is also the screen shot of how you will see the result after above configuration. 

    Is there any widget to calculate matrix fields Image 5 Screenshot 104

    Hope, these would help you about your concern but please let us know if you need further assistance by our side. We would be pleased to help you. 

  • BruceDavis
    Replied on September 22, 2016 at 6:36 PM

    Many thanks for the explanation and the clone. Where I am getting into trouble is with the calculation. For example, what I'm trying to do is have a total weight for all items ? and a total cubic meterage for all items ?

    Cheers Bruce

  • David JotForm Support Manager
    Replied on September 22, 2016 at 7:45 PM

    You need to include all of the items in the formula, just click on the wand icon and the calculation wizard will popup, example:

    Is there any widget to calculate matrix fields Image 1 Screenshot 30

    Same goes for the other calculation field. Here is my cloned version: https://form.jotform.com/62657826624970 

    Is there any widget to calculate matrix fields Image 2 Screenshot 41

    Let us know if you need more help.

  • BruceDavis
    Replied on September 24, 2016 at 6:31 AM

    Hi Thanks for your help

    The weight calculation is all good. However the cubic meterage is not calculating when there is more than one item. i.e when there is 2 items it is only calculating as 1

     

    Also as I have already built a form. Is it possible to include the clone onto this form or do I need to start a new form from scratch and build around the clone ?

    Kind Regards

    Bruce

     

  • Elton Support Team Lead
    Replied on September 24, 2016 at 12:10 PM

    Hi Bruce, 

    I believe you are the same user asking the same question on this thread https://www.jotform.com/answers/940891. I have already responded to it, kindly check.

    Thank you!