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

  • Profile Image
    FabAcademy
    Asked on November 16, 2020 at 02: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



    This is a re-post of a comment on How to Use Different Filters to Easily Manage Your Data in Jotform Tables

  • Profile Image
    Niko
    Answered on November 16, 2020 at 05: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_

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

    1605566645_5fb300b5a388d_

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

    Thank you!

  • Profile Image
    FabAcademy
    Answered on November 17, 2020 at 04: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!

  • Profile Image
    Ashwin
    Answered on November 17, 2020 at 04: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.gif

    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.gif

    Hope this helps.

    Do get back to us if you have any questions.


  • Profile Image
    FabAcademy
    Answered on November 17, 2020 at 05:21 AM

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


    1605608399_5fb3a3cfaa93a_Captura de pant


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

  • Profile Image
    Vick
    Answered on November 17, 2020 at 05: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_

    Second Method:

    1605609872_5fb3a9904f43a_

    1605610024_5fb3aa28d35dc_

    Third option:

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

    1605610166_5fb3aab68e35b_

    Fourth option.

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

    1605610302_5fb3ab3ebf6de_

    1605610479_5fb3abef9aefb_

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

    Thanks.

  • Profile Image
    FabAcademy
    Answered on November 17, 2020 at 06: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!

  • Profile Image
    Vick
    Answered on November 17, 2020 at 07: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.