Submissions page: Unable to see submissions on other pages when sorting

  • Profile Image
    jbefooty
    Asked on May 29, 2021 at 09:10 AM

    https://eu.jotform.com/build/200014791181344

    The above form covers Euro 2020 Group A and I have forms for Groups B,C,D,E and F as well

    My problem is that the form does not sort alphabetically when asked and only shows one page of submissions out of 4 available

    Can you help please

    regards

    John

  • Profile Image
    Anita_K
    Answered on May 29, 2021 at 01:12 PM

    Hi John,

    thank you for reaching out to us. In the submission table, you can see all of your submissions under each other.

    You will also be able to sort the columns and apply filters. Please refer to this guide for more information:https://www.jotform.com/help/1012-how-to-add-and-organize-columns-in-jotform-tables

  • Profile Image
    jbefooty
    Answered on May 29, 2021 at 06:13 PM

    Thanks Anita but my problem is with sorting submissions in ascending order which is not happening on these forms

    Could you have another look at this problem and advise please?


  • Profile Image
    Vanessa_T
    Answered on May 29, 2021 at 11:33 PM

    I just tried sorting your form's submissions and was able to sort it just fine.

    1622345535_60b3073faec77_a.gif

    Kindly share a screenshot where you have sorted the submissions but the results were not sorted.

    How-to-Post-Screenshots-to-Our-Support-System (Note: Email Attachment Is Not Supported)

  • Profile Image
    jbefooty
    Answered on May 30, 2021 at 06:30 AM

    Yes you are correct that it appears ok when using NEW submissions version but all my Excel spreadsheets are set up using previous version Can you get the sort submissions to work with previous version because I am unable to do so?

  • Profile Image
    Bojan_J
    Answered on May 31, 2021 at 06:06 AM

    Greetings.

    Can you please try to download your Excel again? We had a similar problem and our Developers resolved that problem. If you are still having a problem, can you please let us know are you trying to sort the fields first and then downloading the Excel file? If so, what field are you using to sort submissions?

    Thank you for your cooperation.

  • Profile Image
    jbefooty
    Answered on May 31, 2021 at 12:22 PM

    I am using the previous version of submissions

    I click on submissions and can see all 52 replies in chronological order OK

    However when I click on sort A-Z only shows page 1 of 4 and other 3 pages are empty

    I had this problem before and it was resolved now its back again and I dont think I have changed anything

  • Profile Image
    Bojan_J
    Answered on May 31, 2021 at 01:24 PM

    Greetings.

    Thank you for the clarification. I will forward this problem to our Developers.

    In the meantime, can you please let us know why are you not using the new Jotform Tables? Alternatively, you can also use Inbox to view your submissions. Is there anything that is missing in Tables or Inbox that you like in Submissions?

    Thank you for your cooperation.

  • Profile Image
    jbefooty
    Answered on June 01, 2021 at 07:59 AM

    This is part of my spreadsheet and the area in yellow is where I paste direct from Jotform This can only work from old version of submissions because new submissions takes the score and treats it as one cell and is no use to me with this spreadsheet1622548531_60b620339c7e4_

  • Profile Image
    Anita_K
    Answered on June 01, 2021 at 08:16 AM

    Hi,

    thank you for your feedback. We have already forwarded the issue with sorting in the old submission page to our developers and we will let you know as soon as we hear back from them.

    When exporting from the Tables to Excel, we usually recommend Excel's own Text-to-Columns function if you want to separate out things into cells. In the meantime you may be able to use this workaround to fill your spreadsheet.

  • Profile Image
    jbefooty
    Answered on June 01, 2021 at 06:26 PM

    yes thanks for that and I do know about text to columns however it only works one column at a time and is very time consuming to do.

    What I don't understand is how this problem only started this time after 22nd May it was working fine up to that point.

    In addition when I had the exact same problem last year the developers solved the problem then so must be easier fix this time around, just saying.

  • Profile Image
    Vanessa_T
    Answered on June 01, 2021 at 10:48 PM

    Please note that we are moving away from the OLD Submissions page into the NEW Tables page.

    As such, it may take longer for requests for the old submissions page to be resolved as we are focusing on enhancing the new tables page.

    If there is a feature missing on the new tables page, then we can instead create a feature request for it.

    Kindly open a new ticket should you want to request features on the new tables page.

  • Profile Image
    jbefooty
    Answered on July 11, 2021 at 07:09 AM

    Hi Vanessa

    Thought you would like to know that I checked my submissions this morning and can now sort alphabetically as before I have also managed to write new program to deal with new submissions but would like to know how long you intend to keep OLD format for submissions as I do not wish to operate two spreadsheets to cater for OLD and NEW versions

    Thank you