What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How Can I Calculate the Values from Columns in a Table?

    Asked by armskite on January 21, 2016 at 08:19 PM

    I am trying to create a table where users fill in three columns of information. The first two columns are alphanumeric and the third is numeric.I want the user to be able to add rows if necessary and to calculate a sum for the final numeric column. Is that doable and if so, how?

     

    Thank you,


    Anita

    table creating a create Numeric fill
  • Profile Image
    JotForm Support

    Answered by mert on January 22, 2016 at 03:56 AM

    Hi Anita,

    To sum up, you need to use one "Matrix" field, one "Text Box" field and set "Update/Calculate Field" condition. However, users can't add extra rows and the result must be shown on "Text Box" field not in the 3rd column in this workaround.

     

    To do that,

    1) Add one "Matrix" field and set it to have 1 row and 2 columns.

     

    2) Add one "Text Box" field.

    3) Set the "Update/Calculate Field" condition to get the sum of 2. columns in the "Matrix" field.

     

    Below, you can check the example form:

    https://form.jotform.com/60211475374956

     

    If you need extra information, please do let us know.

    Thanks.