General

Re: Display Last Value from Field in Repeating Table

Hilary Stoupa — Tue, 19 Mar 2013 18:39:51 GMT

You just need this part:

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

The last() function goes on the repeating group.

Re: Display Last Value from Field in Repeating Table

JudyH — Tue, 19 Mar 2013 18:22:42 GMT

../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 judy.havlik@plitek.com

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

Re: Display Last Value from Field in Repeating Table

Hilary Stoupa — Tue, 19 Mar 2013 18:14:45 GMT

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

Re: Display Last Value from Field in Repeating Table

JudyH — Tue, 19 Mar 2013 18:09:18 GMT

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.

Re: Display Last Value from Field in Repeating Table

Hilary Stoupa — Tue, 19 Mar 2013 17:16:00 GMT

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.

Re: Display Last Value from Field in Repeating Table

JudyH — Tue, 19 Mar 2013 17:06:59 GMT

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

Re: Display Last Value from Field in Repeating Table

Hilary Stoupa — Tue, 19 Mar 2013 16:49:34 GMT

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

Re: Display Last Value from Field in Repeating Table

JudyH — Tue, 19 Mar 2013 16:15:32 GMT

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.

Re: Display Last Value from Field in Repeating Table

JudyH — Tue, 19 Mar 2013 14:55:33 GMT

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????

Re: Display Last Value from Field in Repeating Table

ErnestoM — Tue, 19 Mar 2013 13:23:17 GMT

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!

Display Last Value from Field in Repeating Table

JudyH — Mon, 18 Mar 2013 17:26:07 GMT

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