2 Replies Latest reply on Dec 14, 2010 6:03 AM by TommyFisher

    Search status

    TommyFisher

      Title

      Search status

      Post

      Hi, I'm looking for a simple way to show that the user is currently in search mode.

      I have created a field in the table I want the status to show with the following calculation:

      If(

      Get(FoundCount)  = Get(TotalRecordCount);

      "";

      "Search Mode"

      )

      I only get a blank field in browse mode both in out out of a search.

      Many thanks for any input.

      Tommy

        • 1. Re: Search status

          Tommy Fisher:

          Thanks for posting!

          Your calculation is correct, so I suspect that it's storing the result. To change this, go to File-> Manage-> Database and click the options button for your calculation field. In the lower right hand corner, you should see a button named Storage Options that you want to select. Once you're in there, check the check box that says "Do not store calculation results -- recalculate when needed". This should resolve your issue and show "Search Mode" in that field whenever you're in a found set.

          TSBear

          FileMaker, Inc.

          • 2. Re: Search status
            TommyFisher

            Works a treat! 

            Many thanks