Script (button) to perform asc/desc sorts

[Tony Martin]

Hi gang!

I need a button that allows me to click the first time, and sort my records based on certain criteria in ascending order. The next time the button is pressed, we need the data sorted in descending order. Then next time, ascending, etc etc.

Anyone had any success in creating a script that can do that?

We have 10 and 11 in our org.

Thank you!

Tee

[David Jondreau]

Sorting in pre-11 is frustrating. You have a couple options, depending on how many fields you'd like to sort by and if you want multiple layers of sorting.

If it doesn't need to be robust (just sorting on one or two fields, not nested), you can script it, storing the current sort order in a $$var and hard code the sort options.