I have a form where the visibility of 'Field A' is controlled by a question event and the form is also setup for editing records using 'Initial SQL Rendering/Bind' feature where I pass in parameters as shown in DEMO #14 to update previous entries.

How can I get the question events to fire on the initial page load when EDITING a record so that the visibility of 'Field A' matches the information being pulled from the database?

David, thanks for the reply. I'll give my real-world example...

I have 3 dynamic questions setup that are checkbox lists and are all hidden until a category dropdown earlier in the form is used to determine which 1 of the 3 checkbox lists should be shown.

There are three question events setup that each look at the category dropdowns value and depending on the value, the proper checkbox list will be displayed. So the question events simply toggle the display of checkbox lists.

When filling out the form the first time, its not an issue. The question event fires after the category drop changes and then displays the proper checkbox lists. Then the user makes selections in that checkbox lists and saves it.

If the record is brought up for editing (using the methodology described in demo #14), the category dropdwon has the original value that the user selected, but the question event which would normally fire after selecting a category does not seem to be triggered because the value is being pulled from the database and not causing the dropdown's 'On Change' event or whatever it is that typically fires question events.

However, if I pull up a record for editing and go to the category dropdown and momentarily change the value to something else and then back to the value it originally pulled from the database...only then are the appropriate checkboxes displayed. The checkbox lists even have the correct values the user originally selected when submitting the form, I just can't get them to show without having to first re-toggle the category dropdown.

So what I was HOPING is that somewhere in the Custom Javascript section I could enter some magical code that will cause all question events or even a particular question event to fire when the page loads so that all of the fields whose visibility is typically toggled during the initial submission of the form can be set to their appropriate states. Maybe fake a 'On Change' for the dropdown or something?

You mentioned using a hidden field to get the value from the db. I can do that but would need to create some workarounds because I would then need to retrieve the same value twice when editing...once to populate the hidden field and another to populate the user's category selection in the dropdown even though the two will always be the same value because they are coming from the same db field.

Is it that only question events based on hidden fields are fired on page load or that any field but a dropdown triggers associated question events on pageload. If its a matter of the values needing to be in hidden fields which the events are connected to, I understand what I need to do to fix things up but don't want to restructure the whole thing to find out events won't fire for hidden fields in my particular example. So if this is just the way it is, I get it, I'm just keeping my fingers crossed that I can somehow force these events to happen without tweaking the dataset and adding more (hidden) form fields.

Hi Jeff.  Not sure why the patch date(s) in snowcovered is incorrect but it may just need updating.  Meanwhile, please send me a note referencing this thread and your order # and I'll send you the Dynamic Forms 2.7.53 file.  Thanks!

Candace

I wanted to follow up on this question I had from a long time ago, I’m finally getting around to implementing it. The new scenario is that I have a question event which fires when a check box is toggled. The event shows 4 additional textbox questions. Everything works fine during the initial form submission. However, when retrieving a record for edit, I retrieve an additional field from a Stored Proc to fill a hidden field with a value from a bit column in the db.

I created a new question event to fire on the hidden field (I knew it could not be based on a non-hidden field based on the forum dialog above) which shows those same 4 fields when the value in the Stored Proc is True ( I also tried 1, -1 and Yes). I save the event and edit a record – none of the question event’s fields were shown. So then I chose for that question event to fire base on any value in the hidden field – still nothing.

I’m definitely overlooking something here. I’m running DFv3 and DNN v4.09.04

Any thoughts?

David, good deal. I deleted and re-created things on my version and it worked as well. My live form has a lot more going on so rather than deleting and recreating things over there, I tried setting the sort order of the hidden field which triggers the question event t equal to 1 (the lowest on the form – figuring that would be the end result of recreating it) and that seemed to do the trick. It also worked when feeding a value directly to the hidden field from a stored procedure.

Thanks for looking into it. It seems the sort order of a hidden field being used to control the visibility of other fields, must appear before the fields it’s controlling within the form’s sort order.

Maybe that makes sense…as long as it’s working, I’m happy.

 - Jeff