not IsEmpty ( Filter ( FIELD1 ; "example_phrase" ) )
If you want ability to enter different phrases, create a global text (maybe called gSearch) and use gSearch in place of your quoted phrase. Then when you type your value into gSearch, your boolean calculation will produce 1 if found.
You could also use:
not not PatternCount ( FIELD1 ; g_search )
GetAsBoolean ( PatternCount ( text ; g_search ) )
You should use either PatternCount() or Position(). Filter() is not a good test to use here. Both:
Filter ( "i love mary" ; "mary" )
Filter ( "i love mary" ; "army" )
return the same result.
Note also that Filter() is case-sensitive.
Of course, 'FilterValues' would also work:
Not Isempty ( FilterValues ( FIELD1, "Example Phrase" ) )
Also, no need to use the If statement with the "True"; "False" choices, as any logic statement, like the one above, will always return either True or False.
'FilterValues' would also work
It would work if you are looking for a value, not a phrase.
Yes, but his checkbox value list will put each checked value on a separate line. Of course, his phrases must be in the form of values.
Humble question: What defines a "value" in Filemaker language? (what is a "value?")
In the current context, a "value" is an item in a return-separated list. In a checkbox field, each checked item is a value.