Restoring a manual sort-order
I have a large database from which I use a compound, manual search to find a set of records. Then I use a numeric field to manually sort the found records.
What I'm hoping to do is restore the find (easy enough, by flagging the records) and restore the manual sort order. I figured out a way to do this with a script, by looping through the found set, copying and pasting the ID numbers for each record, in order, in a global field. To restore the sort order, I envision doing another manual sort based on the order of the records listed in the global field.
I can't help but thinking there must be an easier way to do this.