Calculate Values in the Input Table Through Condition

Last Update: May 16, 2017

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.


3 Comments...


   
MPParker (February 06, 2017 at 08:53 PM)

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!

View Answer


   
nueratrend (May 01, 2017 at 09:32 PM)

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

View Answer


   
melkyherlina (July 22, 2017 at 03:33 AM)

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.

View Answer


Send Comment