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 can I make the results in order?

    Asked by Buzzcom on February 24, 2016 at 07:43 AM
    Is there any way of ordering the results listing from first place to last depending on the score inputed. At the moment I have allowed the user to put in the placing - but then they are not necessarily in order - I would prefer to not to have the user input the placing however the system do it automatically from the score input and then to appear in order from first place to last place on the spreadsheet. Please explain how I can achieve this.
    results order make in order order results make results order grid listing report html table listing
  • Profile Image
    JotForm Support

    Answered by Kiran on February 24, 2016 at 11:49 AM

    I'm sorry that I couldn't understand your requirement with ordering the results. Do you mean to order the submission results in an Excel sheet? Could you provide us with more information with your requirement so that we can guide you in the right direction? It would be helpful if you can provide us with the screenshot.

    We will wait for your response. Thank you! 

  • Profile Image
    JotForm Support

    Answered by Kiran on February 24, 2016 at 11:49 AM

    I'm sorry that I couldn't understand your requirement with ordering the results. Do you mean to order the submission results in an Excel sheet? Could you provide us with more information with your requirement so that we can guide you in the right direction? It would be helpful if you can provide us with the screenshot.

    We will wait for your response. Thank you! 

  • Profile Image

    Answered by Buzzcom on February 24, 2016 at 05:46 PM

    Hi - Sorry I perhaps did not make myself clear.

    Users will input competition scores and jotform will calculate the final results.This means there will be a list of competitors and their scores. But they are not ordered from first place to last place - they are randomly ordered.

    The form is then submitted and also sent to Google spread sheets

    Is there a way for the information to then be displayed ordered from first place to last place (first place being the highest percentage score and last the lowest)
    https://form.jotform.co/60540310892853

     

  • Profile Image
    JotForm Support

    Answered by Jan on February 25, 2016 at 01:39 AM

    You can arrange the reports in ascending or descending order. 

    In the Submissions page, scroll down and you'll see the Grid Report. Click the drop down arrow in the column you and select ascending or descending. After that, you can download it as an excel or csv file.

    When you create an HTML table listing report or Grid listing report, you have an option to arrange it as well. You just need to click the arrow up or down beside the title column.

    Hope that helps. Thank you.