Create a Matrix row that automatically computes for the total after input

  • atecotankco
    Asked on September 28, 2015 at 4:14 PM

    dear sir

    we need automatic MATRIX ROW

    example 

    height : 12 mt

    each floow : 2 mt

    total floor : 12 /2 = 6 floor

    we want auromatic matrix 6 ROW

     

  • Mike_G JotForm Support
    Replied on September 28, 2015 at 5:26 PM

    To my understanding, this is what you're trying to accomplish

    Create a Matrix row that automatically computes for the total after input Image 1 Screenshot 70

    Here's what you can do to achieve that:

    First: Add Matrix field to your form

    Create a Matrix row that automatically computes for the total after input Image 2 Screenshot 81

    Second, create row and column headers

    Create a Matrix row that automatically computes for the total after input Image 3 Screenshot 92

    Lastly, create the condition to perform equation. Do not forget to save the condition you have created before saving the changes you made to your form.

    Create a Matrix row that automatically computes for the total after input Image 4 Screenshot 103

    Create a Matrix row that automatically computes for the total after input Image 5 Screenshot 114

    Create a Matrix row that automatically computes for the total after input Image 6 Screenshot 125

    I hope this helps. Let us know if you need any further assistance. Thank you. 

  • jonathan
    Replied on September 28, 2015 at 9:50 PM

    Asked by atecotankco on September 28, 2015 at 05:46 PM

    dear mike

     

    we want thank you for emaıl , this is ı need second time, but thank you.

    ıf we calculate 6 floor

     

    ı need this rows

     

    FLOOR-1

    FLOOR-2

    FLOOR-3

    FLOOR-4

    FLOOR-5

    FLOOR-6

     

    IF WE CALCULATE 5 FLOORS, I WANT ONLY 5 ROWS

     

  • BJoanna
    Replied on September 29, 2015 at 4:18 AM

    If I understood you correctly you want to calculate Floor Total for all Floors. 

    To achieve that you will need to add matrix table with 6 rows and set calculation for each row like my colleague Mike mentioned on previous post. Then you need to add calculation widget to your form and calculate Total Floor of each row to get final calculation.

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

    I have set conditions in my demo form like this.

    Create a Matrix row that automatically computes for the total after input Image 1 Screenshot 30

    Create a Matrix row that automatically computes for the total after input Image 2 Screenshot 41

    Here is my demo form: http://form.jotformpro.com/form/52712018668962? 

    Feel free to clone it. 

    Inside of this guide you can find out How to perform form calculation using the "Matrix Field".

    If you want to achieve something else please explain in more details what you are trying to achieve.

    Let us know if you need further assistance.