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.
Feature Request: Aggregate functions in reportAsked 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 :-(
You can use aggregate functions in reports when using google spreadsheet or by downloading submissions to Excel.
Are you not able to use this 2 features?
Please inform us if you need further assistance coming up with your report requirements.
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!!
I have added this thread to our feature request list. As soon as there are updates, you will get the notification via this thread.
Any update on this feature request? It's over 3 years
There is no new update on the status and progress of this feature request at this time.
The feature is not in the high priority list. It may take a while for this feature request to be attended to.