Unable to search for a list of items (Database and Repeating Group search)

Need help Database
1

I have two data types.

  1. Food item
  2. Biz

The food data type has a field in it of type biz.It’s also a list. It’s basically a list of the different businesses that sell that specific food item

My goal: I want the user to be able to search for food items that are sold by X business. In other words, the user types the business name into input box A and the repeating group will then should show food items that have that business.

The problem lies here in the repeating group. See red.
image

I can not tell Bubble to check the inputted value in box A against the Food item’s Businesses List Test field (list).

Any ideas?

This is what the database looks like

image
image1176×173 21.8 KB

See how Food Item: Spicy Carne Molida has as a field Businesses List Test, which are the biz that have that food item? I’m unable to filter through that field.

2

What type of field is “Business List TEST?”

4

It’s type Biz, which is another data type

5

If I understand your issue You could do it this way.you could Make the Repeating group a biz , but ensure that each business has a list of food items they already sell added to their profile or you have it linked in the database e.g under biz , one of the data types you have is 'a list of food items sold by biz" . then you can add a constraint where business name for example contains or equals input A’s typed text . I am not the best at explaining via text but I hope this helps…

1 Like