Newbie Questions

Re: repeating table add rows programaticly

mloftus — Tue, 19 Jul 2016 12:32:48 GMT

How would I programmatically add rows to a nested repeating tabled based on a drop down selection?

I have a repeating section with a drop down, button, a repeating table and a hidden field that calculates how many rows to add to the table based on an external data source. I used the below code to add the correct amount of rows but when I add a new section and try to add rows it adds the same amount as it did in the first section.

            Dim xpath As String = "/my:myFields/my:AdminTool/my:AToolCount"
            Dim field As XPathNavigator = MainDataSource.CreateNavigator().SelectSingleNode(xpath, NamespaceManager)
            Dim rows As Integer = field.ValueAsInt
            Dim i As Integer
            For i = 1 To rows - 1
                CurrentView.ExecuteAction(ActionType.XCollectionInsert, "Tool_31")
            Next i

Any help would be much appreciated.

Re: repeating table add rows programaticly

Brokholm — Wed, 09 Nov 2011 14:52:43 GMT

Hi Hilary

I was trying to get this to work, and after making a smaller change, I got it to work. As I always need to add 1 row to the table when the button is pressed, I have made the text box read only and set the value to 2.

My code looks like this:

Public Sub CTRL6_5_Clicked(ByVal sender As Object, ByVal e As ClickedEventArgs)

Dim xpath As String = "/my:myFields/my:field1"

Dim field As XPathNavigator = MainDataSource.CreateNavigator().SelectSingleNode(xpath, NamespaceManager)

xpath = "/my:myFields/my:group1/my:group2"

Dim group As XPathNavigator = MainDataSource.CreateNavigator().SelectSingleNode(xpath, NamespaceManager)Dim rows As Integer = field.ValueAsInt

Dim i As Integer

For i = 1 To rows - 1Dim newRow As XPathNavigator = group.Clone()

newRow.InsertAfter(group)

Next i

End Sub

I would like to use this in a form we use for reviews. In each row in the table I have a text box which just shows which review we are at and a drop-down box which shows the result of the review, basically OK/ Not OK. I have been trying to add a condition to the code to ensure that a new row is only inserted when the result of the review is "Not OK". Unfortunately my programming skills are very rusty and I can't get it to work.

Do you have any ideas to how this should be added to the code?

Re: repeating table add rows programaticly

ofergal — Fri, 09 Apr 2010 17:05:38 GMT

What do You do if you want the table to start with no items and add few at once?

Re: repeating table add rows programaticly

Jimmy — Sat, 14 Feb 2009 16:15:24 GMT

Hiya Ben,

I've always held that ExecuteAction is a better way to insert new items into repeating groups, as it does not require cloning a node (a node can't be cloned if there isn't one there to begin with), and takes the guesswork out of putting the node together manually.

The main problem with your code is that you seem to be using C# 2007 code but it looks like your form is set up to use JScript.

Your screenshot is not showing up as its address seems to be located on your intranet and is not accessible to us:

http://blemain-intranet/sites/Intranet/accountsforms/test1/Picture10.png

If you put the picture up on the internet where we all can see it, I can show you some code that would probably do what you want.

Jimmy

Re: repeating table add rows programaticly

hiszorn — Fri, 13 Feb 2009 20:07:00 GMT

Hello Ben,

Here is a sample that we modifed that Hilary posted on another post. We needed to add a row to the table we are in when the user clicks a button on the row. This method copies the row clicked and adds it back into the table. We use the sample xml file as a sort of template for adding rows. I think you should be able to modify to suit your needs. This sample works well for adding a new row to the table. The issue with using the clone method is you still point to the old row you cloned. ProjectTask is a line in the group ProjectTaskList.

//Create a copy of current row and insert after current row

XmlDocument sampleData = new XmlDocument();

sampleData.Load(this.Template.OpenFileFromPackage("sampledata.xml"));

XPathNavigator newProjectTask = sampleData.CreateNavigator().SelectSingleNode("/my:ProjectTicket/my:ProjectTaskList/my:ProjectTask", NamespaceManager).Clone();

string OldGuid = e.Source.SelectSingleNode("my:ProjectTaskId", NamespaceManager).Value;

