AnsweredAssumed Answered

Radius Search by Postal Code

Question asked by olivervollmer on Oct 1, 2018
Latest reply on Oct 2, 2018 by fmpdude


I am looking for a way to find addresses in my db by entering a postal code and radius.

My tables:

- Contacts (postcode, city)

- Postal codes with geocodes (LAT/LON)

The both tables are related over the ZIP field.


I have created the CF GeoBoxBounds ( and it will calculate by entering a postal code and a radius. Now, I get in the calculation field 4 values:



Bildschirmfoto 2018-10-02 um 06.10.24.png


Now I would have to use a script over these values from the CF, in order to find the appropriate results.
But how should I build the search here?


I have attached an example so that my approach can be better understood.

Would be very grateful for help and support.