How to Calculate Values in the Input Table using Conditional Logic

Jotform makes it easy to run calculations inside an Input Table using Conditional Logic. With this setup, you can total values, score responses, or generate results based on user input, then display the output directly in the table. This approach keeps everything organized in one place and eliminates manual calculations, helping you collect cleaner data and work faster.

To perform calculations inside an Input Table, you’ll need to use the Update/Calculate Field condition. This is the only conditional logic type that supports math operations, so other condition types like Show/Hide or Enable/Require won’t work for calculations.

Adding and Setting Up the Input Table

Before applying any calculation logic, you’ll first need to add an Input Table to your form. This field will be used to capture the student’s Quiz, Midterm, and Final scores, which will later be processed to compute the average grade for each subject. This is how it’s done:

1. In Form Builder, click on Add Element on the left side of the page.

2. Then, in the Form Elements menu that opens, under the Basic tab, scroll down to the Survey Elements section and click on the Input Table. Or, just drag and drop it to where you want it to be on your form.

3. Next, click on the Gear icon of the Input Table you’ve just added.
4. Then, under the Fields tab, in the Input Type section, select the Numeric Text Box.

5. Now, scroll down and set up the Rows and Columns based on the information you want to collect, and you’re done.

For this example, Rows represent Subjects and Columns represent Quiz, Midterm, Final, and Average scores.

Setting Up Conditional Logic to Calculate Values

Now that your Input Table is ready, the next step is to apply Conditional Logic to compute the values. As mentioned earlier, calculations in Jotform are handled through the Update/Calculate Field condition—this is the only condition type capable of performing math in forms. Here’s how:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2. Then, in the menu on the left side of the page, click on Conditions.
3. Next, in the New Condition list, click on the Update/Calculate field.

4. Now, set up the condition like this:
   • IF Input Table
   • State is Filled
   • DO Calculate Field Value
5. Next, in the Formula Keypad section on the right side of the window, click on the Add Field button and select Input Table field from the list of fields.

6. Then, put a check in the box for the columns and rows that you want to calculate. For example, we’re going to get the Prelims, Midterm, Final of the Mathematics Average Score.
7. Now, click on Done.

8. Next, set up your formula like this to get the average score of the Mathematic from Prelims, Midterm and Finals to the Average Score Column.

9. Then, in the Summary dropdown, select the Input Table field and click on Average Score in the Mathematics row so that the total will be computed or calculated here.
10. Finally, click on Save.

You’re all set. Curious how it works on a live form? Check out this demo. If you also want to perform calculations in an Input Table that uses checkboxes or radio buttons. Our guide on How to Perform Calculations with Input Table has more details about that.