I am trying to match the look and feel of my dropdown menu as my input fields. But I have two dropdown menu: Country and Your Group.

Hi Michael,

You will have to go to Module Configuration and adjust the Stylesheet for this field type. For consistency, though, I would also use a combo box to give your country options (instead of the Country field type). You can populate it by adding something like this to the SQL-driven default value:

Select ‘ – Please Select –‘ as questionoption,’ –1‘ as questionoptionvalue
Union All
select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Country'
Order By QuestionOption

You might need to adjust to Order by Text and/or add your object qualifier in the statement.


Thanks,
Candace

Candace,

Do you know how to select United States as a default selected option if I use your code above?

Posted By Candace on 08-01-2012 02:07 PM
Hi Michael,

You will have to go to Module Configuration and adjust the Stylesheet for this field type. For consistency, though, I would also use a combo box to give your country options (instead of the Country field type). You can populate it by adding something like this to the SQL-driven default value:

Select ‘ – Please Select –‘ as questionoption,’ –1‘ as questionoptionvalue
Union All
select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Country'
Order By QuestionOption

You might need to adjust to Order by Text and/or add your object qualifier in the statement.


Thanks,
Candace

Also by doing this way, I lose the dynamic relationship between Country and Region field. How do I using this method and it change the region field based on the selection of the country?

Hello Michael,

When using SQL Driven options for a combo box, you can't really set a default. Here's what you should do:

1.) Add a combo box - Country SQL Driven
2.) Add a combo box - States SQL Driven
3.) Question Event that fires a post back. This question event doesn't really need to do anything other than invoke a postback.

This could be the SQL for your Country Combo Box:
------------------------------------------------------------------------------
Select ' – Please Select – ' as questionoption, '–1' as questionoptionvalue
UNION ALL
select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Country'
AND Text = 'United States'
UNION ALL
select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Country'
AND Text <> 'United States'
------------------------------------------------------------------------------

This could be the SQL for your States Combo Box:
------------------------------------------------------------------------------
IF '$(CountryComboShortName)' = 'United States'
BEGIN
Select '– Please Select –' as QuestionOption, '–1' as QuestionOptionValue
UNION ALL
select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Region'
AND ParentID = 221

END
ELSE
BEGIN
Select '– Please Select –' as QuestionOption, '–1' as QuestionOptionValue
END
------------------------------------------------------------------------------


Let me know if you have any questions.

Thanks,

Ryan

Hi Ryan,

Thanks for your help.

Doing your method is good but one minor problem is that if user select a country other than United States, for example: China then the State rRegioan) option is still a dropdown menu and user can not type in the text field because China has no state to select.

If I use Option Country and Region, I am able to do this task but I am stuck at the height of the Dropdown menu

Any idea how to do this?

Hello Michael,

Yes, use question events.

If Country = United States then Show the States Combo Box.

If Country != United States then Hide the States Combo Box.

There is a functionality in Dynamic Forms called "Question Events". You can create one or two conditional Question Events that only fire when Country = United States or not.

Stay away from the Country and Region question types. If you want to add customizations(Which you do) then you need to use regular Combo Box Question type. Use the SQL I provided you to achieve the same dependency that the Country and Region Question Types have.

Let me know if you have any questions.

Thanks,

Ryan

Ryan,

First of all, I am very much appreciated for your effort to help me. But after so many attempts to make it work the way your described and I still could not get it to work. I don't know why.

As I mentioned above, if the dropdown for Country is selected for country that does not have state like China, then I would like to replace the dropdown box State with an Input text field, where my users can type in. I am not so sure with your suggestion using Question Events above to do this?

I could never imagined how BIG of this problem is when it first started only a tiny problem originally. All I wanted is to remove that height: 20px; in the country box and it will solve my entire problem.

It seems to me that DataSprings staff does not have any solution how and where to remove that height:20px in a dropdown menu.

Please help

Thanks

Hello Michael,

Funny for you to say that, actually I'm the Sr. Web Developer at Data Springs.

I know this seems like a small issue, perhaps you can setup an example on our test environment www.betasprings.com

host / dnnhost

Once you have a page up and mimicking your scenario please copy/paste the URL here so I can take a look and provide a working solution for you.

Let me know if you have any questions.

Thanks,

Ryan

Ryan,

Thanks again for your quick response. I have setup a demo form and here is the link http://www.betasprings.com/DynRegis...fault.aspx

You can see that if I select any country other than US then the State field is still a dropdown menu. This is not good. Need to replace it with an input text field so user can type in.

Thank you for providing me the link:
http://www.betasprings.com/DynRegis...fault.aspx

You'll see that the Dynamic Registration States combo box is now working. Please let me know if the dependency is working as you'd imagined.

The dependency is all within the States Combo Box.

Let me know if you have any questions.

Thanks,

Ryan

Ryan,

From that demo, I can see that the dependency for United States is working. BUT what if you select another country like China, which has no states. Then what do you select in the State field?

I like it when I select any country besides United State, the States Dropmenu box will be replaced with a input text field so I can type in the text.

Hello Michael,

Question Events won't be able to accomplish this since we can't use a Not Equals condition.

You'll need to use JavaScript to hide and show the appropriate fields.

I provided the JAvaScript under Initial JavaScript.

This JavaScript needs to be in the Checkbox and Country "Client Side" section under Advanced Field Options

Just to note, the JavaScript is referencing ID"s on this Dynamic Registration module. The Id's on your form will be much different.

Let me know if you have any questions.

Thanks,

Ryan

Hi Ryan,

Hello Michael,

I was adding in JavaScript that would hide and show the State or Region Textbox Respectively. It seems that there's an issue with Dynamic Registration and the version of DNN on our test environment in which is preventing my JavaScript from working.

However I'm certain that you can take the JavaScript I provided and plug it into your own example.

If Country and Region question types do exactly what you want then why are we discussing this? LOL.

I thought you were having an issue with the height of your controls? Have you tried styling these fields to give them the look you want?

-Ryan

I thought you were having an issue with the height of your controls? Have you tried styling these fields to give them the look you want?

-Ryan

That is what I've been trying to do all along and do not know how to make my CSS style to work with dropdown menu (select) type

Do you have an email I can send you my link and you can tell me why I am not able to to style on my select field?

Yes you can email me directly at rbakerink (at) datasprings (dot) com.

Let me know if you have any questions.

Thanks,

Ryan

This issue has been solved by a professional staff at DataSprings, Ryan. He took the time to communicate with me via email and got it worked out well.

He actually added style to my form and it solved it

Thanks Ryan

You're more than welcome Michael, I'm glad that I could be of assistance to you.

-Ryan