Calculate Values in the Input Table Through Condition

Last Update: March 8, 2017

Calculation is one of the basic 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:



Here's a sample form with this condition:

If you 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 questions, feel free to leave comments below.


1 Comment...


   
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


Send Comment