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 I create a matrix table with formulas ? eg totals of other columns ?

    Asked by dycnetballweb on August 04, 2015 at 09:31 AM

    Can Jotforms matrixes be enhanced to allow adding totals to on one column ? Eg, I have a need to create an order form like the image below. The totals will be based on how many of each size is entered. Say I enter 2 for size 8 and 2 for size 10, the total will be 2 +2 * $25

     

    Currently the only way I can do this is with a enhanced PDF

    table create formulas matrix table
  • Profile Image

    Answered by dycnetballweb on August 04, 2015 at 09:49 AM

    Adding the example table for the question that I somehow couldn't add in the first post

     

  • Profile Image

    Answered by Shadae on August 04, 2015 at 12:11 PM

    Hi dycnetballweb,

    It is not possible to have calculations done from within the matrix field.

    We do however have a Spreadsheet widget that allows for calculations to be done.

    You can view  sample form with the spreadsheet form added here: http://www.jotformpro.com/form/50696022946965 

    The first five rows have been set for the total of A and B to be calculated in C.

    I hope this helps, please inform us if you need further assistance.

  • Profile Image

    Answered by dycnetballweb on August 04, 2015 at 02:01 PM

    Looks promising !

    Got a question, the column headers, A, B, C, ... are they editable to custom headings ?

  • Profile Image

    Answered by Shadae on August 04, 2015 at 02:26 PM

    Hi dycnetballweb,

    I am happy to hear that this may be a suitable option for you. Yes it is possible to change the heading of the spreadsheet by adding custom CSS in the widgets wizard.

    In the sample for I have changed the heading by adding the following code:

    #col_A, #col_B, #col_C{

       color: transparent;

       font-size: 1px;

    }

    #col_A:before, #col_B:before,#col_C:before {

        color: #FFF;

        font-size: 14px;

    }

    #col_A:before {

       content: "T-Shirts";

    }

     

    #col_B:before {

       content: "Hats";

    }

    #col_C:before {

       content: "Total";

    }

    You can view the sample for the see the changes: http://www.jotformpro.com/form/50696022946965 

    You can also place the word in the rows from within the default value in the widgets wizard. This is what is used for the first row of the form:

    a1 T-shirts

    b1 Hats

    c1 Total

    Please inform us if you need further assistance.