JotForm User Guide / Form Calculations /

Calculate Values in the Input Table Through Condition

Calculate Values in the Input Table Through Condition

Calculation is one of the advanced features of JotForm. You can perform calculations either by using the FORM CALCULATION WIDGET or through the UPDATE / CALCULATE FIELD condition.

In this guide, you'll learn how to perform calculation in the INPUT TABLE field (formerly known as the MATRIX FIELD) through the UPDATE / CALCULATE FIELD Condition and output the result on a text box field within the same INPUT TABLE field.

Example:

Here's how:

1. Add the INPUT TABLE field to your form.

2. Click SETTINGS at the top of the FORM BUILDER. On the left side, select CONDITIONS then UPDATE / CALCULATE FIELD.

3. Create a condition that calculates the field whenever the INPUT TABLE field is filled.

Example:

IF Input Table IS FILLED, then DO calculate a field's value

4. Click the ADD FIELD button to add the fields you want to calculate on the INPUT TABLE field.

Example: You can select the fields from the first 4 columns then add them, and then output the result on the 5th column.

You can try the calculation conditions on this form: https://www.jotform.com/70280891026959. We strongly suggest you clone this form so you can check and review the conditions.

If you also want to perform calculation on the INPUT TABLE field with checkbox or radio button input types, refer to this guide: How to Perform Form Calculation in the Matrix Field 

If you have any questions, feel free to leave comments below.

Contact Support:
Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:
Contact JotForm Support: https://www.jotform.com/contact/

Send Comment

8 Comments...

  • primoatl

    Is there a way that you can input a different name in a row or column? The problem I'm running into is the name needs to be able to change on the first row or column and the numbers will need to be calculated.

  • a.baena

    Hello, is it possible to "mark" checkbox buttons using calculation or pre-loading them by default? I would need to use the calculation values of each cell by default when the form is loaded.

    Is there any other way of using the calculation values for ALL the fields? -Radio buttons only allow one value per row, and text box or dropdown would only work if a number is filled (and I need to use only calculation values pre-configured.

    Also tried to copy the value of a marked check-box to a cell in the table and didn't work.

    Thank you very much,

  • Doguk

    I have created an input table, with calculation values, but the last column in the table is not passing the correct value to the Form Calculation Widget - instead of 6.5, 5 is being passed

  • NippersD

    in v4, how do you access the individual sub-fields from the Input Table, to be applied in the Conditions (as how it used to work, in your example above)? All it does now is have a single selection "All?" which is not useful

  • Yalmin

    Hello Jotform Support

    In the case i have multi choice question, how can i use different forms or questions depending on the select answer (on the multi choice question)

    For example:

    Gender?
    Answer: a) Man b) Woman

    If the Answer is a) Man - I would like to ask in the next page the following next 2 questions:
    a) How often do you drink? b) Where do you like to travel.

    but if Answer is b) Woman I will ask the next 2 questions:
    a) How often do you going to the mall? b) Where do you like to eat?

    Please advise.

  • melkyherlina

    Hi team,
    It seems like my calculation is working fine but when i tested it again, it all went blank. Why? It was working fine.

  • nueratrend

    I need to use this form to calculate prices and bill customers. Is this something that you can do?

  • MPParker

    I try to follow this - but your example looks nothing like the form I'm trying to create. The left sidebar is completely different!
    My sidebar is "Form Elements"
    So these instructions don't help me!