Code

Re: OnClick code only running for first instance of repeating section

kminor — Fri, 29 May 2009 15:12:04 GMT

Hilary, I used your script as a starting point, and my form is finally doing what I need it to do!

In case anyone else might have the same issue down the road, here is an example of the syntax I used within the "For... Next" loop to access the individual text boxes in the repeating section:

Set shipToNum = node.selectSingleNode("@ShipToNum")

Remember that "node" was set in Hilary's script.

Thanks again -- you've been a huge help. Hope you have a great day!

Re: OnClick code only running for first instance of repeating section

kminor — Thu, 28 May 2009 13:07:02 GMT

Hilary -- thank you SO much! I apologize for taking so long to get back to you on this; I've been eyeball-deep in a couple of other projects, too. I hate being in that newbie stage of learning new technology because I know what needs to happen in code; I just can't figure out the syntax! :)

Re: OnClick code only running for first instance of repeating section

Hilary Stoupa — Wed, 20 May 2009 22:56:02 GMT

Hi, so you are using vbscript?

Dim objXMLNodes
Set objXMLNodes = XDocument.DOM.selectNodes("/my:myFields/my:group/my:repeatinggroup")
for each node in objXMLNodes
XDocument.UI.Alert(node.nodeName + VBNewLine + node.text)
next

I'm attaching my sample form. In the header of this reply, right click the link and use Save As to save locally. Right click the saved form and open in design mode. Preview and click the button....

Re: OnClick code only running for first instance of repeating section

kminor — Tue, 19 May 2009 14:33:55 GMT

I hate to be a pest, but I still haven't figured this out. Can anyone help, please?

Re: OnClick code only running for first instance of repeating section

kminor — Fri, 15 May 2009 14:27:45 GMT

Still looking for help on this, if anyone has any to offer. Please, and thank you! :)

OnClick code only running for first instance of repeating section

kminor — Wed, 13 May 2009 16:33:25 GMT

Hello, I am stumped and could use some help. I began researching an answer (both here and on the web) yesterday, and I'm still not even close, I'm afraid.

I created a form in InfoPath 2003 that uses a repeating section to enter customer data. It has a button at the bottom of the page. I've written some validation code that runs in the on-click event of the button.

The problem I'm having is that when the code in the on-click event runs, it only looks at the first instance of the repeating section. I'm trying to figure out how to loop through all the instances of the repeating section to have the validation code check each instance. I believe I need to use SelectNodes, but I can't figure out where to go with it.

My data structure looks like:

myFields

- dataFields

-- d:Requests

--- Customers <-- this is where the data for the repeating section is.

Any help would be greatly appreciated!

ETA: I tried the code below (trying to figure out what's what). After I submitted a form with 2 instances of the repeating section, objXMLNodes.count was still equal to 1. Am I going about this the wrong way?

Set objXMLNode = XDocument.DOM.selectSingleNode("//dfs:dataFields/d:Requests/d:Customers")

XDocument.View.SelectNodes(objXMLNode)

Set objXMLNodes = XDocument.View.GetSelectedNodes

If (objXMLNodes.Count > 0) then

XDocument.UI.Alert(objXMLNodes(0).nodeName + "\n\n" + objXMLNodes(0).text)

End if