InfoPath Dev

In InfoPath 2010 I can successfully pull and filter data from an excel REST connection into my main repeating table. However, I have to edit the Default Values and add the number of rows I think I'll need which in some cases can be 300+. Obviously it is not practical to add this amount of new rows to the Default Values. I am searching for a method using rules or code to set a static number of rows in my repeating table when the form loads or to set a number of rows based on my filtering the REST connection. Any help is always appreciated. Thank you.

Using a line of code borrowed from Jimmy Rishe's blog I can add a default number of rows to my repeating table. I used the line for Visual Basic 2007 Public Sub ddlLocation_Changed(ByVal sender As Object, ByVal e As XmlEventArgs) Dim x As Long For x = 1 To 200 CurrentView.ExecuteAction(ActionType.XCollectionInsert, "XmlToEdit") Next x End Sub The link to Jimmy's code is here http://www.infopathdev.com/blogs/jimmy/archive/2009/03/06/automatically-adding-rows-to-repeating-sections.aspx

 Reposting for clarity...

 

Using a line of code borrowed from Jimmy Rishe's blog I can add a default number of rows to my repeating table.

I used the line for Visual Basic 2007

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

Dim x As Long

For x = 1 To 200

CurrentView.ExecuteAction(ActionType.XCollectionInsert, "XmlToEdit")

Next x

End Sub

 

The link to Jimmy's code is here http://www.infopathdev.com/blogs/jimmy/archive/2009/03/06/automatically-adding-rows-to-repeating-sections.aspx 

Wonderful - this is an InfoPath filler form? Just want to note that code won't work in the browser. :)