1 Reply Latest reply on Oct 20, 2008 5:39 PM by rmanook

    how to use sorting



      how to use sorting


      I am using filemaker pro 9  database- Student Record.  I need to know how to sort by grade only.  I can sort by grades which all grades appear on a list by ascending order, but I would like to be able to sort and print by a partiuclar grade only.  I have video tutorial but still do not get it.

        • 1. Re: how to use sorting

          Hi KSsecretary,

          Thanks for posting!  As you have seen, the Records > Sort menu does not include an option to specify found sets.  Instead, you might want to perform a search or 'Find' (select the magnifying glass icon or View > Find Mode) for the particular grade that you want to view prior to sorting.


          Alternatively, you can try adding a button on your layout that would perform a script to automate this for you.  Here's one way to do so:

          1.  Go to Scripts > Scriptmaker > New

          2.  Choose the 'Enter Find Mode' script step.  Keep the 'Pause' option checked, and the 'Specify find requests' option un-checked 

          3.  Choose the 'Sort Records' script step.  Check the 'Perform without dialog' option and check the 'Specify sort order' option.  Choose your 'grade' field and how you want the 'grade' field to be sorted.

          Your script will now look like this:

          Enter Find Mode [Pause]

          Sort Records [Restore; No dialog] 


          Save your script and add it to a button.  Now when you click on the button, you will enter Find Mode, you will enter the grade value that you want to print, FileMaker will find that specific grade and then sort the records accordingly.


          Hopefully this helps or at least gets you in the right direction.  Let me know if you need further clarification.




          FileMaker, Inc.