Search in a list of geographical addresses

I need to do a geographic search in a list of addresses.

I’ve a “offer” data type that contains a field “locations” of type “geographical address” defined as a list. The user can choose from a list of addresses which will be saved in this list field. Works.

Now I try to create a search page that is allows searching for offers near a location (entered in the search box).

When using “Do a search for…” in data source (of the repeating group) the list field (locations) is not available. When using “Search for offers:filtered” the “locations” field is available but Bubble don’t offer the “is within” option (because it’s a list).

It would work fine with “Search for…” when the field “locations” is not a list and contains only one value.

Also tried to define a data type “locations” and added this to the “offers” data type (relation) but that makes it even more difficult to access the location field (in this linked table).

To make it even more difficult, I should be able to initiate that search via the data API as well.

Any ideas?
Thanks in advance!

I just stumbled over this possibility. But it shows a type error (obviously it returns a number) and not a list of “offers”.

I have the same issue, were you ever able to figure this out?

Have you tried advanced filter?
convert your geo to text, then search the geo text that contains your search keywords.


This is how it works.