Kryptronic Software Support Forum

In theory, you could edit the proper columns (ids will all end in '.stateprov') in the core_formfields table via Raw DB Admin.  In the 'fieldinclude' column, for each of those '*.stateprov' ids, enter 'core:formfield_stateprov.php'.  Next, copy the file {private}/core/CORE/includes/formfield_select.php and save the copy as {private}/core/CORE/includes/core:formfield_stateprov.php.  Now you have a file you can edit that is directly tied to the display of the stateprovince form fields.

The next step would be to add JavaScript (see the bottom of the file for info on how to do that) that recognizes a change to the '*--country' field in the same form and adjust the display of the '*--stateprov' formfield based on that.  It would probably be best to set up the stateprov form field as a text field and then emulate a select (when you need it) that updates it when the text field is hidden.

No, that's not what I meant at all.  I meant to just do that for the fields in there that currently end with 'stateprov'.  You're basically setting just those fields up so that instead of using the global select field coding for presentation, they'll use a custom include that you have control over.  From that point, you can use JS in your include to do whatever you like based on choices made elsewhere in the form, specifically with any *country fields.

Yes.  I apologize for not being clear here.  I want to see you succeed with this.  The fieldinclude column.  Use a value like 'ecom:myinclude.php' and then save your file to /private/apps/ecom/ECOM/includes/myinclude.php.  Start out by making myinclude.php with the same content as /private/core/CORE/includes/formfield_select.php.  That's your starting point.

On thinking about this a bit more, you will want your controls in the country field, as that's the selection that will alter the stateprov field.  Sorry about that.  Change up a bit and do the same thing you just did with the country field, and back out your stateprov changes.

You're off to a good start otherwise.  Here are a few more tips.  When doing JS in CCP, we use jQuery specifically.  You can see at the bottom of your include how an auto-update is handled via JS.  Basically the jQuery code is written and then appended to the core.js_docready global array:

$js_docready  = 'jQuery(\'#some-id\').change(function(){';
$js_docready .= 'some js code here';
$js_docready .= '});';
$this->append_global_array('core.js_docready',$js_docready);