How to implement lightning-fast case insensitive search in Bubble

[@brianrios93]

Amazing tutorial! It worked really well! Just to add more info, I tried with lowercase instead of uppercase, and it worked equally well. Also after the :lowercase in the arbitrary text box I added the operator :trimmed because when I was writting on the search box in my phone, the autocomplete of my phone added a blank space. For example I wanted to write "Brian" and with the autocomplete it wrote "Brian " with the space. I think is a better UX taking in account that many users write using autocomplete. The trimmed operator deletes the last blank space in a text, but not the space between two words. It worked really well with this. Hope it helps.

[@apollo_around]

This was a really great help, the best solution so far related to this subject. In 2 minutes I made the searches in my clients app much faster, efficient and reliable (bye bye weird plugins for this purpose). Thanks and congrats for your channel

[@CluedoYT]

Thanks a lot for tutorial. Sad you stopped putting more videos to the channel

[@ProSimples]

Wow, the best way to implement I've seen so far. Thank you very much.

[@thankgodjudah6553]

Thank you so much for this tutorial I still come back to it from time to time.

[@Me-ew6wz]

love this tutorial, solved my problem about search input, now i can put all my category. thanks in advance

[@___wij]

Quick question: What element were you using for your Search messages input element? Fuzzy search only allows text. The built-in searchbox only autocompletes for 1 data type. Just a text box then?

[@SanjayJha-r9e]

worked for me, thanks.

[@lionelttl]

Hey that was great help. I was wondering if you could do a tutorial on how to implement this search but with an external API instead? I'm having weird behaviours with Fuzzy Search plugin where it doesn't show the same matches are the data source. Often I just want to return the first item return from the Data source instead of needing to do a fuzzy match

[@matt-apollodev]

Hi Damian, I'd be curious how this "filtered" expression conbined with "advance" filtering in your RG performs for a list of 1000 to 10000 messages. In my experience, this is actually very slow above 100 records, but maybe this case is different. I'm asking because i'm looking for a solution for search of appr 10K records

[@___wij]

How do you include partial searches like 'fin' outputting 'finally'?

[@Robdotfer07]

partial searches work

[@patrickclaussenSOA]

Works perfectly, thanks!!!

[@SelinaOmlin]

Looks like an interessting solution. bit is it really fast with 20K entries in my database?

[@giovanniroos4417]

Well done and thank you!

[@cris24x7]

This is great! But I’ve noticed when you have lots of data such as messages, the search function becomes really slow

[@buildwithdamian]

yep, unfortunately, Advanced filters are also computed client-side... maybe one could save a capitalized version of the message and avoid the advanced filter

[@DesertGardenPrepper]

@@buildwithdamian I would love to see another tutorial on that!

[@user-ft2md2gd4s]

pretty impressive

[@AlBsharah]

Hey DJ, great video. Thanks for sharing how to do this. I've stumbled into an issue though that I can't make sense of. I've made it all the way to 7:29 in the video. Company Name (source text) -> Filtered -> Advanced -> Source text to UPPER -> Contains -> Arbitrary Text -> Search text to UPPER. The problem is that while case sensitivity seems to be removed, CONTAINS is not working. I have to type in the ENTIRE Company Name for this to work. But it works without case sensitivity. Any ideas? Super strange, I've doubled-checked everything countless times.

[@buildwithdamian]

Hi Al! Not sure what the problem is - maybe it just takes a second to do the filtering? as i found out in the meantime, the advanced search does not deal super well with large data sets, as its also executed client side...

[@AlBsharah]

@@buildwithdamian Don't think time is the issue. I've waited quite a while and the full-name search works quickly. Super odd.

[@plantplanner4773]

Love this detailed walkthrough 🙌 I would be interested to see if this could scale though. In my experience using the Advanced filtering slows Bubble down A LOT when you start getting more than a couple hundred rows in a table (which is very easy to do).

[@buildwithdamian]

yep, unfortunately, Advanced filters are also computed client-side... maybe one could save a capitalized version of the message and avoid the advanced filter

[@DesertGardenPrepper]

omgosh, I have been trying to solve this for 20+ hours! where's your donate button?

[@buildwithdamian]

much appreciated! don't have one though :)

[@michaelhale936]

Thank you!

[@99consorcio]

I love u!

[@Fadogar911]

du bisch schwizer, oder? :D

[@buildwithdamian]

Haha saisch ma khörts?