1 Reply Latest reply on Jan 25, 2014 11:30 PM by philmodjunk






           Hi, I'm new to filemaker and am looking to make a search bar for the top of a layout that will return the results but when blank and validated will return to all results "sorted by initial" 

           I have a "contacts" DB setup. Im able to use the search to find the entries but  Im not sure how to "show all" without adding another button. Im making this as a iPhone layout so it needs to stay minimal. and I'm really looking to display sorted by initial all the time. should be easy I'm just a bit new. thank you

        • 1. Re: Quickfind

               Is your value list a custom value list or did you set it up with "use values from a field"? There are a couple of ways that you can introduce what I refer to as "control" values into the value list--even if it is based on values from a table. A script trigger can then perform a script when you select from the value list and this script can do different things if the value selected was "-All-" than when it selected value to use for performing a find.

               For table based value lists, here are two ways to add a control value to the list:

          1.           Add a record with the control value in the field where you'd otherwise have the name. That can work fine for tables dedicated for use in a value list, but if the table is also used for other purposes, you may need to exclude those added records and that can be a problem.
          3.           Define a calculation field in the value table defined as: List ( "-All-" ; ValueField ) and update your value list to list values from this calculation field instead of ValueField.

               It's a bit ironic. I've been doing this exact thing for an iPhone DB just an hour ago and posting this message is pointing out to me that I've been focused on the first option when the second might be a better choice for my particular design.