Calculations on Matrix Grid. When it will be implemented?

  • Profile Image
    flexgener
    Asked on November 18, 2013 at 04:24 PM

    Is there any chance that this feature will be added in the near future?

  • Profile Image
    ardy0689
    Answered on November 18, 2013 at 05:28 PM

    Hello, thanks for posting your inquiry.

    We do not have any updates yet with our development team concerning calculations on Matrix Tables. Although, this has been requested by some users already in the past but our development team will still have the say on this as they are busy with other projects. I could escalate this and request this as Feature Request on your behalf for another vote if you wish.

    The only workaround for now on this situation is to use the form's source code. After that you can create a script that calculates based on the values on the Matrix Grid and put it inside a hidden box that you dragged from the JotForm builder.

    If you need further assistance, please do not hesitate to ask. Thanks

  • Profile Image
    flexgener
    Answered on November 19, 2013 at 02:22 PM

    Thanks for your response.  I understand the process of exporting the source code, but am wondering if you can help build the script for the calculations.  Here's what I have so far: 

    http://form.jotform.co/form/33216353552853

    The calculations needed are in the Resource Evaluation section, I need a total count of the numbers entered in the row at the second to the last row, and the total count multiplied by 10 in the last row.

    Then a total number calculated in field, #input_31, divided by 10.

    Do you anticipate this could be accomplished through Jotform or do I need to look for an alternative method?

  • Profile Image
    Jeanette
    Answered on November 19, 2013 at 03:54 PM

    There is already a beta version of the calculation feature which is not yet releaased. The feaure can be accomplished with text boxes, not with the matrix fields. We are hoping to have it ready soon

  • Profile Image
    flexgener
    Answered on November 22, 2013 at 10:08 AM

    Does that mean I can't get any help configuring the calculations needed for my project?

  • Profile Image
    Welvin
    Answered on November 22, 2013 at 12:21 PM

    Hi,

    Matrix doesn't have a unique ID for every textbox sections so doing the calculations would be a bit difficult. We now have the calculation but that works using the basic text box fields. You may consider using that one and use field positioning function to align multiple fields: Form Field Positioning. We can provide a workaround but we cannot promise you a timeframe. Will bookmark this thread.

    Thanks