GeoPlugin - Relational Data

4 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: May 26, 2011   (RSS)

By ILLUME-MEDIA-LABS - May 24, 2011

Hi,

I wanted to know how to create relational fields in the backend section? Basically, I have created a section for restaurant listings and have acquired a db of all zip/city/states in the U. S.

I want to make it easy on my editors to add entries in the system.

For example, when adding an entry, if the zip code is added first, cmsb would auto populate the city & state fields (in dropdowns), or when a state is selected in a drop down, the next drop down would automatically narrow in on the cities only in that state, and once a city is selected, the zip drop down would only show the zip codes for that particular city.

Any help would be appreciated.

Regards,

Javed Ali.

Re: [Illume Magazine] GeoPlugin - Relational Data

By Jason - May 25, 2011

Hi,

Depending on how you are storing your information, you should be able to accomplish this using drop downs and the "Advanced Filter" option.

Take a look at this post:
http://www.interactivetools.com/forum/gforum.cgi?post=83755#83755

Hope this helps get you started.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Illume Magazine] GeoPlugin - Relational Data

By Jason - May 26, 2011

Hi,

You don't need to use any if statements. You just need to put in your mysql query and choose your advanced filter field. Unfortunately, there isn't an easier way of accomplishing this in CMS Builder.

Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/