Forums

What I am trying is basic and I have followed the manual but it does not work. I have a form with 2 dynamic dropdown fields that populate from different tables. I want the 2nd dropdown to reload and populate based on the selection made in the 1st dropdown (I have not even begun to work on the where condition). The reload takes effect after selecting a value in the 1st dropdown but the 2nd field populates empty (it did have all the values before selecting something in the 1st dropdown). What am I missing here?

Hi vividial,

It sounds as if nothing is being returned by the AJAX query to get the new value. Please post a link to the form so we can take a quick look.

Bob

http://www.chvlny.org/index.php?option=com_chronoforms6&chronoform=tournament-division-details-create

HI vividal.

I'm not clear how the autocompleter works in CFv6 - what I see in the form is that what is being returned is this code

<div class="field " >
	<label for="division_id" >Division</label>
	<select data-events="[]" data-reloadurl="/component/chronoforms6/?chronoform=tournament-division-details-create&event=reload_division&tvout=view" name="division_id" id="division_id" data-mincharacters="0" type="select" class="ui dropdown" >
		<option selected="selected" selected="selected" selected="selected" value="" >
		</option>
	</select>
</div>

As you can see there are no options included here :-(

Bob

I looked through all the forum items and didnt see this problem. Is there a sample out there somewhere of a simple 2 field dynamic dropdown that works?

HI vividal,
There is a demo form in the standard CFV6 installation. This uses fixed option lists but you can replace those with dynamic ones loaded from a database table if you need to.
Bob

Ok so I forgot all about the Demos option...Do the Demo Dynamic Dropdown uses PHP to load the options for the 2nd dropdown. Is that how it is supposed to be done?

Hi vividal,
You need to create the option list somehow - PHP would be the usual way.
Bob