Hi,

Does the latest version of Dynamic Forms (v2.3) has a feature that supports Dependent Lists (like Country and Region)?

1. Selection of a particular value from a Car Makers list should populate Car Models of that Maker in the next list

2. Selection of particular Model should populate options in tyhe next list, etc.

3. Earlier, this was implemented using Question event + hide / display feature. This requires creating static lists for all possible makers, all possible models, etc.  and hiding or displaying them based on the selections. Instead of this way, is ther a more cleaner approach (just like DNN's Country >> REgion dependent lists)?

4. Simple shopping cart form:

    Is it possible to have "Price" displayed in a text box dynamically based on the product selected in a list box? For example, there is a simple form with three columns:

Product (list box),  Size(list box),  and Price

if I select Product A from the product list, and "Large" from the size list, I want a certain amount to appear automatically as the price. (may be based on a table or some hard coding)

So a combination of Product name and Product size determines the price.

Like this if there are 10 rows of product selections, we should get 10 amounts in 10 rows.

A grand total row should display the "addition of all the amounts" in the 3rd column. Possibly we may implement a discount (percentage based on the number of products or certain combination of products and sizes)...

After submitting the Form, the user should see PayPal, or GoogleCheckout page with the Total amount.

Has anyone implemented a similar application? Any ideas / suggestions, please?

Here is a sample form implemented in ASP and Javascript.

http://www.sathyasaicenters.org/ncr...r2007b.asp

Thanks a lot in advance!

Hi.

As far as #1-3.

In v2.3 this is still handled in a question event. I am not certain how it previously worked but you can use SQL/Lists currently and also use dependent SQL/lists. For example you can create the lists in DNN under Admin, Lists. Maybe create a new list called 'Auto' and another called 'Year'. Make the first question use SQL with something like this:

Select Text as QuestionOption, ID as QuestionOptionValue from Lists where ListName = 'Auto' Order By QuestionOptionText

This will use the Auto list to fill the combo box. You should name the short field name for this field something like 'MyAuto'

Next... You can use a query such as

Select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName = 'Year' AND ParentID = '$(MyAuto)'.

This would then pull in all years that have the parentID for the auto question. This is basically what you wanting to do and doesn't use static lists and also uses the same DNN Lists logic. 

Is this what you are wanting?

On the last question, #4: We are working on a merchant/paypal module (currently in development, should be released by the end of Summer). This module will have full integration with Dynamic Registration/Dynamic Forms to work as a checkout module for Paypal/Google/Authorizenet. Although the module is currently in development there are several integration options you can use before its released. We demonstrate this using our Tailored Text/HTML module, there are probably other 3rd party modules that can work as shopping carts as well.

Here is a full demonstration of this integration:

DotNetNuke PayPal Integration

Right now there is no way to show the 'Total' on the first page. We would like to eventually roll this out as a client side event/AJAX event as we do not want to have the form have to post back in order to show the updated total (this should be a javascript/client side implementation that operates much faster).

Anyway, hope this answers all of your questions.

-Chad

Hi Chad,

I tried your code snippets... they work!  I am able to implement "dependent lists"  in two different ways. There is a difference between these two ways:

1. Static Lists; question event; created a master list (Auto Maker); for each value within this list, I created a static list. For example, Ford, Honda, Toyota are the values in Auto Maker list . I created three separate lists with no LINKAGE to parent. (normally hidden)

- Models of Ford (Taurus, Mustang, Escort)

- Models of Honda (Civic, Accord, Pilot)

- Models of Toyota (Corolla, Camry, Avalon)

I used Question event to "show the hidden question" mechanism to display relevant list when a particular value is selected in Auto Maker list (main list). This works well with instant response - without having to click the SUBMIT link.

2. The SECOND Way: I implemented a set of Parent - Child lists (with same data as above). I used your SQL scripts. I am able to achieve the same Result; but... I need to click the SUBMIT link in order to see the change in the child list based on the selection in the parent list.

Is there a way to achieve the desired result without having to click the SUBMIT link? Just as in the 1st example above, I want the child list to be populated with the correct set of values as soon as I select a value in the parent list ?

3. One minor issue with scheme 1 above: When the form is displayed for the first time, the first value in the list is displayed in the master list. Let's say "Ford". the corresponding list not displayed until I make an explicit selection in the combo box. That means, I had to change the default "Ford" to "Honda"  and get the "Honda Models" list displayed instantly ; and select "Ford" again to get the "Ford Models" list displayed. It appears this logic is working ONLY "on change"; but not at the time of loading the form for the first time? Or, I should have a dummy value such as "select one" as the first entry?

I am VERY Glad  that I am able to implement "dependent lists" now!

Thanks a lot for your prompt  help & support!

VR