InfoPath Dev

Hi All:

 I have a pepeater table and trying to copy the previous row to the new row once a user clicks 'add new row'.

My approach is to set up a formular for each column as default value.

 Here is my field structure:

- myFields

-- my:FootprintGrp

----- Field1

----- Field2

 So I opened Field1 and added the following formula as a default value:

../preceding-sibling::my:my:FootprintGrp/@Field1

 I always receive Validation Errors.

 Can someone point me to the right direction ?

thanks,

Mike

Right click Field1 in the main data source task pane and select copy XPath - is it really an attribute? Paste the XPath in a reply and I can help you out.

Thank you Hilary.

So here is the actual example xpath of a field from the repeater table:

 /dfs:myFields/my:FootprintGrp/my:FootprintCommRate

Earlier I just used Field1 but it actually is FootprintCommRate.

Thank you so much in advance

Mike

Okay, so if you want to set FootprintCommRate to the preceding value:

../preceding-sibling::my:FootprintGrp/my:FootprintCommRate

awesome. it works like a charm.

 Bets of all, I know now how the syntax goes.

Thanks so much Hilary.

You bet, glad that helped - for more, you may want to take a look at this: http://zvon.org/xxl/XPathTutorial/Output/example16.html

Hi Hilary,

 do you mind if I ask for help one more time ?

 Everything is working in the filler but once deployed as web form the fields behave strange. For example when I select a dropdown value in the repeating table it jumps back to blank immediately. I assume this is because it is the first row in the table and preceding row does not exist.

How would you work around that problem?

thank you!!

I might have found the solution myself.

I turned off "refresh value when formula is recalculated" and it seems to start working as expected.

is that how to do it?

thanks again

Maybe instead of using this as a default, you could add a rule to the repeating group to set the field to the preceding sibling. Then when the row is inserted, the field gets set.... But if turning off refresh works for you, that's great too. :)

good idea. Might go that route if I run into other problems with the default value.

thanks again Hilary

Hi Hilary,

You seem like the expert with xpath so I have one more question for you.

The following will give me the value of field AmendVerNum of first row.

AmendmentGrp[1]/AmendVerNum

 How can I get the value of the last row ?

thanks again

Hi Mozzak,

The XPath for that would be

AmendmentGrp[last()]/AmendVerNum

If you're using a browser form and it doesn't like the use of last(), then this one will probably work:

AmendmentGrp[not(following-sibling::my:AmendmentGrp)]/AmendVerNum