Calculate Values in the Input Table Through Condition

November 6, 2021

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.
  1. Click SETTINGS at the top of the FORM BUILDER. On the left side, select CONDITIONS then UPDATE / CALCULATE FIELD.
  1. 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

  1. 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.

Was this guide helpful?
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:

Support Forum: https://www.jotform.com/answers/

Contact Jotform Support: https://www.jotform.com/contact/

Send Comment:

Jotform Avatar
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Comments: