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 do I perform calculations and display results within a matrix field?

    Asked by IDOEWebmaster on June 22, 2016 at 02:20 PM

    How do I multiply the value of column 1 and column 2 and show the result value in the column 3 of the matrix table?

    Thanks.



    This is a re-post of a comment on How to Perform Form Calculation in the Matrix Field?

    table matrix table matrix calculations spreadsheet
  • Profile Image
    JotForm Support

    Answered by Boris on June 22, 2016 at 04:16 PM

    If you want to perform calculations directly within a matrix, such as you would in an Excel spreadsheet, you will have to use our Spreadsheet widget instead of the Matrix field:

    https://www.jotform.com/help/252-How-to-Add-a-Widget-to-your-Form

    The Spreadsheet widget can perform calculations similar to those of traditional Excel spreadsheets or Google Spreadsheets:

    Upon adding the Spreadsheet widget to your form, please add your desired calculations as "Default values" of the widget. If you need any further assistance in setting up the conditions, please let us know and we will be happy to help.