Display sort order

[Normand]

I would like to display on a layout the order in which the table is presently sorted. If the sort selection is changed, this field would reflect the new sort order. How can this be done ? I tried with a global field and the Get(sortstate) function but this only tells me if the table is sorted or not (0,1)- doesn't give me the field name.

I'm also looking for a method where a user could select the sort fields from a dropdown list (where I would put only a few fields-not all of them), and have the sort run after having done the selection.

Thanks for your help

[aaa]

Hi, Normand.

If you sort your foundset by script, you can do it having one global field, where you will put sort order.

[Normand]

But how do you get the present sort order. I could not find any Get function which seemed to return this information ?

[aldipalo]

Take a look at this video from Matt Petrowsky. It answers your questions.

http://www.filemakermagazine.com/index.php?catid=1

Scroll down to "Ultimate Portal Sorting."