Code

Re: How to get row number (index) in repeating table from a button click inside the table

stpowell — Thu, 16 Aug 2007 18:27:04 GMT

Yes Group2 is the name of the repeating table (see my orginal post for the data structure). Could the prblem be that I am coding in VB and not jscript? I was told thatcount(preceding-sibling::Group2) + 1is jscript. Maybe you can’t mix jscript in the button rules when using VB code

Any other ideas?

Re: How to get row number (index) in repeating table from a button click inside the table

nukkumatti — Thu, 16 Aug 2007 10:18:58 GMT

just to be sure is Group2 really the name of your repeating section or do you use the correct name in your solution and just didn't post it here because in my opinoin your statement seems to be correct.

Re: How to get row number (index) in repeating table from a button click inside the table

stpowell — Wed, 15 Aug 2007 02:37:43 GMT

I tried putting in count(preceding-sibling::Group2) + 1 as the value and when I clicked the verified the formula button, I received the following error:

"preceding-sibling::Group2" does not point to a valid location path of a field or group.

I then tried count(“preceding-sibling::Group2”) + 1 and got the following error message:

Argument 1 must return a node-set.

-->count("preceding-sibling::Group2")<-- + 1

Anyone have any other ideas?

Steve

Re: How to get row number (index) in repeating table from a button click inside the table

Catharine — Tue, 14 Aug 2007 16:30:49 GMT

Hi I was wanting to do something similar. I created an additional hidden field in my group - with a default value of

count(preceding-sibling::Group2) + 1

then when the button is clicked the value in the hidden field can be used.

Just an idea

Catharine

Re: How to get row number (index) in repeating table from a button click inside the table

nukkumatti — Tue, 14 Aug 2007 05:33:19 GMT

it's not c# it's jscript. try to replace var with set

Re: How to get row number (index) in repeating table from a button click inside the table

stpowell — Mon, 13 Aug 2007 14:43:48 GMT

I have found another post that shows

var nCount = eventObj.Source.selectNodes("preceding-sibling::Row").length + 1;

and it states that this should give me the current row. However I believe this code is for C#. Assuming that it works in C#, is there a VB syntax of this code?

Re: How to get row number (index) in repeating table from a button click inside the table

stpowell — Mon, 13 Aug 2007 14:31:00 GMT

Position() is not recognized as a valid function in InfoPath 2007 using VB. In VB you do use brackets.

I am beginning to wonder if

e.Source.Select("XXX").CurrentPosition

is correct. No mater what I put in for the XXX the CurrentPosition always returns a value of zero.

Are there any other ideas from all the experts?

Re: How to get row number (index) in repeating table from a button click inside the table

nukkumatti — Mon, 13 Aug 2007 05:57:36 GMT

i guess that myFields/group1/group2[position()]/field1 will give you the value you need. not completely sure, just play around a bit with the position and/or the last() function and the xPath. take care of the bracktes could be () in VB instead of []. hope this helps

How to get row number (index) in repeating table from a button click inside the table

stpowell — Sun, 12 Aug 2007 17:02:50 GMT

I am using InfoPath 2007 and writing code in VB.

I have a repeating table and in the last column I have a button. When I click on the button I want to determine the row number (index) among other things.

I have already figured out how to read the date in the row that I click the button.

e.Source.SelectSingleNode("my:field1", NamespaceManager()).Value

I have tried

e.Source.Select("XXX").CurrentPosition

However I can’t figure out what to put in for the xpath string (Note: the XXX is just a placeholder for my question)

I created a test case inored to try determin the the correct code to use. The data structor is

myFields

group1

group2 <- this is the repeating table

field1

My table looks like

---------------------------

| text field | button | <- Clicking this button should return row 1

---------------------------

| text field | button | <- Clicking this button should return row 2

---------------------------

| text field ! button | <- Clicking this button should return row 3

---------------------------

Thank you for your help

Steve