Multiple address as separate listings in Geocoder proximity search results

6 posts by 3 authors in: Forums > CMS Builder
Last Post: December 5, 2018   (RSS)

By Dave - November 28, 2018

Hi Jerry, 

The issue is that geocoder only supports one lat/lng value per record.  So having multiple addresses per record won't work.

What about having the addresses in a separate section and searching on that?  Then you could use a "related records" field under accounts to list all the related addresses?  

Dave Edis - Senior Developer

interactivetools.com

By gkornbluth - November 28, 2018 - edited: November 29, 2018

Hi Dave,

Thanks for looking at this.

That's kind of what I expected. Unfortunate though...

Thanks to Zicky's excellent Related Records examples in post 2241440, I've set up related records for a section called 'additional_practice_locations' with street, city, state, zip, and country information fields, and can populate them in the accounts record editor.

My next hurdles are:

1) To update the form I'm using now, which is based on the Edit Profile form for the website membership plugin, to allow the individual administrators of each multi location practice to use the front end form to enter their additional practice locations.

2) Then I'll need to figure out how to include these additional listings in the Geocoder search results and  multiple address map.

(Or were you suggesting that all addresses, whether the main address or additional locations be entered into the new related records table?)

Any pointers to get me started on the form issue?

Best,

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By gkornbluth - November 29, 2018

c

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By daniel - December 5, 2018

Hi Jerry,

Without being more familiar with the forms you're using it can be difficult to offer general advice on how to proceed and know that it will be helpful. In this case, I would recommend seeing how far you can progress and opening new threads for any specific issues/roadblocks you come across, and then we can continue from there.

Cheers,

Daniel
Technical Lead
interactivetools.com

By gkornbluth - December 5, 2018 - edited: December 5, 2018

Thanks Daniel,

Dave's suggestion to create a separate record for each practice location even though they're under the same corporate umbrella, so as to order to satisfy the geocoder plugin's requirements, has caused me to change direction somewhat anyway, so I'll pursue the new challenges in new threads.

I would have liked to have all of the practice location addresses in a single table, but that seems to be unwieldy given the geocoder's restrictions.

Best,

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php