Code

Re: Repeating Table copy previous record

TracyK — Tue, 23 Aug 2016 21:54:38 GMT

I'm stuck trying to copy previous row with rule on button click. I can copy 1 row of data but I can't copy row 2 to row 3 I can only get row 1 data. I'm trying to use preceding-sibling:: but it keeps telling my formula is wrong.

InfoPath field XPath copy = /my:myFields/my:JV/my:JVDetails/my:SDN

Syntax I'm try to use but failed :-(

preceding-sibling::/my:myFields/my:JV/my:JVDetails/my:SDN

Please help...

Re: Repeating Table copy previous record

Hilary Stoupa — Mon, 23 Jul 2012 17:07:48 GMT

Wonderful, thanks for letting me know everything is working the way you need it to.

Re: Repeating Table copy previous record

BobCald — Mon, 23 Jul 2012 16:56:32 GMT

Hilary , thanks so very much for all the help, my IP form is working properly. I can't express enough how valuable your assistance was to me and I learned a few things.

Re: Repeating Table copy previous record

Hilary Stoupa — Fri, 20 Jul 2012 18:20:52 GMT

It was the XPath you'd used - it was absolute instead of relative:

/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW[1]/my:Project

The above will always get the first item. From the field you were on (Project)

../preceding-sibling::my:SharePointListItem_RW[1]/my:Project

will get you the one above.

I've attached your form with this change.

Re: Repeating Table copy previous record

BobCald — Thu, 19 Jul 2012 18:14:41 GMT

In advance thank you. 1st row Ok, 2nd row Ok, 3rd row I update Project and Project Size (these are Drop-down List Box controls), I complete the data entry and then perform the Insert. The results are that on the 4th row the Project and Project Size do not carry-over the updated values (BCC... & Large...) from the 3rd row, it seems to pull the values from the first row for Project and Project Size.

Re: Repeating Table copy previous record

Hilary Stoupa — Thu, 19 Jul 2012 17:48:48 GMT

Can you also post a screenshot showing what you are describing? I'm having a little trouble following your description. Just attach a picture file under the options tab.

Thanks!

Re: Repeating Table copy previous record

BobCald — Thu, 19 Jul 2012 17:39:48 GMT

Good Day, I ran into an issue when trying to apply the preceding-sibling on Drop-Down List Box Control. The syntax with [1] does populate the new row with the data from the previous row. What happens when going beyond two rows on this type of control is that it refers to the first row value on the active form. When trying this on a Text Box field I am able to update the copied value let's say on the 3rd row to something else and upon the insert it carries over to the next row without issue. When trying this technique with a Drop-Down List box it always copies the value from the first row. Can you please advise whether the repeating table value cannot be performed on a Drop-down List box fields. I have also attached my Template.xsn, Thanks Bob

Re: Repeating Table copy previous record

Hilary Stoupa — Thu, 19 Jul 2012 00:15:57 GMT

Hey, fantastic, glad it is working for you - here's a little blog post that may help with the syntax.

Re: Repeating Table copy previous record

BobCald — Thu, 19 Jul 2012 00:09:59 GMT

I cannot express how much I appreciate your help and expertise. The functionality that I was seeking is working is my Test SP site/list. I will expand to the other fields where I need this functionality. I will let you know tomorrow how it goes.

Re: Repeating Table copy previous record

Hilary Stoupa — Thu, 19 Jul 2012 00:02:47 GMT

I think it would be:

../preceding-sibling::my:SharePointListItem_RW[1]/my:Description

Re: Repeating Table copy previous record

BobCald — Wed, 18 Jul 2012 23:51:48 GMT

Thank You, it is working and carrying over data. Unfortunately, I left a requirement out of my description. Besides carrying over the data when a new row is added, I need it to carry over the data from the last row. I also need the data carried over to be able to be updated as maybe some fields are Ok to be carried over but it is possible that a field or two may need to be updated. So in this instance when a a field or two is updated this updated data carries over to the next new row to be inserted. I did try [Last()] as I thought I saw it in a previous post, couldn't get it to work. Do you think it is possible for the preceding-sibling to grab the last row? Thanks

Re: Repeating Table copy previous record

Hilary Stoupa — Wed, 18 Jul 2012 23:16:10 GMT

I think this will do what you want:

../preceding-sibling::my:SharePointListItem_RW/my:Description

Save the form linked in this reply locally, right click the file and select Design to open in design mode.

Re: Repeating Table copy previous record

BobCald — Wed, 18 Jul 2012 23:08:29 GMT

In advance, I really appreciate your assistance. Brief summary of what I have and trying to do. List using a InfoPath form with Repeating Table to track staff time entries. My form has a mixture of Lookup/Choice, Choice, Single line of Text and Multi lines of Text fields. I used this fields to capture my staff's time entries which write to a list. The Repeating Table has made it much easier for staff to enter time data. A requested enhancement is to when data entry for a new row (last) is complete and that upon the Insert function it inserts a new row but it also carries over the data entered of identified fields using preceding-sibling. This is what my schema looks like. I am trying to test preceding-sibling using the Description field.

Re: Repeating Table copy previous record

Hilary Stoupa — Wed, 18 Jul 2012 21:47:44 GMT

So, you are using that in your default values? And when you enter a new row, it gets the value of the row before? I'm sorry, I don't quite understand - if you could give a bit more detail / attach your temlate to the Options tab, that would help.

Re: Repeating Table copy previous record

BobCald — Wed, 18 Jul 2012 21:00:28 GMT

Hi Hilary, my name is Bob and I am trying to a little beyond using SP straight out-of-the-box; I am not a developer only a hacker per-se. I am using SP/IP 2010 and have been trying to use your example with my setup. What is happening is that when I try to enter data into my test field it wipes out the data? For the Text Box Prop here is what I am using:

../preceding-sibling::my:SharePointListItem_RW/my:Description