Controls

Re: Locate the current row in a repeating table and update the fields through button click.

Jimmy — Mon, 14 Jan 2013 15:15:52 GMT

To set values in rows right at the time a row is added, you can place the rules on the repeating group itself. Is that what you are looking to do?

Re: Locate the current row in a repeating table and update the fields through button click.

rajkumar.bathula — Mon, 14 Jan 2013 03:44:32 GMT

Hi Jim,

can we achieve last() row of a repeating table without the help of code and for a browser based form? I mean using OOB rule/actions/functions? I want to store value of a field in repeating table's newly/last added row.

thank you before hand :)

Re: Locate the current row in a repeating table and update the fields through button click.

Hilary Stoupa — Thu, 08 Dec 2011 19:00:41 GMT

Paste in your code?

Re: Locate the current row in a repeating table and update the fields through button click.

dbarker1 — Thu, 08 Dec 2011 18:41:51 GMT

Yes I tried it but unfortunately it didn't work. It still grabs the value from the first row.....

Re: Locate the current row in a repeating table and update the fields through button click.

Hilary Stoupa — Thu, 08 Dec 2011 18:03:28 GMT

If you use "//" you will get the first instance, as "//" selects nodes in the document from the current node that match the selection no matter where they are.

Did you try my:Treatment yet, as I initially suggested? If the repeating group is FinancialAllocation, I'd expect my:Treatment to work.

Re: Locate the current row in a repeating table and update the fields through button click.

dbarker1 — Thu, 08 Dec 2011 17:06:11 GMT

I tried "my:FinancialAllocation/my:Treatment" but it threw an error so I tried "//my:FinancialAllocation/my:Treatment" but that pulled the first rows drop down value again.

Here is the full xpath to the field that resides in the repeating section that I am trying to grab:

/my:myFields/my:GIGroup/my:Years/my:Lines/my:FinancialAllocation/my:Treatment

FinancialAllocation is the name of the repeating section. "Treatment" is the name of the drop down with the values that I am trying to grab using the button that sits next to the drop down on the same line.

Here is a screenshot to help show what it looks like.

Re: Locate the current row in a repeating table and update the fields through button click.

Hilary Stoupa — Thu, 08 Dec 2011 16:44:27 GMT

You don't want an absolute path. You want a relative path. Assuming your button is in FinancialAllocation - you want "my:Treatement". If your button is in Lines, you want "my:FinancialAllocation/my:Treatment"

Re: Locate the current row in a repeating table and update the fields through button click.

dbarker1 — Thu, 08 Dec 2011 16:41:03 GMT

I tried switching to an absolutel path. Even when I use the absolute path below, it still only grabs the value of the first group.row. When I create 5 instances and click on the "apply to all" button on the 5th row, it grabs the value of the first row. I thought "e" put you on the row the button was clicked on?

XPathNavigator domNavTreatment = e.Source.CreateNavigator();
string xhtmlRTFField = domNavTreatment.SelectSingleNode("/my:myFields/my:GIGroup/my:Years/my:Lines/my:FinancialAllocation/my:Treatment", NamespaceManager).InnerXml;
MessageBox.Show(xhtmlRTFField);

Re: Locate the current row in a repeating table and update the fields through button click.

Jimmy — Thu, 08 Dec 2011 09:07:41 GMT

The problem is that //my:Treatment is an absolute XPath instead of a relative one.

Re: Locate the current row in a repeating table and update the fields through button click.

Hilary Stoupa — Thu, 08 Dec 2011 00:39:43 GMT

Is my:Treatment inside the same repeating group as your button? If so, you want:

string xhtmlRTFField = domNavTreatment.SelectSingleNode("my:Treatment", NamespaceManager).InnerXml ;

Re: Locate the current row in a repeating table and update the fields through button click.

dbarker1 — Wed, 07 Dec 2011 19:27:15 GMT

I am trying to use the e.source to get the value of a drop down field I have in my repeating section but it only works for the 1st instance of the repeating section If I click the button in the 2nd or 3rd row it always grabs the value in the first row? Any thoughts?

public void TestButton_Clicked(object sender, ClickedEventArgs e)

{

XPathNavigator domNavTreatment = e.Source.CreateNavigator();

string xhtmlRTFField = domNavTreatment.SelectSingleNode("//my:Treatment", NamespaceManager).InnerXml ;

MessageBox.Show(xhtmlRTFField); // this shows the value of the row as long as its the first???

}

Re: Locate the current row in a repeating table and update the fields through button click.

kalyan@infopath — Fri, 24 Jul 2009 02:15:08 GMT

Hi Jimmy,

Thanks a lot for your help on this issue. I used a button inside the table to attach data to hidden fields and then removed the basic "insert row" option. Your post helped in another issue to calculate the row count and the row numbers accordingly.

Thanks,

Kalyan.

Re: Locate the current row in a repeating table and update the fields through button click.

Jimmy — Wed, 22 Jul 2009 01:42:29 GMT

What you can do is store a reference to the most recently added row, which you can access later when the button is clicked:

XPathNavigator lastChanged;
int lastRowCount;
public void group2_Changed(object sender, XmlEventArgs e)
{
     if (e.Site.Name.Equals("my:group2"))
     {
          int rowCount = e.Site.Select("../my:group2", NamespaceManager).Count;
          if (e.Operation == XmlOperation.Insert)
          {
               if (rowCount > lastRowCount)
               {
                    // my:group2 has been added
                    lastChanged = e.Site;
               }
          }
          else if (e.Operation == XmlOperation.Delete)
          {
               if (rowCount < lastRowCount)
               {
                    // my:group2 has been removed
                    lastChanged = null;
               }
          }
          lastRowCount = rowCount;
     }
}

Since removing a node could cause unpredictable behavior (e.g. if a row was added and then immediately deleted), I've opted to set the lastChanged variable to null if any row is removed, and you would need to check for this in the button's event handler.

Since the changed event will fire with your repeating node as e.Site even if a node is inserted or deleted inside a repeating node, you will need to keep track of the number of repeating nodes you have and check whether the count has increased or decreased. You can initialize this row count in the Loading event of the form:

public void FormEvents_Loading(object sender, LoadingEventArgs e)
{
lastRowCount = MainDataSource.CreateNavigator().Select("/my:myFields/my:group1/my:group2", NamespaceManager).Count;
}

Of course the XPaths and node names would be different in your case.

Re: Locate the current row in a repeating table and update the fields through button click.

kalyan@infopath — Tue, 21 Jul 2009 19:20:14 GMT

I have lot of code in the form, as you said it may not work.

Re: Locate the current row in a repeating table and update the fields through button click.

Patrick Halstead — Tue, 21 Jul 2009 19:12:42 GMT

Our free qRules toolkit lets you programmatically insert items into a repeating section without code. Check out the Insert command. Unfortunately, qRules doesn't work if you have already have code in your form, but maybe you don't need to write code and can just test with a new form and qRules to see the technique.