InfoPath 2010

Re: Add rows to repeating table in InfoPath 2010

Hilary Stoupa — Fri, 17 Nov 2017 18:10:35 GMT

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

Re: Add rows to repeating table in InfoPath 2010

TOE_CHEESE — Fri, 17 Nov 2017 17:25:48 GMT

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

Re: Add rows to repeating table in InfoPath 2010

TOE_CHEESE — Wed, 15 Nov 2017 21:55:17 GMT

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

Add rows to repeating table in InfoPath 2010

TOE_CHEESE — Tue, 14 Nov 2017 16:33:33 GMT

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.