Database Reference
In-Depth Information
6.
Double-click the Sort Records script step
.
The Sort Records script step appears in the window's Script pane on the right.
7.
In the Options section below the Script pane, turn on “Perform without dialog.”
Without this option selected, you'd see the regular Sort window every time you run
the script. Don't turn on this option when you're writing a script that lets the user
choose a custom sort as the script runs.
8.
Turn on “Specify sort order.”
The regular Sort window appears, with Last Name and then First Name set up already.
As you know, FileMaker remembers your most recent sort order, but it's good practice
to verify
everything
when you're scripting. And if you want a different sort order, you
can change it and the script will remember your changes.
9.
Click OK to close the Sort window and then, in the Edit Script window, click the
Close button
.
FileMaker asks if you want to save the script's changes.
10.
Click Save
.
FileMaker saves the script and closes the Edit Script window.
11.
Make sure “Include in Menu” is turned on for the “Sort by Last Name” script
and then close the Manage Scripts window
.
Now that the Manage Scripts window is closed, you need some way to run the script
you just wrote. Look in the Scripts menu. It appears there, along with a shortcut. You
can run the script by choosing Scripts→“Sort by Last Name” or by using the shortcut.
TIP
Windows users can save scripts before closing the Edit Script window by choosing the Edit Script
window's File→Save Script command. Both PC and Mac fans can use the Save Script shortcut
Ctrl+S (
⌘
-S).
You've finished writing the script and it's time to test it to see if it works as intended. Unsort
your records (choose Records→Unsort) and then run the script.
