Sort button

[Raymond Gonzalez]

Hello, im making a layout that is going to viewed in "list view". I want that when you click the name of the field that appears in the top that group of field will be sorted ascending, and if u click again it will sort descending, like if you were clicking in a "Table view". Thanks!

[mr_vodka]

See here

and here.

JMO FM6 example

[Raymond Gonzalez]

hello, sorry, i tried to see the links u gave me but they didnt help, is there something else that may help me? thanks

[mr_vodka]

Isnt that exactly what you were looking for? Were you not trying to sort the records in list view via a column heading that is a button ? Please re-read Ender's post.

[Lee Smith]

Confusing way to put that. Does this mean that you couldn't find the:

Site?

File?

Download the File?

The file wasn't useful?

Or something else.

Lee

[Raymond Gonzalez]

the file didnt help with what i want.

[mr_vodka]

Read the first link to the forum thread. I may have posted the wrong link to John's file. Here is the correct one, but its an older solution. As I said earlier, read the thread.

Correct Post

[Lee Smith]

Take a look at this script.

Link

[Raymond Gonzalez]

i read it too! but i dont know if im too newbie but i couldnt get it to work

[mr_vodka]

Thanks Lee for finding an example. :(

[Fitch]

FileMaker's Business Kit also has lists that sort this way.

A little bit about sorting: once you sort, FileMaker does retain the last sort order, you can see it if you go back into the Sort dialog box. However, there's no way for a script to get at that information and make use of it.

So, each time you sort, you have to make a note of whether you sorted ascending or descending. This is typically stored in a global field or global variable.

The data you store in the global can be the actual word "ascending" or it could be just "A" or "1" it does not matter. It's just a flag that you can reference in your sort script.

Also note that these older solutions, and even FileMaker's example, use separate scripts for sorting ascending and descending, and separate scripts for each type of sort. It's messy! But back in the day, you could only store ONE sort, find, and print setup per script. We no longer have that limitation.

Mmmm, sorry no time to post more right now...

[Raymond Gonzalez]

hey! thanks, but i think that the link is wrong, or is not a file u are trying to give me? thanks!

[Fitch]

The link is correct, but you have to request the download by filling out a form. It's painless and you get a nice freebie.