newProjectTask.SelectSingleNode("my:DepartmentAbbrev", NamespaceManager).SetValue(e.Source.SelectSingleNode("my:DepartmentAbbrev", NamespaceManager).Value);

newProjectTask.SelectSingleNode("my:Department", NamespaceManager).SetValue(e.Source.SelectSingleNode("my:Department", NamespaceManager).Value);

newProjectTask.SelectSingleNode("my:ParentTaskId", NamespaceManager).SetValue(OldGuid);

newProjectTask.SelectSingleNode("my:IncludedInChangeRequest", NamespaceManager).SetValue("True");

newProjectTask.SelectSingleNode("my:ProjectTaskId", NamespaceManager).SetValue(Guid.NewGuid().ToString());

newProjectTask.SelectSingleNode("my:ChangeOrderLineNumber", NamespaceManager).SetValue(GetField("/my:ProjectTicket/my:ChangeOrderNumber"));

string TaskName = e.Source.SelectSingleNode("my:TaskName", NamespaceManager).Value + "-" + GetField("/my:ProjectTicket/my:ChangeOrderNumber");

newProjectTask.SelectSingleNode("my:TaskName", NamespaceManager).SetValue(TaskName);

e.Source.InsertAfter(newProjectTask);

Re: repeating table add rows programaticly

Anonymous — Fri, 13 Feb 2009 15:10:16 GMT

Hi Hilary, hoping you can shine some light on this problem for me as I've spent hours searching the forums and am still not having any luck with this! I have a relatively simple form for tracking overtime worked/paid - the user fills in the info (date, start time, end time) into a repeating table which then calculates "hours worked" and the "hours earned". What I'd like is for the user to then click a button if they want the overtime to be paid, and have the "date" and "hours earned" automatically populate into a second repeating table. This would need to be repeated for each instance of overtime, and a new row inserted into the secondary repeating table each time.

Right now my data source looks like this:

I've tried using the below code which I've kind of made up from what I could find on here but I can't even get the form to open in preview with it so I've obviously done something wrong! Any help is greatly appreciated.

Ben

function CTRL89_7::OnClick(eventObj)

{

XPathNavigator group = MainDataSource.CreateNavigator().SelectSingleNode

("/my:OvertimeTracking/my:Payments/my:PaymentDetails[last()]", NamespaceManager);

XPathNavigator NewRow = group.Clone(); NewRow.InsertAfter(group);

//Set each field value NewRow.SelectSingleNode

("my:DateWorked", NamespaceManager).SetValue("my:Date"); NewRow.SelectSingleNode("my:HoursToBePaid", NamespaceManager).SetValue("my:HoursEarned"); }

Re: repeating table add rows programaticly

hiszorn — Tue, 11 Nov 2008 16:44:54 GMT

I finally figured this out. The issue is setting the values before inserting the new row. It seems like when you do that, InfoPath keeps a pointer to the other row. So once I inserted first and then set values, it works fine:

XPathNavigator group = MainDataSource.CreateNavigator().SelectSingleNode("/my:ProjectTicket/my:BudgetMaster/my:BudgetLine[last()]", NamespaceManager);XPathNavigator NewRow = group.Clone();

NewRow.InsertBefore(group);

//Set each field value

NewRow.SelectSingleNode("my:LineStatus", NamespaceManager).SetValue("test");

NewRow.SelectSingleNode("my:Dept", NamespaceManager).SetValue("IT");

NewRow.SelectSingleNode("my:CostQuantity", NamespaceManager).SetValue("2");

Thank you for all the help!

Jeff

Re: repeating table add rows programaticly

Hilary Stoupa — Tue, 11 Nov 2008 15:39:47 GMT

Do you have a default value set on the field 'my:LineStatus'? Or a rule hanging about somewhere that might be doing that? Becuase in the code, you are creating a new group called NewRow and setting the value only on that field in that group.....

By the way, the XPath you were using at first was taking the first Budget Line group and cloning it -- now you are cloning the last one. I suggested using 'last' if you changed to using Jimmy's method of using:

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

Either is fine -- just wanted you to be aware of what the difference was.

Re: repeating table add rows programaticly

