In a current project I need to permit users of list layouts to sort the lists by the contents of a field (column) by clicking on the column header.
Here's one way
Google 'FileMaker portal sorting for dozens more'
Hi Steve, thanks. I've already done as you suggest. Actually, I've used the solution on filemakerhacks many years ago. Even more recently I used a solution from Escelisys. I'm interested in feedback from users who have used more than one of these solutions and have reasons for preferring one over another. Hopefully, after a few postings, a clear winner will become apparent.
This is the latest version (v.1.04) of my list sorting technique first mentioned below. It can be done in a couple of minutes and only requires that you rename your field objects.
It consists of 1 script with no dependencies. Sorts occur dynamically, each column restores it's last sort order and a default sort order can be set for each field type. It can be duplicated throughout your solution quickly.
For sorting portals this technique is available:
FWIW, I am biased about my own list sorting technique and have no opinion about which portal sorting technique is best, although Jeremy Bante's Virtual Sort above is certainly sophisticated and the first I would implement if needed.
Requires FMP v.13.
One method I've used is to create a separate Table-view-only layout so users have all the column-resizing and -sorting options which are built into FM, but use the Security Permissions Groups to disable record creation/editing on that layout for non-admin users.
Retrieving data ...