<!--[if gte mso 9]> Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

<!--[if gte mso 10]> For Dynamic Fields I have the ability to use the setting to retrieve and pass values of the questions to a session variable.  I have a lengthy form that I split up into 3 smaller forms and I am passing the values to session variables because the very last stage of the process is a single form that has all of the fields and allows the user to review and make any changes to the information before submitting the form. I have some Question Events setup that will show other fields based on a response from other fields.  Since I’m passing values to this form via a Session variable is there some way that the Question Events can fire when the form loads? If Question A’s value is 1 and I have a question event to show Question B if Question A’s value is 1, can this question event get fired when the form loads? 

 

I want to make sure that the appropriate questions are displayed when the page loads rather than showing all the questions.

 

Josh,

Check out this thread and see if these help. I think you have to use the parameters (querystring) of DSParam1 thru DSParam3 to fire the events (or maybe that is only with SQL). Or, DSSession1 thru DSSession3 for session variables.

Question Events w/ Upon Form Load

 

-Chad

 

I think that this will get me closer. I have about 12 fields or so that I would potentially need to show. Using the techniques in the thread above, how can I scale it so that it would work with 12 or more fields, since there are really only 6 parameters that I can use, 3 session and 3 query string?

Hi. Well I am not sure, I think those are only required when you are reference them in actual SQL queries for question events, you should be able to reference other short field names without using those parameters. Those parameters are required when queries are ran because more caution is used to prevent SQL Injection.

-Chad

Is there any way to show/hide a field so that the form is already setup, visually, when the page is loaded? When the page is loaded, there isn't a postback so my Questiion events won't fire and I'm not using SQL to do a query of any kind. Is there a way to do it via a SQL query? I basically want to show a couple fields only if there are values in certain other fields, and I'm not quite sure how to do that when the page loads.

Hi. Well you basically create the question event but for the 'Postback' questoin you make it a 'Hidden' field. Then the under advanced field options you set the hidden field to be based from 'Retrieve from querystring' or 'Retrieve from session variable'. This way you can pass ?YourhiddenField=ShowCompanyStuff and then the question event can show the company fields (or whatever). Since the hidden field is rendered on page_load it is working as your post back.

-Chad

I think there is one more step that I'm missing in order to be able to do what I need and I'm having a little trouble figuring it out. I have a checkbox group that has 14 items in the group. I have a Question Event tied to each response. Basically when a user selects an item from the checkbox group an additional textbox is displayed on the form that is specific to the item that they have selected. If they select 5 items from the checkbox group there will be 5 additional questions that show up, etc. I need to be able to track which items have been selected so I create an hidden field for each of the possible responses. I created a Question Event that would set the default value of the hidden field based on the response from the question that contained the 14 items in the checkbox list. If an item is checked, my question event updates the default field of the corresponding hidden field to a "1" and that lets me know that they have made that selection and that when they get to the "review form" the corresponding textbox needs to be displayed when the page loads.

The problem is that if someone selects an item from the checkbox group and say the selected the wrong item by mistake, it still updates the hidden field. My question is, Is there a way to setup an event of some sort that will fire when a user unchecks a item or changes their selection in a dropdown menu? I need to be able to change the value of the hidden field when a user deselects an option. Can this be done?

Hi. I might be confused by the exact form you are creating here... You might setup a quick demo on www.betasprings.com just highlighting the concept and ill check it out, check box lists and other fields types that can 'cause' a postback should be able to fire a postback and the event will fire, so if a user unselected #4 it should fire the event and then field #4 wouldn't show up. The hidden field for question events is really only used when you are trying to initially load a page to show/hide fields from the querystring.

-Chad

I'm getting the following error when trying to create a page on betasprings.com to setup the demo

Error: Page Management is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Could not allocate space for object 'dbo.Tabs'.'PK_Tabs' in database 'BetaSprings' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. ---> System.Data.SqlClient.SqlException: Could not allocate space for object 'dbo.Tabs'.'PK_Tabs' in database 'BetaSprings' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddTab(Int32 PortalId, String TabName, Boolean IsVisible, Boolean DisableLink, Int32 ParentId, String IconFile, String Title, String Description, String KeyWords, String Url, String SkinSrc, String ContainerSrc, String TabPath, DateTime StartDate, DateTime EndDate, Int32 RefreshInterval, String PageHeadText, Boolean IsSecure) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab, Boolean AddAllTabsModules) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab) at DotNetNuke.Modules.Admin.Tabs.ManageTabs.SaveTabData(String strAction) at DotNetNuke.Modules.Admin.Tabs.ManageTabs.cmdUpdate_Click(Object Sender, EventArgs e) --- End of inner exception stack trace ---

HI Josh, sorry for the inconvenience. It seems like the database size for "BetaSprings" has reached its limit. Chad will need to go in and delete all the log files and compact the database or increase it's filegrowth size limit. In the meantime, I'll shoot you an email and you can send me the XML content of your form for me to diagnose on my local machine. -- David

Hi,

Has this been resolved? If so can you post some details so that we can follow up on what the solution was.

-Chad