[Tables with Formulas] Adding formulas to matrix table cells

  • Profile Image
    Asked on April 24, 2013 at 04:16 PM

    I would really love the feature added to JotForm that allows the creation of formulas in matrix table cells.  (Or a new table tool with the ability to add formulas to cells.)

    I often need to create a form that contains a table/matrix where some of the cells sum.  (Timesheet, expense report form, etc.)  I know this request has been made in the past.  (I have seen posts asksing for this feature for the past several years.)

    For Example

    Table with 10 rows and five colums.
    Columns: Date, Description, Hours, Rate, Total.  Total field multiplies hours by bill rate. 
    Then the last row would be totals for each numerical column.

    Using the PO payment function does not accomplish the needed goals.

    Does JotForm ever plan on adding this feature?


  • Profile Image
    Answered on April 24, 2013 at 04:59 PM

    Julie, thank you for provided information and great example. It might be really helpful for our Developers.

    Yes, we have plans to implement some kind of calculation feature, but we can not provide any ETA for now. Our Developers are working hard on improving the service and implementing new features, however, they have to prioritize their task and implement more important things first.

    Now I have created a ticket about your request, and forwarded it to our Developers. We will keep you updated via this thread.

  • Profile Image
    Answered on May 16, 2013 at 01:00 PM

    I came across this Q&A while searching for a way to calculate the sum of matrix columns. I'm sorry to see that it is not yet possible and just wanted to add my voice to the feature request.

    Thank you to the devs for any attention you can devote to this option.



  • Profile Image
    Answered on May 16, 2013 at 01:50 PM

    Hey Dan, thanks for your added interest in this feature request. Your vote has been noted as well. :)

  • Profile Image
    Answered on November 05, 2013 at 02:34 PM

    I too would also really like to have calculation features in the report builders.



  • Profile Image
    Answered on November 05, 2013 at 03:01 PM

    @mrotjan  ( and @DanMax, I meant to tell you the same thing back when I first responded)

    I know it's been awhile since this was requested but you're vote is noted as well. I would also like to kindly and strongly urge you to open up a separate New Thread with your request for this as well to help add to the demand for this need. Our New Features and Integrations are highly comprised of User Demand for adding things and improving them. So if there are lots of requests of the same type of need this then chances of this happening are seen as much greater. Though this may also be dependant upon our Dev Teams current tasks at hand but they do get prioritized and will be considered upon being looked at. :)