Cascading Dynamic Dropdown Select Lists

I have CB 1.9.1 on Joomla 3.3.1 for a Sporting Organisation website.

I am using Hikashop for Online Store to be available for Registered players only.

I started originally to use VirtueMart but as it was only limited to J2.x and lacked Front End Management features etc I moved to Hikashop and built the site on Joomla 3 platform.

I know that there was a CB Plugin for Virtuemart to sync the CB Users data with Virtuemart, but none for Hikashop.

Hikashop uses a 2 Special Zone Tables for Country and State Codes (A primary Table listing all State and Country Code information and a Link Table linking States to Countries).

When a User inputs their Address information into Hikashop, as soon as they choose a Country, the State Select field automatically updates the selection list, ie Choose Australia, then All Aust States are listed.

I wanted to sync my CB User Data with Hikashop, so I have just tested a CB AutoAction plugin that I wrote to Insert CB User Data into the Hikashop Address Table the values from the comprofiler table, which works fine for both updates and New User registrations. This then stops Hikashop from asking for Address details for the current user when they go to checkout.

Because of the way Hikashop uses this Zone Table for State and Country, I tried to setup two CB Fields cb_country and cb_state where you select your country first from the Zone Table (query Drop down (single select) Similar to your Tutorial Page.

I then I want to have the cb_state field (query Drop down (single select) pull the list of appropriate States which are linked to the Country chosen previously. ( I used in the select query for cb_state "Where Country_code = [cb_country]"

I understand that Until I submit the registration request CB wont add the user record to the comprofiler table, but is there a way to create a Dynamic DropDown Select List based on a CB Field (front end) prior to Update / insert record.

So for the moment, I have ditched the Country Field, and base the cb_state field to use a hard coded country code.

Or can you look at for CB 2 onwards, 2 x additional special Field Types for Country and State Codes.

Dynamic DropDown Select List based on a CB Field (front end) prior to Update / insert record.

No, such a feature does not exist. It would need to ajax and redisplay the field, but for that to work right it'd need to send the currently input data, which can become a huge problem for registration as the user doesn't actually exist yet. For this to work right you'd basically need a plugin that does nothing but implement such chaining for it to be reliable, which is planned for a future plugin after CB 2.0.

Thanks Kyle for the response.

I also have Fabrik installed and they have a plugin for Cascading Drop Downs for their forms. So if you are planning to have such a plugin planned for CB 2 that would be awesome.

Regards

It'd be a standalone plugin released after CB 2.0. It's planned. I just don't know exactly when I'll be able to develop and release it. First we need to get CB 2.0 Stable out then new releases for all our existing active projects and then I can begin new projects. This project is already on my list of new projects to develop.

Hi,

Is the development of the plugin is still expected?

Regards,

A chained address field plugin is still planned, yes. No new projects will be started until the plugin upgrades are done. I'm currently 70% done with CB Activity rewrite. CB GroupJive upgrade is next. Then I can begin new projects.