InfoPath 2010

Re: Infopath Repeating Table for Sharepoint 2010 - Populate a field with an entry from a different variable in a different, dynamically determined record

AndreasEG — Wed, 07 Jan 2015 11:42:03 GMT

Hi Hilary - many thanks !!!! - it works fine - you helped me a lot.

Re: Infopath Repeating Table for Sharepoint 2010 - Populate a field with an entry from a different variable in a different, dynamically determined record

Hilary Stoupa — Mon, 05 Jan 2015 15:50:21 GMT

That made it easy to help, thanks! Use this for your calculated value for CopiedDate:

../../my:group2[my:CurrentRecord = current()/../my:CopyDateFromThisRecord]/my:PlannedCompletionDate

Re: Infopath Repeating Table for Sharepoint 2010 - Populate a field with an entry from a different variable in a different, dynamically determined record

AndreasEG — Sat, 03 Jan 2015 12:24:40 GMT

Hi Hilary, thanks. I just added the XML and XSN under the options tab of my original post above.

Re: Infopath Repeating Table for Sharepoint 2010 - Populate a field with an entry from a different variable in a different, dynamically determined record

Hilary Stoupa — Fri, 02 Jan 2015 23:08:33 GMT

If you'll attach your form under the Options tab I can give you a hand with this.

Infopath Repeating Table for Sharepoint 2010 - Populate a field with an entry from a different variable in a different, dynamically determined record

AndreasEG — Fri, 02 Jan 2015 23:00:02 GMT

Hi, basically I would like to build something like a simple MSProject timeline calculation in a Sharepoint repeating table with Infopath.

Important: I need a solution in Infopath xpath and no VB/C# solution since code is blocked by the server.

My table looks like this where only the first three columns are filled out manually and the fourth one (i.e. "CopiedDate") is calculated:

CurrentRecord ; PlannedCompletionDate ; CopyDateFromThisRecord ; CopiedDate

1 ; 12/08/2013 ; ;

2 ; 11/12/2013 ; 1 ; 12/08/2013

3 ; 12/30/2013 ; 1 ; 12/08/2013

4 ; 01/11/2014 ; ;

5 ; 12/13/2014 ; 3 ; 12/30/2013

The idea is to fill the "CopiedDate" of each record with the "PlannedCompletionDate" from the record specified in "CopyDateFromThisRecord": For example the "CopiedDate" in record 3 would be populated with the "PlannedCompletionDate" from record 2.

I tried this by setting the Default Value of the "CopiedDate" field to: ../preceding-sibling::my:group2[../my:CurrentRecord = ../my:CopyDateFromThisRecord]/my:PlannedCompletionDate

Unfortunately all CopiedDate fields are empty. I also played around with "current()" but without any meanfulgful results

Any idea what I am doing wrong with the filtering?

Andreas