1 Reply Latest reply on Jul 27, 2009 8:23 AM by TSGal

    Posting found search count without conducting a search

    trialuser1111

      Title

      Posting found search count without conducting a search

      Post

      Is there any way to calculate/display the count of found records from a search without displaying the actual results?  Or some kind of workaround?

       

      I have a layout, "Find Contacts" designed to help other users do their searches.  When you navigate to it, it automatically enters find mode, and users are given all the fields they may want to search from.  Due to FileMaker's search limitations, multiple requests are very common for the searching we have to do.  So I'd like to make it easier for people to see how many records match their given criteria each step along the way before they view the final results.

       

      For example, if someone searched the table of 1000 contacts, and added the request to find records where Contacts::Title is "Analyst", the layout might spit out "200 records" and if they made the additional request to find records where Contacts::State is "MA", the layout would spit out "25 records."  Visually, this is how it might look like this:

       

       

      >Find Contacts                             1000

      >Title: "Analyst"                             200 (Edit)

      >State: "MA"                                   25  (Edit)

      >                                                         (View Results)

        • 1. Re: Posting found search count without conducting a search
          TSGal

          trialuser1111:

           

          Thank you for your post.

           

          One way is to create global fields for each field.  Then, you can evaluate each field before issuing a Find and place that information into another table.  Then, before you issue the Find, you can store the results - using Get (FoundCount) - into the other table.  The Find is executed using the global field and the results, along with the field, are placed into the other table.  For each successive request, you can add a record into the other table with the field and results.

           

          This should get you pointed in the right direction.

           

          Does anyone else have another suggestion?

           

          TSGal

          FileMaker, Inc.