Re: Repeating Tables and calculations

Patrick Halstead — Mon, 09 Nov 2009 10:57:19 GMT

Hi Arran,

If the fields in the row are all in the main data source, you can use xpath to correctly select them when doing the calculations. There is a function called preceding-sibling which you will want to master. Here are a bunch of links:

http://www.infopathdev.com/blogs/greg/archive/2005/06/13/Using-XPath_2700_s-_2700_preceding_2D00_sibling_2700_-Axis-Correctly.aspx

http://www.infopathdev.com/blogs/greg/archive/2004/07/08/Identify-the-Current-Table-Row.aspx

http://www.infopathdev.com/blogs/greg/archive/2005/07/14/Create-a-Repeating-Cascading-List-from-a-Hierarchical-Data-Source.aspx

Happy trails!

Repeating Tables and calculations

Arran — Thu, 05 Nov 2009 01:37:01 GMT

Hello,

I hit a block working on a form with a repeating table.

I want to select a row out of a predefined table and run calculations on other fields in that row, currently my form only uses the first row of the table for the calcuations.

I linked the HallName drop down box to the data source (should it be linked to the table or the field?) and that works fine.

AccessTable - This table is an XML table included with the form, it holds information on five seperate sites each listing the cost of their hourly Rate and other resource information. (I have this saved in XML or can use a Sharepoint list, i do not have to use access if it makes a difference)

One last piece of information, I have two tables - the first holds all the pricing information and the second is built for the final invoice style output.

Basically what i want to do is use the "RateType" dropdown list to pick what number to multiply with the HoursBooked field.

Hope this makes sence.

Thanks

Arran

Newbie Questions

Re: Repeating Tables and calculations

Repeating Tables and calculations