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

    [Tables with Formulas] Adding formulas to matrix table cells

    Asked by vrsioffice 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, 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?

    Julie

    Screenshot
    formulas calculations
  • Profile Image
    JotForm Support

    Answered by Mike_T 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 by DanMax 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.

     

    -Dan

  • Profile Image
    JotForm Support

    Answered by KadeJM 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 by mrotjan on November 05, 2013 at 02:34 PM

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

     

    Thanks!

  • Profile Image
    JotForm Support

    Answered by KadeJM 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. :)