Submissions Table column headers are rearranging

  • Profile Image
    MLAB
    Asked on January 12, 2022 at 03:11 AM

    Hi

    The submissions table with our results is causing problems. It works ok in old version, but in new version:

    • Columns keep rearranging themselves - we need them to remain in order so the data makes sense. I KNOW I can manually reorder them. However: a) they don't stay like this if anyone hides a column or selects columns and b) this is a complex form so ridiculously tedious doing this task of re-ordering. Why can't it just be in the right order?
    • Some questions/data don't seem to be appearing in the table at all!

    I was thinking of upgrading to a paid plan but now I think we will look for a different platform. It's making my job impossible and wasting my time.

  • Profile Image
    Richie
    Answered on January 12, 2022 at 05:03 AM

    To clarify, when you receive new submissions the table column headers are re-arranged?

    I have checked your table and it seems you have pinned the column headers.

    Regarding the data not showing, may we know what field data are not showing in the table?

    Looking forward to your response.

  • Profile Image
    MLAB
    Answered on March 03, 2022 at 09:22 PM
    Hi – I just realised Richie P answered (went to junk).
    I now see there were questions of clarification.
    In answer to his query, no, this is not what is happening.
    * WHAT I WANT TO ACHIEVE: I want all the columns in the submissions area of my form to stay in order (same as the order of questions in the form). If you filter the view or hide a column, then unhide or unfilter, I want it to go back to the correct order (same as order of questions in form).
    * WHAT IS HAPPENING: If someone filters the form view, hides a column, or adds in a new question to the form, the columns in the submissions area change and go out of order (not same as order of questions in form)
    * WHY IT IS IMPORTANT: It just makes sense to have them in order? But its also a really long form, so if out of order it’s really confusing. Also, we have some questions where people select a drop down box answer, and they can select OTHER, as an option, they then specify what the ‘other’ is in a text box below. These two questions get separated in submissions area and it’s hard to understand the data.*
    * NO I HAVE NOT PINNED ALL THE COLUMN HEADERS: I have pinned some to try to keep them from moving. I was hoping to pin/freeze all of them as a workaround to the issue. However this didn’t work. You can only pin a few of them before the pinned columns take up whole screen/view and I can no longer see ones unpinned to RHS. The slider provided at the bottom only slides the unpinned columns. My form is too long to pin/freeze all the columns.
    * I have found the missing data
    *Note Surveymonkey offers option for ‘other’ answers to question where person filling out form specifies what they mean by ‘other’ and this is all bundled into the one question so they don’t separate – can this be fixed in jotform?
    Jane
    ...
  • Profile Image
    Christian
    Answered on March 04, 2022 at 01:23 AM

    Hi there,

    Thank you for explaining what you're trying to achieve

    On the submission table, when a column is hidden & unhidden back, it unfortunately becomes the last column and doesn't go back to its original order, which is understandably confusing when working on a very long form. I am raising this to our developers as a feature request, and you will surely be notified through this thread once it's implemented,

    In the mean time, to switch the order of the columns to default, which is how the fields are arranged on the form, click on the three dots by the name of the table, choose Manage Columns, then double-click the Select All option, as seen on the video below.

    1646373470_6221aa5ee4e5c_order.gif

    As for the Other option on the Input Table elements on your form with dropdown options, you can follow the steps below to add an input box for when a respondent has to answer Other.

    • Change the Input Type to Multi-Type Columns

    1646374549_6221ae95f2af3_Screen Shot 202

    • Choose a column type for each columns. Textbox for Others & Dropdown for the rest.

    1646374669_6221af0d66811_Screen Shot 202

    • Set the options for each dropdown

    1646374734_6221af4eb4cfb_Screen Shot 202

    Instructions

    1646374792_6221af886b59d_table.gif

    Please let us know if this works for you or if you need further assistance. Thank you!