GeoPlugin - Relational Data
4 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: May 26, 2011 (RSS)
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.
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.
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/
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: [Jason] GeoPlugin - Relational Data
So I think it looks like extensive code in the advance query. Alot of ifs..
I thought there might be an easier way to build relational lists.
I thought there might be an easier way to build relational lists.
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
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/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/