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

    Can the total column be able to calculate totals of each description?

    Asked by PeteSmithiesMedia on May 30, 2017 at 12:13 AM
    Hi there,
    Many thanks for your response.
    There are some specific things that I would like to be able to achieve on the matrix (Bale information) part of the form
    http://www.kellswool.co.nz/online-forms.html
    i.e.
    Could the descriptions convert entries to capital letters irrespective of the case that the user inputs
    Can the total column be able to calculate totals of each description?
    Can I add a grand total box below the total column that totals the “total” fields?
    Thanks
    Pete
  • Profile Image

    Answered by PeteSmithiesMedia on May 30, 2017 at 12:16 AM

    I have been able to address the first requqest - i.e Auto capitalization. But not sure how to effect the rest? Pete

  • Profile Image
    JotForm Support

    Answered by BJoanna on May 30, 2017 at 02:17 AM

    Total column can be use to calculate total of each row. This can be achieved with Update/Calculate Field conditional logic. Inside of this guide you can find how to do it:

    Calculate Values in the Input Table Through Condition

    Also please check this guide, to find out how to calculate the grand total:

    How to Perform Form Calculation in the Matrix Field?

    Hope this will help. Let us know if you need further assistance.