Preserve manual sort order after applying automatic sort

It’s cool that you can manually click and drag to reorder records. But what if you want to temporarily apply an automatic sort, and then go back to your manual sorting? As far as I can tell, you would need two separate views to do this–and if you ever accidentally applied sorting to the manually sorted view, you would lose your manual sorting forever.

Using two separate views isn’t ideal for me because I already have a lot of views and for my needs this would effectively double that already large number of views. And the risk of permanently losing my sorting makes it not really seem worth it.

What I propose is some sort of ordenal sorting field… Essentially it would be the same as the numbers that currently appear on the far left in grid view, except that if you applied an automatic sort, those numbers would stay with the same record. So if you had:

1 A
2 C
3 B

and you resorted it alphabetically, you would have:

1 A
3 B
2 C

instead of

1 A
2 B
3 C

Then, if you want to go back to the original order, you just sort by the ordenal field.

Of course if there is already a better way to do this, please help me find it.

2 Likes