Hello Good people of the bubble forum. I have a problem. I am creating a meal planning app. I need a search box to search meals. I have a database table which is Meals. I wish to search by ingredients. which is a column with a list of ingredients for each meal. These are the things i have tried unsuccessfullly.
I have used bubble search, but it is not case sensitive, so it might not pick up some ingredients if they are not in the right case or if the match is not exact.
I have used fuzzy search but fuzzy search considers the whole ingredients column (which is a long list of texts) as a single word so it’s almost impossible to get a match.
How can I solve this problem? Please help