Browser Forms

Re: Formula Throws Unsupported Error

Levski — Tue, 06 Apr 2010 14:46:02 GMT

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.

Re: Formula Throws Unsupported Error

Alec Pojidaev — Tue, 06 Apr 2010 14:31:37 GMT

Oops uploaded wrong version. Fixed. Check it again.

Re: Formula Throws Unsupported Error

Levski — Tue, 06 Apr 2010 14:10:11 GMT

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).

Re: Formula Throws Unsupported Error

Alec Pojidaev — Tue, 06 Apr 2010 13:26:20 GMT

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

Re: Formula Throws Unsupported Error

Levski — Tue, 06 Apr 2010 09:12:45 GMT

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

Re: Formula Throws Unsupported Error

Levski — Mon, 05 Apr 2010 22:42:19 GMT

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.

Re: Formula Throws Unsupported Error

Alec Pojidaev — Mon, 05 Apr 2010 21:26:46 GMT

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.

Re: Formula Throws Unsupported Error

Levski — Mon, 05 Apr 2010 20:19:07 GMT

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.

Re: Formula Throws Unsupported Error

Alec Pojidaev — Mon, 05 Apr 2010 13:58:13 GMT

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/

Formula Throws Unsupported Error

Levski — Fri, 02 Apr 2010 16:35:14 GMT

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.