Jotform Tables: Add An Option to Change The Order of Columns to The Field Order of The Form

  • Profile Image
    membership.dsv
    Asked on January 25, 2021 at 03:46 AM

    It looks like I will have to give up on Tables and the CSV. It seems that every time I touch a field in the form or a column in a table, that element goes to the far right of the table. I can see that unused columns move to the end of the list, but there needs to be a way to bring them back to the "correct" order for display and download, based on the order in the form. This is especially important because I have instances where questions are repeated in different contexts on the form, so the order indicates which answer belongs where. Also it is easy to mistake one such question for another when trying to reorganise them. I can't see a way around that short of numbering the questions; something I'm not planning to do.

    I considered hiding, then unhiding questions in the desired order until I got the order I wanted, but that was very tedious and in the end unproductive because the address elements were still jumbled (as you have previously indicated). 

    I noticed that "Address" field appeared in the list of columns as well as the elements of the Address like "Street Address" and "Country".

    FYI, I added a breadcrumbs widget and when I was reviewing the columns of a test table, I am sure it appeared in the middle of the address block, but wherever it was, it did not seem appropriate. Obviously, I was planning to hide it anyway.

    I guess Jotform is working as hard as possible to fix problems with CSVs: I would rank it the most serious glitch I have come across in a working app.

    Peter

  • Profile Image
    hestia
    Answered on January 25, 2021 at 04:12 AM

    Hi Peter,

    We do apologise for the inconvenience. I do understand that this is not very practical to edit the order of columns manually. Therefore, I elevated your ticket as a feature request for an option to "Restore default order of columns to the form order". Please keep in mind that there's no assurance whether this will be implemented. It will highly depend on the viability of the feature, the number of similar requests we get, along with the workload of our Developers. We can't give you any timeframe but we'll keep you apprised on this same thread when there's an update. 

    Thank you for your understanding and thanks for using JotForm.

  • Profile Image
    membership.dsv
    Answered on January 26, 2021 at 04:50 AM

    Thanks Hestia.

  • Profile Image
    BryceFauskee
    Answered on February 22, 2021 at 03:26 PM

    I have a similar issue - the original order appearing on the form changes when I download it, either by doing the entire application list into Excel or an individual one-line using Tables. This year is the second year using this identical form; nothing changed from Year 1. This rearrangement of columns started about one month into this year's application process, after receiving and downloading ~50 correctly but the last ~25 are miss-aligned. It's tedious and inefficient to continue to do this manually. The problem is not excel; the problem is your Jotform. Do you plan to address this obvious glitch?
  • Profile Image
    Cecile_A
    Answered on February 22, 2021 at 08:39 PM

    Hello @BryceFauskee,

    I have moved your concern to a new ticket to avoid confusion with this thread.

    I'll address your concern here: https://www.jotform.com/answers/2916780

    Thank you.