Code

Re: Add repeating table data to main data source from secondary data source

mtbikerj — Tue, 30 Jun 2009 19:20:30 GMT

Thanks. I understand your method, but I am not able to use "foreach." It gives me a syntax error. I may have forgotten to mention that I'm using infopath 2003 as I'm sure that makes a difference.

Re: Add repeating table data to main data source from secondary data source

Shiva — Tue, 30 Jun 2009 18:53:59 GMT

Hello,

We can do it using Jscript code, first you have to get the list from secondary source and set those values to one temporary node and these nodes should get added to parent node.

var secondaryRepeatingNodes = XDocument.GetDOM(“Seconday DOM Name”).selectNodes(“Secondary XPath of the repeating nodes”);

var parentNode = XDocument.DOM.selectSingleNode(“Repeating Parent Node XPath”);

var repeatingNode = XDocument.DOM.selectSingleNode(“Repeating Node XPath”);

var tempRepeatingNode = repeatingNode.cloneNode(true);

foreach (var secondaryRepeatingNode in secondaryRepeatingNodes)

{

var value = secondaryRepeatingNode.selectSingleNode(“XPath of one node in secondary XML”);

tempRepeatingNode. selectSingleNode(“XPath of need to set value”).text = value;

//Like this you have add more number node values

repeatingNode.appendChild(tempRepeatingNode);

tempRepeatingNode = repeatingNode.cloneNode(true);

}

Add repeating table data to main data source from secondary data source

mtbikerj — Tue, 30 Jun 2009 17:12:09 GMT

I'm very new to programming in jscript so heres what I'm trying to do.

I have an XML list as a secondary data source with the lines that I want to collect from users and there are several calculations that I want to do on that data (sum, percent, etc...). I have created a repeating table in the main data source and want lines inserted and the first column of the main data source to be populated with the items from the secondary data source.

So the basic steps that I need are. 1) Insert lines to the repeating table for the number of lines in the secondary data source. 2) Set the text in a node of the repeating table equal to the node in the secondary data source. 3) don't allow the users to insert any more lines.

Is there a way to do this using jscript or am I out of luck?