Searching in FileMaker using "strings"

Discussion created by fm_buff on Sep 20, 2013
Latest reply on Sep 21, 2013 by PeterWindle

In my years of playing in Filemaker, I have never been able to find a "canned" solution that provides a basic string search feature that works the way I want it to. The FileMaker Quick Find feature is close, but doesn't work if you are searching for part of a word or number - can't find "rings" in the word "strings" for instance. Of course, you can simply go to a specific field and type using quotes the text "rings", but the search of that field will return results for that field only. Doesn't really get me the results I want and I still have to types in the "" everytime. I want the search to look at multiple fields within that table and then show me where it found those occurrences with yellow highlights. Kind of a lightweight Google search or similar to how you search Word documents in Microsoft. This is what I came up with to do that. Probably is not the most elegant way of doing it, but it seems to work. I was thinking about trying to expand the functionality to dynamically display only those fields that contain the data I'm searching for. Again, like Word from Microsoft.


Let me know what you think.