Calculate columns on the Input Table element

  • ISPOInternational
    Asked on March 26, 2024 at 4:45 AM


    Thank you very much for your reply. I have one more question, is there a way for the calculation to be done within the table, meaning that the last column is the sum of the previous 2 columns?

  • Jeric JotForm Support
    Replied on March 26, 2024 at 5:38 AM

    Hi ISPOInternational,

    Thanks for reaching out to Jotform Support. Yes, it's possible through Update/Calculate Field Conditional Logic. Make sure that all the columns are in Number Type. Let me show you how:

    First, I created a simple table:

    Calculate columns on the Input Table element Image 1 Screenshot 40
    Next, create the Update/Calculate Field Conditional logic:

    1. On the Form Builder, click on Settings.
    2. On the Menu on the left side, click on Conditions.
    3. Click on Update/Calculate Field.Calculate columns on the Input Table element Image 2 Screenshot 51
    4. Next, create the condition. You can click on +Add Field button and you'll asked to select the cell to include in the calculation.
    5. After that, Click on Save. Calculate columns on the Input Table element Image 3 Screenshot 62

    Here's demo form I created. Please note that I just created the condition for the first row. So if you have multiple rows, make sure to create condition for each of them.

    Give it a try and let us know if you need more help.