InfoPath 2010

Re: xpath to search Infopath repeating table for the next record with a certain value in a variable and return the corresponding record number

AndreasEG — Sat, 14 Mar 2015 09:56:28 GMT

Hi Hilary, thanks - great - it works perfectly.

Re: xpath to search Infopath repeating table for the next record with a certain value in a variable and return the corresponding record number

Hilary Stoupa — Fri, 13 Feb 2015 20:07:15 GMT

I think this would be the right formula:

../following-sibling::my:group2[my:Track = "true"]/my:CurrentRecord

xpath to search Infopath repeating table for the next record with a certain value in a variable and return the corresponding record number

AndreasEG — Sun, 08 Feb 2015 11:18:10 GMT

Hi,

I have a repeating table with 3 variables:

"CurrentRecord": automatically filled with a sequential record number 1,2,3...

"Track": boolean: filled by the user as yes/no

"NextTrackedStep": number which should be calculated as the "CurrentRecord" of the next record where "Tracked" is true.

The table looks like this:

Current Record; Track; Next Tracked Step

1;true;2

2;true;5

3;false;5

4;false;5

5;true;6

6;true;

I tried this formula for the default value of "NextTrackedStep" but it does not work: ../following-sibling::my:group2[true() = (../following-sibling::my:group2/my:Track)]/my:CurrentRecord

Event though this is a simple search problem I could not find an article that really fits.

Any idea?

I attach the XSN and XML files.

Regards

Andreas