InfoPath Dev

I am working on a completed time with a repeating table.
One of the options in the row is a drop-down box to select the apprpiate time (REG/OT/SICK/etc).

I want to have a table outside of the repeating table that will total the time code values for Payroll so they don't have to do it manually.

Basically, I need my expression box to update automatically. I want it to scan the repeating table for all instances of "REG", then for those rows, sum the totals in the "daily total" columns and then drop the end value into the "REG" expression box.

Currently I can't even get teh "REG" expression box to even show the daily total for teh first row. Please help.

Hi,

Once flexible solution is to loop through your nodes by code and implement the business logic.

Here is a basic sample to loop through your nodes to get you started:

If you drop a repeating section on a blank form (with 2 textboxes field1 and
field2), you will have the following schema:
myFields
group1
group2
field1
field2

You can loop through the node to retrieve the value stored in field1 for
example:

IXMLDOMNodeList oNodeList = thisXDocument.DOM.selectNodes(
"my:myFields/my:group1/my:group2" );

if (oNodeList.length>0)
{
foreach (IXMLDOMNode oN in oNodeList)
{
if( oN.nodeType == DOMNodeType.NODE_ELEMENT )
{
IXMLDOMNode oField = oN.selectSingleNode("my:field1");
thisXDocument.UI.Alert(oField.text);
}
}
}

You need to check the value of the node linked to your drop-down to see if it is REG and add time in a variable outside the loop. Then you can display the final result in your table outside your repeating section.

Hope that it helps.

Regards,

Franck Dauché

Thannks Frank, I belive I got it working now with your help.

Great! Glad I could help.
Good luck with your InfoPath developments.

Franck Dauché

Franck - awesome help here and everywhere! Send me e-mail when you hit 100 for your free forum poster prize. It's red, right-bank, and over 18 years of age.

Patrick Halstead [InfoPath MVP]
InfoPathDev

I sure will Patrick! We will open it up together on the 21st floor...

Franck