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?
Tim Lee
shared this idea
-
Michael Makin
commented
Even though the % wildcard is a workable solution, it would be much easier if the default search was a "contains" search instead of a "starts with" search. For example, we have a datasource with a list of companies (by their formal name). However most of our form users users don't know the formal name, they know some part of the name or, if the company is doing business as (DBA) another name, it is difficult for them to search for the name they are looking for.
For example, say the formal company name is "John Doe Company, LLC DBA Ace Contractors". The form users (field staff) only know the company by "Ace Contractors" (the DBA name). But if they search for "ACE", the results don't show up (unless they know how to search with the % wildcard, which can be a challenge for blue collar staff). Anyway, if the search capability could be improved to a "contains" search without the use of wildcards, it would be really helpful to us -
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.