URGENT: Will pay for help! Do a Search for Thing within a certain driving distance (Google Distance Matrix API Plugin)

maze · 2021-01-11T19:03:39.734Z

Hi all,

Thanks in advance for your support! I’ve spent quite a lot of time in bubble, yet I feel like I’m making a simple error that I just can’t resolve.

I am creating a food marketplace similar to doordash, that I am launching in 3 days, but encountered a problem that I need to solve by using the Google Distance Matrix API.

I am trying to display “restaurants” in a repeating group. I only want to display “restaurants” that are within a certain driving distance to the customer’s delivery address (using the Google Distance Matrix Plugin).

To calculate the distance between 2 points using the plugin you simply choose: dynamic data - Google Matrix API - input origin address & destination address.

The problem arises when I try to set the constraints in the search for “restaurants”.
“Distance Max in km” is a value set by the restaurant to specify how far they want to deliver. So I set that to ≤ the calculated distance value.

Bildschirmfoto 2021-01-11 um 19.44.181404×712 80.1 KB

When I try to calculate the distance from “customer’s address” (=SearchBox Address complete’s value) to “restaurants address”, I cannot find the dynamic data option for “restaurant’s address”.

Bildschirmfoto 2021-01-11 um 19.47.051410×1090 151 KB

Does somebody has an idea how to solve this - maybe a workaround - or maybe I am doing something wrong.

If someone can help me solve this it would save my day.

Thanks in advance for everyone who reads this & tries to help me.

Have a great day.
Manuel

edward.w.douglas · 2021-01-12T18:43:28.211Z

Hi,

I think I may have a solution for you using the built in distance function. You will need Google Geocode API key. I have not been able to test this but it may give you an inspiration.

image1270×668 29.9 KB

maze · 2021-01-12T19:41:45.777Z

Thank you so much @edward.w.douglas for your help!

I was able to solve it using :filtered .

Awesome thanks a lot.

nocodeventure · 2021-01-12T19:46:15.474Z

a filter always happens after the search, so try to see if you can do it inside the search itself. Make sure you use the less than or equal operator ( <= ) , instead of less than.

maze · 2021-01-12T20:07:51.645Z

Yes, using ( <= ) may be a good idea

Do you guys also have an idea how to decrease API requests to google? To make a rough calculation: like this if I have for example 1000 restaurants on the marketplace each user’s search means 1000 requests = around 8€

I was thinking about grouping the addresses to addresses near them or to only search for restaurants that ship to specific ZIP codes (also needs to be specified in advance by restaurant owner…)

what do you guys think about this?

Nevertheless thank you both a lot for your help.

nocodeventure · 2021-01-12T20:25:58.298Z

DistanceMatrixAPI

DistanceMatrixAPI: The Smart Alternative to Google Distance Matrix API

Obtain the shortest routes and most accurate predictions using historical and real-time traffic data. The best Distance Matrix API provider.

Est. reading time: 5 minutes

maze · 2021-01-14T07:35:31.177Z

@nocodeventure thank you a lot. This will help me to reduce costs by a lot!

nocodeventure · 2021-01-14T09:34:18.972Z

About 90 percent indeed, you’re welcome.

edwinbolanosb · 2022-07-08T17:57:34.089Z

@nocodeventure ,
Is it possible your share “The Smart Alternativa to Google distance matrix API” please.
Thanks,