InfoPath 2010

Re: Code for multiple rows in a repeating table (VB)

Anson Hidajat — Mon, 26 Mar 2012 23:48:44 GMT

I don't believe that admin approving the template will allow code to run on the client, so that won't fix the number of postbacks you are encountering. Not sure if anyone has suggested this yet, but you can look into optimizing your form by limiting which controls will postback in the control properties browser forms tab. If the formulas, queries, etc. need to only be run on certain actions, this is a great way to improve the performance on your form.

Re: Code for multiple rows in a repeating table (VB)

Hilary Stoupa — Mon, 26 Mar 2012 23:41:31 GMT

That's an interesting question. I'm not sure of the answer on that - I'm going to ask Anson to chime in.

Re: Code for multiple rows in a repeating table (VB)

samauger — Mon, 26 Mar 2012 13:48:37 GMT

One more question... right now I have it running in a sandboxed environment. This is great but all the postbacks take a second to send data to the server. Would publishing the form via 'admin-approved' method allow the code to run in full trust without having to send it to a controlled environment?

Re: Code for multiple rows in a repeating table (VB)

Hilary Stoupa — Fri, 23 Mar 2012 15:59:31 GMT

Hey, that's great news! Good job!

Re: Code for multiple rows in a repeating table (VB)

samauger — Fri, 23 Mar 2012 15:51:42 GMT

Thanks so much for your help! I got it working :)

Re: Code for multiple rows in a repeating table (VB)

Hilary Stoupa — Mon, 19 Mar 2012 17:04:02 GMT

No, don't change the event handler. You need to change the code itself.

Re: Code for multiple rows in a repeating table (VB)

samauger — Mon, 19 Mar 2012 16:49:04 GMT

So I should leave the handler as is when I create the changed event (AddHandler EventManager.XmlEvents("/my:myFields/my:Info/my:UserInput/my:HoursEntry/my:EndDate").Changed, AddressOf EndDate_Changed) or make the Xpath dynamic?

Re: Code for multiple rows in a repeating table (VB)

Hilary Stoupa — Mon, 19 Mar 2012 16:02:00 GMT

This code is on the change of a field w/in the repeating table?

This is an absolute XPath:

/my:myFields/my:Info/my:UserInput/my:HoursEntry/my:StartDate

It starts at the root node.

The method signature for the field that you added the changed event to will look something like this:

Public Sub field2_Changed(ByVal sender As Object, ByVal e As XmlEventArgs)

You can use e.Site to get the field you are currently on. More on MSDN here and here. You can use a relative XPath then to get to your other fields, like perhaps:

e.Site.SelectSingleNode("../my:EndDate", NamespaceManager)

Re: Code for multiple rows in a repeating table (VB)

samauger — Mon, 19 Mar 2012 15:40:11 GMT

That makes sense. What would a relative Xpath look like? Here's most of the code. Thanks for helping me out :) also: is there a way to insert line breaks or format for code in this forum? that looks terrible. Dim startDate, endDate As XPathNavigator Dim dayDifference As Integer Dim hours As String startDate = (MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Info/my:UserInput/my:HoursEntry/my:StartDate", NamespaceManager)) endDate = (MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Info/my:UserInput/my:HoursEntry/my:EndDate", NamespaceManager)) Dim startDateinnerxml, endDateinnerxml As Date startDateinnerxml = startDate.InnerXml endDateinnerxml = endDate.InnerXml If Not startDate Is DBNull.Value Then dayDifference = WorkDays(startDateinnerxml, endDateinnerxml) + 1 MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Info/my:UserInput/my:HoursEntry/my:dayDifference", NamespaceManager).SetValue(dayDifference) hours = dayDifference * 7.5 MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Info/my:UserInput/my:HoursEntry/my:Hours", NamespaceManager).SetValue(hours) End If

Re: Code for multiple rows in a repeating table (VB)

Hilary Stoupa — Mon, 19 Mar 2012 15:27:23 GMT

In general, the reason this happens is because the code uses an absolute XPath instead of a relative XPath. Without seeing your actual code, of course, I have no way of knowing why your code is not working as anticipated.

Re: Code for multiple rows in a repeating table (VB)

samauger — Mon, 19 Mar 2012 13:19:21 GMT

Hello, I'm writing this in VB. It runs when the second date changes, pulls InnerXML from each of the dates, runs it through a function I found on here that calculates the number of work days in a given range then multiplies it by 7.5 (because we're working with hours). If you'd like to see the actual code I can attach that.

Re: Code for multiple rows in a repeating table (VB)

Hilary Stoupa — Fri, 16 Mar 2012 23:23:18 GMT

You are doing this in code? What's your code look like?

Code for multiple rows in a repeating table (VB)

samauger — Wed, 14 Mar 2012 15:57:25 GMT

Hello, I have a repeating table that users will use to enter their leave hours. I have fields for startDate, endDate, reason, and hours. I've gotten to the point where it checks the difference between the dates, multiplies the number of days take off by 7.5 (hours in a full work day) and sets the hours field to that number. The only problem is that it only works on the first row. I'm sure the solution is simple but so far I haven't found anything very helpful. Thanks!