At http://bubble.is/site/cpa I have inputs as filter boxes (couldn’t use autocomplete there since it doesn’t seem to be able to return its text value or a list of objects it finds [just returns a single one]) and the repeating groups under them use a :filtered expression (say a list of students of a class, or classes of a teacher or projects of a teacher) with the filter saying “contains Input Search’s value”.
Although this doesn’t have autocomplete at the filter box (not major problem), it has a real issue in that the repeating group contents disappear as you type in the filter a partial match of a text field you’re filtering against from the repeating group items
Say a have students
George Birt
John Abrahams
Jina Lobster
John Lambert
And I type “J”, I see nothing. When I’ve typed “Jina” or “John” (a full word), then I only see filtered list content
Is there any way around it? As it is now it isn’t much useful (and most users will think the filter just doesn’t work since they won’t bother type in a whole word)
Could contains have a parameter to enable partial matches or something? Or have a separate function?
Also could there be starts-with and ends-with functions?
Can I write my own matching function in some way? (preferably not in Javascript, unless an example is given on the UI that I edit [that is I don’t have to go to the manual to see the search method signature I need to define)
This is something we are looking at in the medium-term. Several other users asked for it and it makes lots of sense, it’s been delayed since it has deeper performance implications. We’ll look into starts_with and ends_with at the same time as this.
I just tried doing something similar today and the current_record.field_name CONTAINS input.text is acting more like a strict equivalence than a substring contains. I’m trying to get a type and real time search behavior similar to the iTunes store example that is using an external API (which does work correctly). However, with data in the database, I’m not able to get the right behavior. So I am adding my request in with the others to increase the demand. Modern UI for search should be near realtime as we type.
Would like to let you guys know that I too would love this updated to be able to perform more modern searches. I have a thing that requires me to be able to search on letters instead of words.
As I understand there is also no way of working around this until a proper implementation has been done?
Thanks for the suggestion @NigelG. I think that’s a bit too complex for the system I’m building right now though.
I’m afraid I’ll have to stick with word searches until then. Luckily some fields work quite nicely with a “Search box” to let the autocomplete do the rest, but that won’t work for all my fields, sadly.
@emmanuel, I appreciate all you do with Bubble. I am starting to love it more and more, and really think that what I am building can become a really good app. It’s very addictive to keep building, as I should probably do other work too, but am fully focusing on Bubble at the moment
Thanks Nigel, would that be the case for Dedicated hosting services as well where I assume you have your own DB? Thanks for the note on the :truncate . Its not a huge issue as I assume most users of an application would type in a full word and not part word but I know that I do it sometimes . Thanks for your answer
@emmanuel Any progress on that? There’s a patch for that, right?
Creating a new field and separate into block of small words, ie: Albert -> A Al Alb Albe Alber Albert
The only problem is still the first letter isn’t detected. Any suggestion?
