How to calculate the distance between two adress directly in server action

[franse]

Hey Morgan

@kryo91

how can I retrieve the response in order to store it in my database

You can use the Api action, check this topic from Max

Guide to Getting the Distance and the Duration from Google Distance Matrix

Hi, today I want to share with this awesome community how I did to get the distance between two coordinates that can be from a map, from a database or written by hand. First of all remember that if you are going to use it for a web app with a lot of traffic, Google is going to charge you a fee that can be little or a lot depending on the traffic, you can check the prices here: https://developers.google.com/ maps / billing / gmp-billing # dynamic-maps Ok in just 3 steps you will have this work…

Please note that too many request can means a lot of charges due to the cost of the maps api usage, check the google docs and be sure to use it wisely.

Hi Brian!

@Hyperbytes

you can calculate the distance between with an equation in a custom query

I remember trying something that you’ve mention in a post from years ago, but no luck, still working? Never got it running

Delivery zones/radius

Yes, i have a site online which uses that method serhat, works well: sqrt(power(69.1*(lat - “.$baselat.”),2)+power(69.1*(lng - “.$baselng.”)*cos(lat/57.3),2)) where $baselat and $baselng are centre and lat,lng are table fields (returns miles, not Km as I am in UK) Implemented before custom queries I may add so it is part of a custom piece of code, not tried it with the new Wappler custom query

I gues this is the best approach as you can avoid the cost of the api