Tables: Add an option to restore default order of columns > Same as form fields.

  • FabAcademy
    Asked on November 16, 2020 at 2:44 PM

    how can I organize the columns back the way they were before I filtered them?

    I need them to follow the order of the form...but after I filtered some info, it does not go back!

    thanks

  • Niko_N
    Replied on November 16, 2020 at 5:44 PM

    Hi,

    Thanks for reaching out to us!

    First, please make sure ascending or descending is not enabled for any of your form fields. If you don't want that order to be applied, you can remove it by clicking X icon next to the field name:

    1605566442 5fb2ffea5de28  Screenshot 10

    Otherwise, removing applied filters should set Tables to the previous state:

    1605566645 5fb300b5a388d  Screenshot 21

    Please check and let us know if you are referring to something else.

    Thank you!

  • FabAcademy
    Replied on November 17, 2020 at 4:36 AM

    Hi,

    Im referring to something else.

    My Form fields are in an order: "Submission date, name, lastname, bla bla bla"

    Therefore, the spreadsheet columns harvesting that information followed the same order: "Submission date, name, lastname, bla bla bla"

    Now, after I filtered to get some specific info, once I removed the filter, the columns never went back to its original order "Submission date, name, lastname, bla bla bla". And I need the columns in that order.

    A filter feature that doesn't let you go back to the original order makes no sense...this is why I'm sure I'm missing something :)

    thanks!

  • Ashwin JotForm Support
    Replied on November 17, 2020 at 4:48 AM

    Please note that when you add filter in JotForm tables, it will only filter the records and will not change the order of questions/columns. Please check the screenshot below:

    1605606311 5fb39ba79f6ec filter Screenshot 10

    When you added filter, did you change the order of columns manually or the columns are hidden? Please note that if the columns are hidden, you can select them to be displayed. If you have change the order of columns, the only option available is to manually move the columns to desired order. Please check the screenshot below:

    1605606489 5fb39c593ec17 columnShow Screenshot 21

    Hope this helps.

    Do get back to us if you have any questions.


  • FabAcademy
    Replied on November 17, 2020 at 5:21 AM

    I didn't use the "filter" filter, I filter by Columns


    1605608399 5fb3a3cfaa93a Captura de pant Screenshot 10


    once I clicked them all back (Select all), the selected ones stay in front.

  • Vick_W Jotform Support
    Replied on November 17, 2020 at 5:56 AM

    Hi there,

    Thank you for clarifying that. There are multiple options available to rearrange the columns. Please see below.

    First Method:

    1605609616 5fb3a890f3b9c  Screenshot 10

    Second Method:

    1605609872 5fb3a9904f43a  Screenshot 21

    1605610024 5fb3aa28d35dc  Screenshot 32

    Third option:

    You can drag the whole column by clicking and holding the left mouse button and rearrange them.

    1605610166 5fb3aab68e35b  Screenshot 43

    Fourth option.

    You can revert an older version of the Tables from the history section.

    1605610302 5fb3ab3ebf6de  Screenshot 54

    1605610479 5fb3abef9aefb  Screenshot 65

    Let us know if you have any other questions or concerns.

    Thanks.

  • FabAcademy
    Replied on November 17, 2020 at 6:19 AM

    I have many columns, moving them manually is not practical; and if I click restore, I lose the latest data inputs!

    So, basically, if I filter by columns, they won't go back automatically, I have to rearrange them manually...?

    What's the point in having the "Show/Hide Columns" option? If I want to rearrange them, I just do it. The movable options should mean they go back...right?

    anyways...thanks!

  • Vick_W Jotform Support
    Replied on November 17, 2020 at 7:01 AM

    I understand your point. Let me escalate this to the backend team as a feature request as it does seem to be a feature that can be very helpful and time-saving.

    Please note that we can not provide an ETA on this right now or any assurity if this will be implemented. But as soon as an update is available we will definitely inform you here.

    Thanks.