4 Replies Latest reply on Apr 6, 2017 3:43 PM by taylorsharpe

    Filter

    LSWilt

      How can I filter according to least and most amount donated?  And is there a way to see and print a list of all donors under a certain classification rather than searching through one by one?

        • 1. Re: Filter
          TSPigeon

          LSWilt

           

          If you are dealing with an entire found-set in Form, List, or Table View you'll want to check into Sorting Records. Performing a Find and then a sort could give the data for a certain classification.

           

          If using a Portal you can set the Sort and Filter via the Portal Setup. For more information on this, see Working with Portals - Displaying related data.

           

          I'm also going to move this thread from the FileMaker Developer Challenge 2016 Place to the Discussions Space where you should receive more views and potentially more feedback on this topic!

           

          TSPigeon

          FileMaker, Inc.

          • 2. Re: Filter
            kazznfx

            yeah, seems like you just need a slightly more advanced find request.

             

            FileMaker allows some pretty sophisticated searches including looking for ranges of data.

            • 3. Re: Filter
              Jaymo

              Sounds like you need two find requests. The first request would search the donation amount field for (if $10.00 was the least classification):

               

              <=10

               

              Then choose New Request from the Requests menu and add the second request (if $50.00 was the greatest classification):

               

              >=50

              • 4. Re: Filter
                taylorsharpe

                Yes you can search by classification and probably will want a list view layout to show all of them.

                 

                Regarding min and max, if the donations are in a related table, you can have two portals of that table and sort one ascending and one descending by amount and just show one row in the portal to see the max and min.

                 

                Or you can create an unstored calc in the Donor Names table like:

                 

                Let ( [

                     F1 = DonorNames::ID ;

                     F2 = "SELECT

                                    Max ( GiftsTable.Amount )

                               FROM

                                    GiftsTable

                               WHERE

                                    DonorID = ?" ;

                     F3 = ExecuteSQL ( F2 ; ¶ ; ¶ ; F1 ) ;

                     F4 = GetAsNumber ( F3 )

                ] ;

                     F4

                )

                 

                 

                 

                You can substituted "Min" for the "Max" to find the minimum gift amount too.  For minimum you may want to add to the where clause to only search through records where an amount is greater than 0.