hiszorn — Tue, 11 Nov 2008 15:00:06 GMT

Hi Hilary,

I did not have the [Last()] in my XPath so I added that. The issue I am still seeing is that when I set the value, it sets all the rows values to the new value, not just the new row:

XPathNavigator group = MainDataSource.CreateNavigator().SelectSingleNode("/my:ProjectTicket/my:BudgetMaster/my:BudgetLine[last()]", NamespaceManager);

XPathNavigator NewRow = group.Clone();

//Set each field value

NewRow.SelectSingleNode("my:LineStatus", NamespaceManager).SetValue("test");

NewRow.InsertAfter(group);

Thanks,

Jeff

Re: repeating table add rows programaticly

chandrakanth — Tue, 11 Nov 2008 06:11:39 GMT

Hi,

“PATH OF THE FOLDER INSIDE REPEATING TABLE FOLDER” means the row (group) inside the repeating table where you want to insert new row (group) before that. (Ex: MainDataSource.CreateNavigator ().SelectSingleNode(“/my:myFields/my:group1/my:group2[my:field1= “Some Value”]”).

Please follow the below code lines for adding a row inside a repeating table.

IXMLDOMNode startNode; // Position of the already existing node (row) inside a repeating table.

IXMLDOMNode newNode; // New node which you want to add inside a repeating table.

AddWhere where;// the position of the row.

if(where == AddWhere.First)

startNode.insertBefore(newNode, GetNode(startNode, "child::node()"));

else if(where == AddWhere.Before)

startNode.parentNode.insertBefore(newNode, startNode);

else if(where == AddWhere.After)

startNode.parentNode.insertBefore(newNode, GetNode(startNode, "following-sibling::node()"));

else if(where == AddWhere.Last)

startNode.appendChild(newNode);

Re: repeating table add rows programaticly

Hilary Stoupa — Tue, 11 Nov 2008 01:31:43 GMT

Hi, Jeff:

If you follow Jimmy's suggestion, the node you will want to set the values on will be the last node in your repeating group. So you could create an XPathNavigator variable to the last node, like this:

XPathNavigator group = MainDataSource.CreateNavigator().SelectSingleNode("/my:ProjectTicket/my:BudgetMaster/my:BudgetLine[last()]", NamespaceManager);

Then you could set the values by selecting single nodes from the group:

group.SelectSingleNode("my:fieldInBudgetLineGroup").SetValue("A Value");

If you want to use the code you are currently using, where you clone nodes, you can set the values on the nodes in the variable NewRow before inserting;

NewRow.SelectSingleNode("my:fieldInBudgetLineGroup").SetValue("A Value");

Does that make sense?

Re: repeating table add rows programaticly

Jimmy — Tue, 11 Nov 2008 00:21:53 GMT

Have you tried:

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

where XmlToEdit is a unique identifier for the repeating table that you can find in the InfoPath designer? This mimics the behavior that InfoPath carries out when a user adds a row to a repeating table/section and takes all the guesswork out of adding rows to repeating tables/sections.

Re: repeating table add rows programaticly

hiszorn — Mon, 10 Nov 2008 23:39:21 GMT

Hi Hilary,

I am using the clone method to copymy repeating table row and then insert it into the table. I was wondering what the proper way to set a value of the fields prior to the insert after call.

XPathNavigator group = MainDataSource.CreateNavigator().SelectSingleNode("/my:ProjectTicket/my:BudgetMaster/my:BudgetLine", NamespaceManager);

XPathNavigator NewRow = group.Clone();

//Set each field value prior to inserting, ie i Have a field called LineStatus the is in BudgetLine that I would like to set a value for.

NewRow.InsertAfter(group);

Thanks,

Jeff

Re: repeating table add rows programatically

Patrick — Wed, 03 Sep 2008 17:58:04 GMT

Ok that's what I figured. I tried the AppendChild() method and it worked, but the performance was worse :( It was worth a try though. Adding 5 rows took 2.5 times longer than the cloning method.

Re: repeating table add rows programatically

Hilary Stoupa — Wed, 03 Sep 2008 17:48:25 GMT

Yah, I used the if statement so that if this was on the changed event of a field I wouldn't end up in an infinite loop.