InfoPath Dev

Hello all,

We are using InfoPath 2007 SP 2 with MOSS 2007 SP2.

I have the following XPath as the default formula for a string:

../my:PurchasingSection/my:PurchasingTable/my:EventList[count(/my:myFields/my:PurchasingSection/my:PurchasingTable/my:EventList)]/my:EventDesc

which basically sets the string value as being the EventDesc field of the last row in a repeating table - in short EventList[count(EventList)]/EventDesc

 This works fine in InfoPath but throws an incompatibility error when I upload to a MOSS Form Library.

 Any help would be greatly appreciated.

 Thanking you in advance.

Indexing not supported in web enabled forms.

It still can be done although. Check this link:
http://alecpojidaev.wordpress.com/2010/01/07/accessing-previous-rows-in-repeating-group-for-browser-enabled-forms/

 Hello Alec, thank you very much for responding.

 I am experimenting with your explanation and the sample files you kindly presented on your blog - unfortunately I am unable to adapt it properly to my needs (the main difference being that your rules are attached to a button within the repeating table).

 I am trying to achieve the same with a button I have created for submitting.

 All I basically want to do is create a rule(s) on the submit button that will set the value of field outside of the repeating table to the value of a field in the last of a repeating table.

 I have a repeating table called Events and my field is LastEvent.

 Any suggestions would be very welcome.

For your scenario it would be easier to add index field to the repeating section and then query the last record using max() function. To ensure that the last record always has the highest index number assign initial value of that "index" field using max() function also.

Hi - forgive me for being ignorant, I am very new to InfoPath (this thread is my first post).

 I can create a field in the repeating table and ensure the last one has the highest number by autonumbering it. However, as to querying it - I am still indexing i.e.MyRepeatingTable[Max(MyAutoNumberField)]/MyTargetField.

 Strangely, this does not cause the Design Checker to throw up any errors - however, it still does not work. It always fetches the first row.

 I am really stuck on this guys - can what I want even be done or am I wasting my time?

I've uploaded new version of the template where the function you need already implemented.

 Alec, thanks a lot for your efforts and your patience.

Unfortunately, when I uploaded your form to a MOSS form library, I got the unsupported expression error (for the Get Value From the Last Field button rule).

Oops uploaded wrong version. Fixed. Check it again.

 You're a legend, Alec. Thanks a lot. I can finish up my first form now :-)

It remains to be seen how well InfoPath and I will get on considering all my work is browser based and looping through and referencing array items is a pretty common task. This no index limitation will take some working around. Having said that, I have looked through excellent your blog and found lots of helpful examples for future reference.

 Thanks again.