FabAcademyAnswered on November 16, 2020 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!
Niko_N Jotform SupportAnswered on November 16, 2020 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.
FabAcademyAnswered on November 17, 2020 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 :)
Ashwin JotForm SupportAnswered on November 17, 2020 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.
FabAcademyAnswered on November 17, 2020 05:21 AM
I didn't use the "filter" filter, I filter by Columns
once I clicked them all back (Select all), the selected ones stay in front.
Vick Support Team LeadAnswered on November 17, 2020 05:56 AM
Thank you for clarifying that. There are multiple options available to rearrange the columns. Please see below.
You can drag the whole column by clicking and holding the left mouse button and rearrange them.
You can revert an older version of the Tables from the history section.
Let us know if you have any other questions or concerns.
FabAcademyAnswered on November 17, 2020 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?
Vick Support Team LeadAnswered on November 17, 2020 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.