Banging my head against the wall trying to do a simple filter.
I have 3 tables (things? )
I am trying to display a repeating group of the 10 closest Shops within 100 miles of my current location and have that filtered by only shops how have a value in inventory that is > 0 for a particular product. I have a drop down to change products.
I can’t seem to figure out how to filter out the shops that have 0 qty for a particular product. I also can’t seem to get it to work efficiently.
I tried to attack it from a repeating group of shops and inventory (it seems to be easier to tie inventory back to a shop vs the other way around, but it’s a list of shops so that seems the logical thing for the repeating group).
Feels like a simple ‘where’ db call, but I can’t seem to get it to work in the bubble “no code” UI