InfoPath Dev

I have a form that will be filled out and stored on a Sharepoint site.  On page 1 of the form there is a repeating table that contains 3 field...Revision, Description, and Date.  Each time a user revised the form they will add these three fields and the form will always display the history of the changes. 

 Page 2 has a field where we want to show only the most current revision level for the document, so if Page 1 shows 3 lines, Rev A, Rev B, Rev C, page 2 should only show the most recent revision, Rev C.

 I don't have any idea how to create the field on page 2 that will only see the latest revision from Page 1.  Is this possible?

 Sincerely,

JudyH

Hi Judy,

Take a look at the Change History XTPs available on this site. They should satisfy your requirement.

http://www.infopathdev.com/files/folders/templateparts/entry60775.aspx

http://www.infopathdev.com/files/folders/templateparts/entry60774.aspx

Good luck!

I tried to access the above but had no luck.

I have been able to figure this out a little.

My repeating table is:

RevTable   :   RevGroup   :   fldQPRev. 

The field I want to set up to display the last occurance of fldQPRev is fldRevCopy. 

The formula I have in fldRevCopy is:  RevGroup[last()] / fldQPRev

 All fields are marked as Text HOWEVER, if I enter fldQPRev with a numeric value, fldRevCopy works fine.  If I enter it the way I want it, with A, B, C, all fldRevCopy shows is NaN?  Why is it looking for a numeric value????

Ironically, I found a document that clearly shows how to write the Function statement in my field.  Using the data above it would be:

RevGroup[last()]/fldQPRev

Unfortuantely, it will not accept this statement.  It wants you to write RevGroup[last()] / fldQPRev and then it will accept it. 

So then, when I get it to accept the statement as not having errors it will only recognize numeric values and not alpha.  It makes no sense to me...hope someone can help.

 Well - your expression with the spaces around the "/" is division - which explains the NaN error.

Try using the compete XPath - you are probably using the default "my" namespace, so it would look like:

my:RevGroup[last()]/my:fldQPRev

Thanks so much, Hilary, for your suggestion.  I appreciate it so much.  

I entered my:RevGroup[last()]/my:fldQPRev and received the verification error message:

"my:RevGroup/my:fldQPRev" does not point to a valid location path of a field or group

 I think you should use the field picker to select fldQPRev. Then check the little checkbox in the formula editor for Edit XPath. Then type in [last()] next to the repeating group- RevGroup. That may be the most straightforward approach.

Hilary, you are so kind.  I tried what you said and it says "Expected value type:  end-of-string"

This is so frustrating.  I've researched so much on the internet, in archives and nothing seems to help. 

Can you paste in exactly what you have in the formula editor? Check the Edit XPath box first... :)

../my:RevTable/my:RevGroup[last()]../my:RevTable/my:RevGroup/my:QPRev

 If you want to e-mail me, can send you the form itself.  I am at [email protected]

 I can't tell you how much I appreciate the time you're taking.

 You just need this part:

../my:RevTable/my:RevGroup[last()]/my:QPRev

The last() function goes on the repeating group.