not tested but maybe this will work. On the table with the target multi select field, make a new field called [Multi Select (text format)]. The formula will be
ToText([My Multi Select Field]) & " ;"
note that I added a space semi at the end.
Then create a field on the "Parent" record "This record" with the formula
[my text field looking for a match] & " ;"
see if we get proper non exact matches using those two new fields.
The point is that you are no longer matching on "test" but are now matching on "test ;" which is different from "testing ;"
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Genius!
Thanks, as always, Mark!
One more update in case anyone needs to do this in the future --
use Mark's formula but include a special character at the beginning of your strings as well, in case you have values like "testing", "test", and "ting"
