Better Search Capabilities for Database Field
Is there way to make the search function for the database dropdown menu more dynamic? It requires you to type the phrase in the exact order which is a little bit restrictive. For example, if I am searching for the name William Florin Smith, I cannot type in William Smith, because it is missing Florin, it will only show up if I type in William Florin. Is there a way to make the search a little more dynamic with the options it shows?
-
Chris Henning commented
Need to update the "Like()" Function to allow wildcards (* ,?) Current function only works with "Start with"
-
Michael Gallagher commented
Just in case anyone needs this, you can use % as a wild card, so in the example above, searching for 'William%Smith' would get you the correct result.
Would be nice if the search capability allowed you to simply search for 'smith' without having to manually add a wildcard.
-
AdminKelsey Griswold (Admin, GoFormz) commented
Allow the Database field to support Wildcard Searching.