Code

Re: How to do programming with Repeating Sections?

reggieoverton — Thu, 28 Jan 2010 14:24:09 GMT

What if the fields are pointing to access. Meaning the infopath form is connected to access database. How do u point to them using VBscript?

Re: How to do programming with Repeating Sections?

Brooke Hyde — Thu, 04 Sep 2008 21:19:34 GMT

Hilary, Thanks so much for all your help!

I got this working.

I was having problems because there were groups inside my repeating group.

I simiplified my XML schema and put all the fields inside the repeating group and it works like a charm.

Thanks,

Brooke

Re: How to do programming with Repeating Sections?

Hilary Stoupa — Thu, 04 Sep 2008 16:59:07 GMT

I don't know the VBScript syntax off hand, but you'll want selectNodes instead of selectSingleNode and then your xpath should point to the appropriate node group.

In C# (IP2003) we use foreach (IXMLDomNode item in variableName) and then put the logic for the loop (in your case, the calculation code) in between some curly braces. I think VBScript uses for each item in variableName, followed by the logic, and finishing with next to move to the next node.

Here is a link with more info on selectNodes that deals with VBScript.

Re: How to do programming with Repeating Sections?

Brooke Hyde — Thu, 04 Sep 2008 16:02:09 GMT

I'm still having some issues.

I changed the code to use eventObj instead of the CTRL name. The code will still execute on the first group but won't execute on subsequent groups.

The button the executes the script changes the view to a view with the results fields and display the results for the record that data is being entered for.

When I try to calculate for the second group the script kicks off and then runs calculations for the first group only. The calculations for every group must be calculated.

I think that I may need to run the calculation for all the groups by iterating through the nodes.

Could you point me in the right direction to do that?

Re: How to do programming with Repeating Sections?

Hilary Stoupa — Wed, 03 Sep 2008 16:56:34 GMT

Whoops, you don't use the CTRL name, you use eventObj. I'm sorry I confused you, I included the event handler sig so you'd see the (eventObj) argument being passed in. Try:

set objectvariable = eventObj.Source.selectSingleNode("XPath")

Re: How to do programming with Repeating Sections?

Brooke Hyde — Wed, 03 Sep 2008 16:15:08 GMT

Hilary,

Thanks for replying so quickly.

My button is inside my sections.

i have changed my code to read

set objectvariable = CTRL69_8_OnClick.Source.selectSingleNode("XPath")

Now I get the following error. Type mismatch: 'CTRL69_8_OnClick'

I tried commenting that line out to better diagnose and it still gets the same error on that line. The line that errors is the first line whe I am using the eventobj variable to get data from the form.

Do I still need to use the set command when getting the data?

Do you know if I still need to use an object or will a double type variable work?

Thanks,

Brooke

Re: How to do programming with Repeating Sections?

Hilary Stoupa — Wed, 03 Sep 2008 15:10:27 GMT

Hi, Brooke:

Is your button in the repeating group? Or do you have one button that is supposed to calculate all the repeating groups?

If the button is inside the repeating group, you can use the eventObj variable to select the correct instance of the group.

Your button's event handler looks something like this (with the CTRL name depending upon the name of your control): Sub CTRL1_5_OnClick(eventObj)

If you use eventObj.Source.selectSingleNode("xpath") you can get the fields in the group the button is located in. For example, say the xpath to my field is this: /my:myFields/my:topGroup/my:repeatingGroup/my:rgField1 and my button is sitting in my:repeatingGroup. To get my:rgField1, I could use eventObj.Source.selectSingleNode("my:rgField1").

Now, if you have one button on the whole form, and you want to run calculations for all the groups, instead of using selectSingleNode, you'll use selectNodes and iterate through all the nodes, performing your calculations on each group as you go through. Does that make sense? Let me know if you need more help....

How to do programming with Repeating Sections?

Brooke Hyde — Wed, 03 Sep 2008 14:00:38 GMT

I am working on a project that requires the user to enter data into a group of fields and then hit a calculate button and then calculations are ran using a vbscript. The view is changed and the results are shown in a new infopath view.

I have this working for the first group of items in the repeating section.

When I enter data for the second repeating section the script does not work.

I have figured out that it doesn't work because the XPath is still pointing at the first group in the repeating section.

In the VBscript, I am using the following code to access the fields

object=XDocument.DOM.selectSingleNode("XPATH")

How can I make it iterate to the next group in the repeating section?