User Guide

 

Calculate Values in the Input Table Through Condition

Calculate Values in the Input Table Through Condition

Calculation is one of the advanced feature with JotForm. You can either perform calculation using the Form Calculation Widget or through Update/Calculate condition.

In this guide, you'll learn how to perform calculation in the input table field (formerly known as matrix field) through update/calculate 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 in your form



2. In the top toolbar, click the  Settings menu. On the left side, select Conditions then the Update/Calculate Field


3. Create a condition that calculates the field whenever the Input Table field is filled.

Example:

If Input Table is filled, Calculate a field's value



4. Then click the ADD FIELD button to add the fields you want to calculate from 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. Check the animation guide below:



You can try the calculation conditions on this form.
https://form.jotform.com/70280891026959. We strongly suggest to 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, here's a guide - How to Perform Form Calculation in the Matrix Field


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

Send Comment

3 Comments...

  • 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!