You are right, we only do whole-word matching, mostly for technical reasons. We do plan to add partial matching to Bubble, and as more users ask for it, we have to consider the right time to build it.
After thinking I was doing something wrong with searching - I’m new to this and learning - I found this thread. Now I know it wasn’t me! Could definitely use a wildcard search as often a user can misspell something when entering it and not find it when searched for even when they know it’s there. Makes for a frustrating UX so one up the vote for wildcard search.
As said in another recent post, were in the middle of a backend upgrade, we’ll see what we can do after (2 months is probably conservative but we’ll see).
Please count my vote in. I seriously need this too. It’s really important when we have a database on another Bubble account of 15,000+ records and the users really need to be able to do partial word searching.
Yeah. I was actually quite surprised that this was not available.
Anyway what I do while waiting for a final solution is use a Searchbox for each field I want to search and link the search of the group to the value of the searchbox.
The searchbox has simple “partials” provided you are looking for Robert using “Ro” but not “bert”
Constraints:
Searchbox is fixed to one field. You can’t merge several fields.
It won’t show Robert if you are typing “bert”
It doesn’t search either for the email standard field in user. If you want this you need to copy the standard email content into a text field.