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

    Taking average of submission

    Asked by Smondoville on May 06, 2013 at 01:53 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. This can be a report. How i can achieve this?

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

  • Profile Image
    JotForm Support

    Answered by EltonCris on May 06, 2013 at 08:19 AM

    Hi,

    Sorry to say but we do not have the option you are looking for on the reports feature. I can see few report links under your form, wouldn't that suffice? Let us know your thoughts. Thank you!

  • Profile Image

    Answered by Smondoville on May 06, 2013 at 08:21 AM

    That would never sufice, none of the reports are giving options to take averate of sum the rating of the vendors :-( 

  • Profile Image
    JotForm Support

    Answered by Welvin on May 06, 2013 at 10:28 AM

    Hi,

    You may also consider creating fields for each vendor (the vendor as the field label), I think this method will work and let you sum up the ratings. The Matrix Field will do that.

    Please try that.

    Thanks

  • Profile Image

    Answered by Smondoville on May 06, 2013 at 11:02 AM

    I might have 1000 vendors, so that not a feasible solution. 

     

    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 :-(

  • Profile Image
    JotForm Support

    Answered by Welvin on May 06, 2013 at 11:05 AM

    Hi,

    Please create a separate thread requesting such functions so we can escalate that to our developers. We can do that for you but we prefer it this way, so you will be notified for the updates regarding the request.

    Thanks