2 Replies Latest reply on Dec 21, 2011 11:15 AM by NickJudson

    Sorting Filemaker



      Sorting Filemaker


      I use filemaker for keeping track of orders at work. We have a progress section, that has the following values;Quoted,Received, In Progress, Shipped and Picked Up. We want to hide records that have the status of "Shipped" or "Picked Up" so we can view our current ones easily in table view. But then we also want to be able to check the old ones incase a customer is requesting the same type of procedure.


      Thanks in advance!

        • 1. Re: Sorting Filemaker

          Just a picky point: This isn't sorting it's querying or filtering your data....

          Much depends on  your layout design, but the basic methods for doing this are to perform finds that specify the records with the desired status or, if using a portal, set up a portal filter or filtered relations so that records of a different status are excluded.

          In either case, your old orders are still present in the database and you can either perform a different find or use a different filter to access them.

          Here's a script that will bring up all orders that are not "Shipped" or "Picked Up"
          #Perform steps on layout based on Orders table
          Enter Find Mode [] //clear the pause check box
          Set Field [Orders::Status ; "Shipped"]
          Omit Record
          New Record/Request
          Set Field [Orders::Status ; "Picked Up"]
          Omit Record
          Set Error Capture [on]
          Perform Find[]

          That script can be run from a layout based script trigger such as OnLayoutEnter or from a navigation button that takes you to this layout and then performs the above script steps.

          Here's a script that constrains the current found set by omitting old orders:

          Enter Find Mode[]
          Set Field [Orders::Status ; "Quoted" ]
          New Record/Request
          Set Field [Orders::Status ; "Received" ]
          New Record/Request
          Set Field [Orders::Status ; "In Progress" ]
          Constrain Found Set []

          You can use the OnModeChange script trigger to perform this script when the system leaves find mode so that user initiated Finds are automatically filtered to exclude the old orders.

          • 2. Re: Sorting Filemaker

            Thank you very much! Just what I was looking for!