InfoPath Dev

Hello,

I have a form where I have a drop down list connecting to an XML resource file.  In this list I have setup various conditional formatting options if certain values are selected.  I have also wanted to remove the default blank space that accompanies drop down lists.  I have found the way to extract the form files, and edit the XLS view to remove the <option/> tag so I can see the default values based on previous selections. However when I remove the <option/> tag it removes conditional formatting on the drop down list.  When I add the <optoin/> back in, the formatting comes back.  Adding to confusion further, is that without <option/> and blank value, formatting does comeback once I go to the drop down field and make a different selection.  Any thoughts?  Example below.

Dropdown List with <option/> and formatting

Desired result without <option/> in the view xls file

Thank you for your quick response.  If I perform the steps you selected, anytime I open up the form to view (after submitting) the value ties back to the default value rather than keeping the value that was selected.   This was the primary reason I went away from setting the default value.

 Also, the blank value can be removed from the drop down by accessing the view xls file (after extracting the forms and removing the <option/> tag from the field-howeve, this removes the initial conditional formatting. 

Any ways to get around the default value overwriting the selected value after submit?  Thanks again.

Good morning and Thank you again. 

I am using Vbscript - how would this convert to vbscript?  Thanks!

Hi,

if(XDocument.IsNew)

{

XDocument.DOM.selectSingleNode("xpath").text = "default value"

}

Hi,

Please write the below lines code in VBScript . I hope it will help you.

If XDocument.IsNew Then

XDocument.DOM.selectSingleNode("xpath").text = "default value"

End If

Thank you for your response.

For "default value" I would like to have this equal the "xpath" value where the "xml resource(secondary source) field CONDITION1" and "Condition 2" apply but I can't seem to write out the code correctly to access the secondary source correctly

Essentially I would like to place this in the code in vbscript, but the script sees problems in the format:

xdXDocument:GetDOM("SecondaryXMLDataSource")/OfferingMaster/Server/Function/ServerTools/StdTools/XMLField[xdXDocument:get-DOM()/my:myFields/my:InfoPathField1 = ../../../XMLField1 and xdXDocument:get-DOM()/my:myFields/my:InfoPathField2= ../../../../XMLField2]

 For this, I am trying to set the data source under "myFields" to a default value but not clear out the actual field value on the form.