Dynamically Filtering Filtered Portals
A blast from the past (all the way back to 2013!), but still a great technique for smaller databases, this filtered portal is easy to use and will filter multiple fields. Read the comments for some speed enhancements and an faster alternative. The best part: You can use your existing portal and just use the Filter Portal checkbox in the portal setup. Free FileMaker Example File at the link.
Caution: Do not use with tens of thousands of records unless you limit the number of fields and change it to update on field exit (or use a script timer to allow multiple character entry). Best not used on a cloud solution, either, but does work with smaller data sets.
Kudos to Sara Severson for this technique:
Who Needs Snow to Ski?
This in one of the most incredible videos I have ever seen...this guy skis everything including the Great Wall of China!
LOCATE DATA WITH LOGICAL PRECISION
I've played with Logicator and love the concept for some applications:
LOgiCATOR builds on the immense power of FileMaker’s native Find mode, and wraps that power in a sleek and intuitive interface. Gone are wonkish operators and confusing find and omit requests, replaced by plain language prompts and options.
It's easy to bolt on, powerful...and free. Can't ask for more than that. Free FileMaker Example file at the link.
Source: beezwax > products > logicator