Sorting columns

[nick_jp]

OK... I'm a relative beginner to this. 

 

Is there an easy way to implement sorting by clicking on the column header in a list view? I've done some searches and tried to implement this (http://www.filemakerhacks.com/?p=2341) but I'm getting errors (Some fields in the sort order are invalid or cannot be sorted. You must remove these fields from the sort order before performing a sort.)

 

Is there a  fairly straight forward way to implement this functionality?

 

 

[bcooney]

There is no built-in list view column header sort capability in FM. (Table view, however, does have it built-in, but table view is more often a developer-only layout).

 

Kevin's technique is as straightforward as it'll get, if you want the asc<>desc toggle. If you don't, then just change your column header to a button and assign it a Sort Records script step, and call it a day.

 

Remember, context is everything in FM. The error that you're getting suggests that the fields that are in the sort order are not available given the context of the layout. Kevin uses two fields only for the sort and populates them dynamically. There's a sample file.

[Lee Smith]

Hi Nick,

 

Why not post a copy of your file so that we can see what you have. This can often move your question along faster.