InfoPath Dev

I am looking for syntax to read a field value from a row that the user clicks on a button or hyperlink in a repeating table.

The intent of this is to pass the specific id field value for that row to another form that is being opened and populated.

My current attempt to read the field value is:

var param1=XDocument.DOM.currentNode("/dfs:myfields/dfs:datafields/d:Company/@ID").text;

The problem is that this retrieves the id field value for the first row in the repeating table, rather than for the row that was clicked on.

Any ideas to make this work would be sincerely appreciated.

Jim

You can do the following. It is in VBScript, in JScript you would call parseInt(...) instead of CInt(...)

Function GetCurrenntFooIndex
GetCurrenntFooIndex = CInt(XDocument.GetNamedNodeProperty(XDocument.DOM.selectSingleNode("//my:Foo"), "CTRL656", -1))
End Function

You will need to extract all of your files from the XSN and go into the view. Then search for xdRepeatingTable and find the xd:CtrlId.

Note that -1 will be returned if there is any error. Suggest putting it into a constant.

Finally I have only been able to get this code to work if I go to the Repeating Table property window, click on the Master/Detail tab, and select the Set as Master option, even though the table is not a master/child table. Can anyone explain that?

Hi,

try (sorry it's in c#):

string param = e.Source.selectSingleNode("/dfs:myfields/dfs:datafields/d:Company/@ID").text

++

Thierry

Every moment hesitated is a moment gone for life!!! Think about it

Thanks for the suggestions.

One question from a newbie:

How do I declare the object "e" in the following code that you suggested:

e.Source.selectSingleNode("/dfs:myfields/dfs:datafields/d:Company/@ID").text

I tried using eventobj instead of e and that did not work either.

Thanks for your help.

That "e" object reference would only work if the code was placed inside of an event handler. That may or may not be what you need. The author did not specify which event in the Repeating Table would be used.

If you have a button on your form that will open another form I think that the code I referenced above may be what you need. You could write something like:

Dim iCurrentIndex = GetCurrenntFooIndex()
If iCurrentIndex <> -1 Then
XDocument.DOM.selectNode("//my:Foo")(iCurrentIndex)
End If

Thanks to all who helped. I finally got it working. I used this

e.Source.selectSingleNode("@ID").text

rather than this

e.Source.selectSingleNode("/dfs:myfields/dfs:datafields/d:Company/@ID").text

Thanks again.