The other day I was sitting with a client, looking at a list view layout. The client said to me, “Can you make it so that when I click the headers the columns will sort, like in Table View or Excel?” No problem, I said; I’ll just make each header a button that runs a Sort script step. They she said “Well, when I click each one it should sort ascending and then descending, just like Excel.” Ok – a little bit more inconvenient; I need to use a script and a bunch of of fields to keep track of ascending/descending. Finally, she dropped the bomb. “Oh, can I have those cute little up and down arrows, like in Excel?” That is the last straw, I thought. Now I have to make scripts, fields AND graphic calculations for those dumb arrows.
There must be a better way to do this. Using the great scientific tradition of standing on the shoulders of giants I searched the web for good solutions. Using a combination of scripting and merge global variables you can easily put up and down arrows next to sorted headers. This technique only requires a script. No extra fields are required go make it work.
Continue reading ‘We can Sort it out’
Recent Comments