Filemaker's search is somewhat "relaxed"
the search for 1 month will find 12 month, because the text "1" and "month" are contained in the text.
you could either change the values you're searching for OR...
Create a script for doing the find, then just prior to performing the find, include the literal text "=" before the search is "performed".
Thanks. I'll just tell the ones using the solution to insert == before the search is performed.
1 of 1 people found this helpful
I would use a script trigger for this problem and have a script set your search field to exact search using same value as you choose, but with "=" before.
Set Field: YourSearchField to "=" & YourSearchField
This would give you the search result that you ask for
Script trigger should be OnObjectModify
The only problem with a script trigger is there are 32 other fields that the user may want to enter search terms on.
Depending in your fields, do you use the same Value List on all those 32 fields?
No. It's mostly the usual name, address, city, state, zip. Then other items such as check boxes.
You only need this trigger if you have more then one word in the value list. For State there is just one word, so no need for triggers and same for Name, Address, City and Zip.
Unfortunately there are fields that have more than one word. I noticed the Names field sometimes has First and Middle. There is one field that has Step 1, Step 2, etc. I'll give the suggestion a try, though.
Hi, Johan - North Carolina, South Carolina?
Usually State is short name of each state when it comes to Address
Yes. Luckily they are using the 2-letter state. That's something I'll keep an eye out for, just in case.
"relaxed" LOL, Peter.
it's FM's way of doing an AND search inside a field.
the default search is "begins-with" for a value (single word), so the search will find your criteria if it begins-with any word in your field, in any order.
add more than one word and all of them will be used for the begins-with (again in any order in the field), but applying the "AND" so that two words must both be found (begins-with) in a single field to match, for example.
where the words are positioned in a field do not matter (any order), so 'Joe Brown' search will also find (in a name field):
'Browning, Joe', 'Joella Susan Brown'
'Joe_Brown' // note this could be the sticky space (non-breaking) or actual underscore
I make heavy use of this feature.
your answer is correct, BTW!