Calculate Values in the Input Table Through Condition

September 9, 2022

Form Calculation is one of the advanced features of Jotform. You can perform calculations using the Form Calculation Widget or the Update/Calculate Field condition.

In this guide, you’ll learn how to perform calculations in the Input Table field using the Conditional Logic and output the result on a text box field within the same Input Table field.

Here’s a demo form you can check: https://www.jotform.com/222510651473045. The result would look like the below image:

input-table-calculation-example

Adding the Input Table Field

First, you should have the Input Table field in the form. Here’s how you can add that:

  1. In the Form Builder, click the Add Form Element button.
  2. Scroll down to Survey Elements.
  3. Click the Input Table field to add. You can also drag and drop it into the form.
jotform-form-builder-input-table-field
  1. Set it up according to your preferred columns and rows. Here’s an example based on the above demo form:
jotform-form-builder-input-table-field-settings

Now that you have the Input Table ready let’s set up the conditional logic to calculate the values.

Calculating the Values in Input Table With Condition

In the above form, the 1st, 2nd, 3rd, and 4th columns are summed up into the 5th column labeled Total. Here’s how you can do that:

  1. Go to the Settings tab.
  2. Click Conditions on the left panel.
  3. Choose Update/Calculate Field from the logic options.
jotform-conditions-update-calculate-field
  1. Create your conditional logic according to the below GIF:
form-builder-condition-update-calculate

Repeat the same step for the other rows.

If you also want to perform calculations on the Input Table field with a checkbox or radio button input types, refer to this guide: How to Perform Form Calculation in the Matrix Field.

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:

  • JLA Purchasing
  • AFC INDUS
  • Ashika Ganesh