Can I create a matrix table with formulas ? eg totals of other columns ?

  • Profile Image
    dycnetballweb
    Asked 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

  • Profile Image
    dycnetballweb
    Answered 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
    Shadae
    Answered 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
    dycnetballweb
    Answered 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
    Shadae
    Answered 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.