Sorting by Column

[mattpacman]

Can anyone explain the best way to sort by column? For example, I would like to place a button over the column headers that, when clicked, sorts the data by the values in that column. (Many commercial programs have this feature).

Thanks in advance,
Matt

 

[snip6969]

Make a script for each column you want to sort. For example SortFirstName, SortLastName etc. Put the buttons on top of each column and link them to the appropriate script.

To sort a column use this easy script

Go to Field["ColumnName"]
Sort[No Dialog]

that's it.....

ColumnName: is the field you want to sort
Sort: Restore sort order is UNchecked and Perform without dialog is CHECKED.

I hope this helps.

Chris F

 

[mattpacman]

Chris,

Thanks, but I still cannot get this to work. I set up the script as you said:

Go To Field ["PayDueDate"]
Sort [No Dialog]

However, I receive an error message that says:

"The previous script step "Sort" could not be completed because it restores an invalid request. Do you wish to continue with this script?"

Option buttons are "Cancel" and "Continue".

I am running FMP 5.5 for Mac.

Am I doing something wrong or is there another way to do this?

 

[Schlogg]

Matt,
I'm not sure what Chris is saying. (Chris, are you saying that FMP will default to a sort field?)

You need a script for every column heading you want to sort on. Use manual sort to select the field to be sorted, click done, create a script containing a single sort step, save the script.
The script step has both 'Restore' and 'No dialogue' flagged.
Set your column buttons to the relevant script(s).
Cheers,
Paul J.