CB Field - Select Country

I'm trying to marry my cb user fields with mijoshop/opencart customer fields. I have the mijoshop developer insisting that the state/province field cannot simply be a single select drop down as I currently have.

He advises my cb_country field is now compatible (thank you), however I need to be able to have a similar Query Drop Down for state/province (province_iso_code), as is used, I presume, for the CB Subs Geographical Country and State / Province entries forming a Geographic Zone.

Can I achieve this for a cb user field?



<select aria-invalid="false" name="province_iso_code" id="province_iso_code" class="form-control" title="province_iso_code|The State / Province is optional.">
<option value="" id="province_iso_code__cbf0" selected="selected">All</option>
<option value="AU-ACT" id="province_iso_code__cbf1">Australian Capital Territory</option>
<option value="AU-NSW" id="province_iso_code__cbf2">New South Wales</option>
<option value="AU-NT" id="province_iso_code__cbf3">Northern Territory</option>
<option value="AU-QLD" id="province_iso_code__cbf4">Queensland</option>
<option value="AU-SA" id="province_iso_code__cbf5">South Australia</option>
<option value="AU-TAS" id="province_iso_code__cbf6">Tasmania</option>
<option value="AU-VIC" id="province_iso_code__cbf7">Victoria</option>
<option value="AU-WA" id="province_iso_code__cbf8">Western Australia</option>
</select>

CBSubs Tax provides a province database table as well. The below should probably work fine.

Field Type: Query Drop Down (Single Select)
Query: Value Column: province_iso_code
Label Column: province_name
Group Column: country_name

I'm getting very close... the state/province drop down works, however it lists the state/province of every country. This is despite having already selected a particular country in my cb_country field.

Is it posible to make the field dependent on what country has been selected so that only that country's state/province is displayed. (as does the CB Subs Geographical Country and State / Province entries).

Perhaps I need to rename my field? cb_state

It's possible, but it won't ajax update. This means the page has to be reloaded after changing the country. You'd have to add a WHERE statement to the query to filter it down to just the selected country.

Can you please provide me with the actual WHERE statement and how I should add it?

Strange how it won't ajax update! Why can it be achieved when selecting a country in CB Subs Geographical Country and State / Province entries and not in this instance?

Can you please provide me with the actual WHERE statement and how I should add it?

Please understand I am not here to provide you with custom coding. I've provided more then ample examples to fit your needs. If you should need any further custom coding needs consider consulting with a contracted developer as needed.

See the below for adding a where statement to filter the selection to currently selected country. In the previous example it stored by country name so this needs to be filtered by country name.


Adjust cb_country fieldname to whatever fieldname your country field is using.

Strange how it won't ajax update! Why can it be achieved when selecting a country in CB Subs Geographical Country and State / Province entries and not in this instance?

Because we have no fieldtype implemented to handle that very specific case. That's hardcoded into CBSubs. I already have a future project planned to create a chained fieldtype to provide this functionality, but I won't be starting any new projects until after the GJ rewrite that I am currently working on.