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

  • Profile Image
    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!


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

  • Profile Image
    Answered on November 16, 2020 at 05:44 PM


    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:


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


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

    Thank you!

  • Profile Image
    Answered on November 17, 2020 at 04:36 AM


    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 :)


  • Profile Image
    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:


    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:


    Hope this helps.

    Do get back to us if you have any questions.

  • Profile Image
    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
    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:


    Second Method:



    Third option:

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


    Fourth option.

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



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


  • Profile Image
    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?


  • Profile Image
    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.