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

    How to add calculations to the report

    Asked by Les on July 16, 2012 at 09:22 AM

    1. Is there a way to create subtotals and totals and fields?

    2. Is there a way to use a parameter like from date and to date?

    Example:

    Form contains week ending date, total hours for week.

    When report is pressed - a from date and to date are presented

    Let's say the from date is 1/1/12 and the to date is 4/1/12

    The report will subtotal by month for total hours and also a total for total hours

     

  • Profile Image
    JotForm Support

    Answered by Mike_T on July 16, 2012 at 06:46 PM

    Thank you for contacting us.

    1. Is there a way to create subtotals and totals and fields?

    This is not currently possible to do this using built in features. We have plans to add the calculations to our forms, but unfortunately, there is no ETA on this.

    2. Is there a way to use a parameter like from date and to date? 

    It is possible to generate Excel/CSV report based on some time frame.

    Would you like to see this calculation feature implemented for Excel/CSV reports or Visual Reports?