This is yet another FileMaker portal sorting technique based on its predecessor yet simpler, that allows for dynamic multi-column sorting.

The user can click a button to sort a column, shift-click to add additional columns, click or shift-click sorted columns to reverse the sort order, AND option-click sorted columns to remove them.

extreme-sorting-dynamic-multicolumn-click-sorting-excelisys

Download the FileMaker “eXtreme sorting” file here!

The scripting is even designed to allow the user to un-sort the list. It can handle sorting all field types and it can sort by value lists. With only one minor difference the technique can be used to sort both list view layouts and portals. And each list can have it’s own unique sort order.

How’s that for some fancy schmancy FileMaker trickery!