I’m working on a search feature in my Bubble app and need some help with implementing an advanced list filter. Here’s what I’m trying to achieve:
Goal: When a user searches for “john instagram,” I want to extract User data that contains both words (“john” and “instagram”) in any of the specified fields.
User Database Fields:
user_name (text)
tools (List of Option set - tools)
body (text)
Desired Output: For instance, if the user searches for “john instagram,” I want to filter out users whose user_name contains “john” and whose tools include “instagram.”
Example Scenario:
User searches for “john instagram”
The search should return users where user_name includes “john” and the tools list includes “instagram”
Could anyone guide me on how to set up this advanced filtering in Bubble? Any tips or examples would be greatly appreciated!
If you set it up right it’s pretty easy. (Warning if you try different workarounds you may end up with a total cluster$%^&*).
Create a text field “search data” (or a new dataset if youre gonna have 500k+ records) and dump all data that has to be searchable in it (e.g., username, tools (as text), etc. :lower case). Use DB triggers to update search field whenever any of the relevant data changes (if there are many ways for it to be changed; if just a few, update search data field at those entry points).
Then for the search just search the search data field for EACH seperate word (lowercased) in the searchbox and display the results that have each search term
Update: Solved the Advanced List Filter Implementation
Hi everyone,
I wanted to give an update on my previous question regarding the advanced list filter implementation. After some testing and experimentation, I was able to successfully implement the desired functionality.
Thank you to everyone who took the time to read my post. I appreciate the support from this community!