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

    Feature Request: Aggregate functions in report

    Asked by Smondoville on May 06, 2013 at 11:11 AM

     

    I  have a vendor submission form where vendor are rated based on their perfomance. The users can enter their rating of each vendor. Even the user can submit same vendor multiple times with different rating.

    What i need is the average of rating of each vendors. 

     

    There is no such feature available now !

     

    I really wonder why you guys not implemented group by,order by, sum aggregate function.. which any reports will have, this is the basics of any reports that really sad that no such feature for these report :-(

    Page URL:
    http://form.jotform.me/form/31213288368456

    Feature Request Reports style different
  • Profile Image
    JotForm Support

    Answered by jonathan on May 06, 2013 at 04:11 PM

    Hi,

    You can use aggregate functions in reports when using google spreadsheet or by downloading submissions to Excel

    1. Google-Docs-Integration-Send-Responses-to-Google-Spreadsheets-Instantly-

    2. How-to-Download-Form-Submissions-to-Excel-CSV-PDF

    Are you not able to use this 2 features?

    Please inform us if you need further assistance coming up with your report requirements.

    Thanks.

  • Profile Image

    Answered by Smondoville on May 08, 2013 at 03:57 AM

    This is not complete.. the above will work for sure...

     

    But remember, as my case its a vendor feedback form with ratings... I want to show the user who already rated... about the accumilated results in the form of reports.

     

    That is the purpose of reports , to show data to the users statistically, here your reports are showing the data which user is submited in unaltered way. But we need data to show user in altered way as well.

     

    Please add the feature of aggregate function in report which is usefull to everyone and it is the base of all reports..

    Thanks in advance!!

  • Profile Image
    JotForm Support

    Answered by Welvin on May 08, 2013 at 05:33 AM

    Hi,

    I have added this thread to our feature request list. As soon as there are updates, you will get the notification via this thread.

     

    Thanks