Code

Re: Run a script against a field in a repeating section

Jimmy — Wed, 22 Jul 2009 01:21:04 GMT

Yup, that was the problem. Glad you figured it out!

Re: Run a script against a field in a repeating section

martinpalmer — Tue, 21 Jul 2009 21:29:30 GMT

By changing the line:

set objXMLNodes = XDocument.DOM.selectNodes("//my:RecipientInfoRepeat") '-- RecipientInfoRepeat

set objXMLNodes = XDocument.DOM.selectNodes("//my:RecipientInfo")

The parse now crawls the nodes. I didn't see this until you made me study the repeating section a little more.

Thanks for the help!

Re: Run a script against a field in a repeating section

martinpalmer — Tue, 21 Jul 2009 18:13:02 GMT

Attached is the screenshot of the Datasource.

Re: Run a script against a field in a repeating section

Jimmy — Tue, 21 Jul 2009 13:56:56 GMT

Might the field's name be LoginId with a lowercase D or Loginid with all of "ID" in lowercase? Please double-check the capitalization and if you can't figure it out could you post a screenshot of your data source?

Re: Run a script against a field in a repeating section

martinpalmer — Tue, 21 Jul 2009 13:25:42 GMT

Line 302 is

recipientid = oItem.selectSingleNode("my:LogonID").text

Re: Run a script against a field in a repeating section

Jimmy — Tue, 21 Jul 2009 01:08:14 GMT

Repeating Section vs. Repeating Table should make no difference here. They're just two ways of displaying the data. Most likely this is a capitalization problem with one of your node names inside the For Each area. Which line is line 302?

Run a script against a field in a repeating section

martinpalmer — Mon, 20 Jul 2009 18:16:16 GMT

All,

Still a little new to programming in InfoPath. I am trying to pull data from a repeating section. I have done this successfully from a repeating table but when I try to do this from a repeating section, it fails saying:

The following error occurred:

Object required: 'oItem.selectSingleNode(...)'
File:script.vbs
Line:302

What do I need to change to get this to work for a repeating section instead of a repeating table? My code says:

Dim firstname, lastname, unit
Dim objXMLNodes, oItem
Dim Outlook ' As New Outlook.Application
Dim Message ' As Outlook.MailItem

set objXMLNodes = XDocument.DOM.selectNodes("//my:RecipientInfoRepeat")   '-- RecipientInfoRepeat

if objXMLNodes.length <= 0 then
     XDocument.UI.Alert("Please Add at leaste One (1) recipient to form before submitting.")
    exit sub
end if

If objXMLNodes.length > 0 Then
For Each oItem In objXMLNodes
       recipientid = oItem.selectSingleNode("my:LogonID").text
       firstname = oItem.selectSingleNode("my:FirstName").text
       lastname = oItem.selectSingleNode("my:LastName").text
       employeetype = oItem.selectSingleNode("my:NonEmployee").text
       location = oItem.selectSingleNode("my:Location").text
       jobfunction = oItem.selectSingleNode("my:JobFunction").text
       emailmessage = emailmessage + classaction + " Recipient --" + recipientid + "--" + lastname + "," & _ + firstname + "--" + employeetype + "--" + location + "--" + jobfunction + cr
next End If