submissions are not in order

  • Profile Image
    Mercado_Joy
    Asked on July 08, 2021 at 03:47 AM

    Hi!

    We have a jotform and upon looking at the 'submission' table where all the submitted answers are tabulated, the numberings of the questions are all messed up even if in the form, the questions are all in order. We tried to download it in excel format with the hope that everything will fall into proper order but it's the same thing. I'd like to know why this is happening and how we could prevent it moving forward.

    We hope to hear from you soon.



    Here's the link to the form: https://form.jotform.com/211653334775155




    Thanks,

    Joy

  • Profile Image
    Jovanne_A
    Answered on July 08, 2021 at 08:11 AM

    Hi Joy, thank you for contacting support.

    You can manually re-arrange the columns' order on the Table page. Please refer to this guide for complete instructions.

    GUIDE: how-to-add-and-organize-columns-in-jotform-tables

    Please give it a try and let us know if you need further assistance.

  • Profile Image
    Mercado_Joy
    Answered on July 09, 2021 at 01:30 AM

    Hi!


    The guide that you gave is about how to re-arrange the columns. My concern is not about if we could arrange or not the columns in the submitted page but why the questions are not in order in the "submissions" page (the one in a spreadsheet form)? Does it mean that the only solution in my concern is to manually rearrange the columns? No other way? If so, then how come I don't have the same issue in my other jotforms? Clearly, there's something happening maybe in the backend that we, in our end, don't see and understand, because we don't have the ability/access to see and understand. We are hoping that perhaps you could help us see and understand whatever that may be.

    It will save us time and energy if we don't have to manually re-arrange the order of the questions after submitting because in our understanding, how the questions are arranged in the jotform, it will also reflect the same order in the submitted page, right? We also would like to know how to prevent it from happening.


    I hope to hear from you soon.


    Thanks!

  • Profile Image
    Richie_P
    Answered on July 09, 2021 at 05:50 AM

    I have checked your form and it seems the columns are in order or the same with the form fields.

    May we know what fields are not in order?

    However, if you do have fields that are not in order, you would have to manually change them.

    You can follow this screen cast:

    pAIlPnssGL.gif

    Looking forward for your response.

  • Profile Image
    borisovaleksey798
    Answered on July 09, 2021 at 07:18 AM

    If so, then how come I don't have the same issue in my other jotforms? Clearly, there's something happening maybe in the backend that we, in our end, don't see and understand, because we don't have the ability/access to see and understand. We are hoping that perhaps you could help us see and understand whatever that may be.

  • Profile Image
    Jovanne_A
    Answered on July 09, 2021 at 08:40 AM

    Hi,

    I checked your submission page, and they seem to be in order according to the order of the form fields. However, there are some columns that were hidden on the table.

    1625834334_60e8435ea1a7d_

    Could you please provide us with a screenshot of the submission page you see on your end so we can check?

    GUIDE: how-to-post-screenshots-to-our-support-forum

    We look forward to your response.

  • Profile Image
    joy.mercado
    Answered on July 12, 2021 at 12:26 PM

    1626107107_60ec6ce39d535_5th.PNG1626107107_60ec6ce367c08_3rd.PNG1626107106_60ec6ce2c02cf_2nd.PNG1626107106_60ec6ce26502a_1st.PNGHi!

    Here are the screenshots of the ones that are not in order.


  • Profile Image
    Basil_A
    Answered on July 12, 2021 at 04:05 PM

    Hi,

    The form fields are ordered by order by default when the form is created.

    The issue is that if the fields get re-ordered or fields get added or removed the order changes don't reflect in the tables page.

    There are no back-end issues with your form.

    Please let us know if you have any further questions.