InfoPath Dev

Hi Jimmy,

Please find attached the screen shot for the default value that i am trying to set.

Please note that even though i am using IP 2007 at home, i use IP 2003 at office.

Please help what exactly i need to put in the preceding-sibling attribute.

Thanks.

 If you want to always copy the value from the previous row, use

../preceding-sibling::d:Table1[1]/@Reviewer

If you want to always copy the value from the first row, use

../d:Table1[1]/@Reviewer

but this should be set in the node's properties, not in the form's Default values dialog.

Please  let me know how do i set the node's property ?

yep, got it now. Was missing the node setting as well as the ../ before mentioning the preceding-sibling. Thanks a lot :)

Got the preceding-sibling usage for the node alright. Now i am able to copy over the values from the previous section to the next section in my form.

When i submit it to the MS access table, it saves the values alright. But when i query the information, i am seeing blanks in all those fields for which i had implemented the preceding-sibling. All other values which were manually entered in the section are visible. Could you please help me in knowing what's going wrong here.

 

Got the solution to this. I just went ahead and unchecked the feature which says 'Update this value when the result of the formula is recalculated' which appears below the formula.

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

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.

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.

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.

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

I think it would be:

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

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.

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

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