Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Ready to get started?

Help Files / User Guides

Review the new and improved user guides including instructions on setting up the Dynamic Forms module, explanation of features,  product information, and more!

 

User Guide (PDF)

 

Demonstrations

View Dynamic Forms Demonstrations

Dynamic Forms Video Tutorial

 

Trial Version

Get the Dynamic Forms Trial

 

Purchase Dynamic Forms

Dynamic Forms at Snowcovered

 

License Agreement

See License Options available.

 

Recently Viewed...

To help you navigate to pages you most recently visited, select from the links below.    
Installing Microsoft SharePoint Foundation (MSF)...
DotNetNuke 6.1 Installation Review

Dynamic Forms Demonstration 11- Dependent Combo Boxes


Save           

Dynamic Forms Demonstration 11- Dependent Combo Boxes

This demonstration illustrates the ability to create dependent, data driven dropdown menus. This functionality allows the user to select a category from a dropdown menu, which when selected, populates another subcategory dropdown menu with the subcategories of the selected category. When the user selects a subcategory, this then populates a checkbox list with all the products associated with the selected subcategory.

In order to implement this functionality we will do the following:

Create the Questions


1) Create the "Category" question and set the following properties:


  • Give it the name "Category"

  • Give it the shortname "Category"

  • Set the "Question Type" to "Combo Box"

  • Select "SQL Driven Options" under "Question Options"

  • Enter your SQL statement that will be used to fill the combo box

2) Create the "Subcategory" question and set the following properties:


  • Give it the name "Subcategory"

  • Give it the shortname "Subcat"

  • Set the "Question Type" to "Combo Box"

  • Select "SQL Driven Options" under "Question Options"

  • Enter your SQL statement that will be used to fill the combo box, making sure the "WHERE" clause looks like this, "WHERE fieldName = $(Category)"

  • Under "Advanced Field Options" check the "Hide until forced visible by question event" checkbox. This will ensure the "Subcategory" dropdown is hidden until the user selects a value from the "Category" dropdown.

3) Create the "Product" question and set the following properties:


  • Give it the name "Products"

  • Give it the shortname "Products"

  • Set the "Question Type" to "Checkbox Group"

  • Select "SQL Driven Options" under "Question Options"

  • Enter your SQL statement that will be used to fill the combo box, making sure the "WHERE" clause looks like this, "WHERE fieldName = $(Subcat)"

  • Under "Advanced Field Options" check the "Hide until forced visible by question event" checkbox. This will ensure the "Products" checkbox group is hidden until the user selects a value from the "Subcategory" dropdown.

 

Create the Question Events


1) Create a new question event that will execute when the user selects a "Category" and set the following properties:

  • Call the event "SelectCategory"
  • Select "Display hidden question based on another questions response" under the "Event Type"
  • Select "Category" from the "initiation/postback question dropdown menu
  • Check the "Execute event for any response" checkbox
  • Check the "Subcategory" checkbox next to "Affected Question"


2) Create a new question event that will execute when the user selects the "Subcategory" and set the following properties:

  • Call the event "SelectSubcategory"
  • Select "Display hidden question based on another questions response" under the "Event Type"
  • Select "Subcategory" from the "initiation/postback question dropdown menu
  • Check the "Execute event for any response" checkbox
  • Check the "Products" checkbox next to "Affected Question"


When it's all setup and working properly it should behave like the demonstration above.

 


 

tip6.gifWould you like to setup your form just as this demonstration is setup? If so simply download this template and copy it to your DNN Portals Home Directory to use the IPORTABLE feature of the module (Select Import Content from the module menu and import the template):

 

Feedback Comments

Feedback

 
 

Join our mailing list...

Get current news and events the easy way
 
 
   
Subscribe Me

Recent Blogs...

 
Copyright 2005 - 2011 by Data Springs, Inc.
 
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi