General

Re: Autonumbering within a repeating table

karson6 — Wed, 22 Feb 2012 18:19:01 GMT

Ok - the Edit XPath was the difference. I tried to duplicate this function in the Improvements repeating table below and was getting the exact same error. I had added the "../" manually and InfoPath didn't like it. When I click on the Edit XPath button, the ../ is added automatically and I was able to Apply the change to the text box without error.

Thanks!

Re: Autonumbering within a repeating table

Hilary Stoupa — Wed, 22 Feb 2012 17:57:33 GMT

Oh, and select Edit XPath in the formula editor - did you have the initial "../" before preceding-sibling?

Re: Autonumbering within a repeating table

Hilary Stoupa — Wed, 22 Feb 2012 17:52:51 GMT

Honestly, without seeing what you were doing, I'm just not sure....

Re: Autonumbering within a repeating table

karson6 — Wed, 22 Feb 2012 17:45:21 GMT

Thanks Hilary - I was able to open it and see it is working. What is confusing though, is what you were able to place in the default value for landNumber via the fx button is exactly the same as I tried enter via the fx button. I checked my original post to see what was different and the syntax is identical. What could I have been doing wrong to get the data type error?

Thanks again!

Re: Autonumbering within a repeating table

Hilary Stoupa — Wed, 22 Feb 2012 16:52:42 GMT

See attached. You'll need to save the form locally, right click the template and select design to open in design mode - from there you can re-save / preview / etc.

Re: Autonumbering within a repeating table

karson6 — Wed, 22 Feb 2012 12:16:39 GMT

Sorry it took me so long to get back to this problem. I attached the form. I am trying to get the autonumbering within the landNumber field within the Land Estimate repeating table.

Thanks for your help!

Re: Autonumbering within a repeating table

Hilary Stoupa — Thu, 16 Feb 2012 20:12:05 GMT

Feel free to attach your template under the options tab and I can take a look. The formula needs to go in the formula editor - using the fx button.

Re: Autonumbering within a repeating table

karson6 — Thu, 16 Feb 2012 19:44:04 GMT

I've tried it both ways. I've clicked on the fx button and tried entering by selecting the count function. I've tried pasting my formula after clicking the fx button and I've typed it straight into the default value field without clicking the fx button. Same error each way.

Re: Autonumbering within a repeating table

Hilary Stoupa — Thu, 16 Feb 2012 18:23:59 GMT

Are you clicking on the "fx" button and using the formula editor? Or are you just typing directly in the default value text field?

Re: Autonumbering within a repeating table

karson6 — Thu, 16 Feb 2012 18:18:35 GMT

The landEstimate is the name of the repeating group. I both of the options your provided above and both give me the same InfoPath error:

The error says the The value is not valid for this field's data type. Enter a different value (example:"1234") or leave the box blank.

Am I putting the function in the right place? I added as the Default Value and my data type is Whole Number.

I'm using InfoPath 2010 if that matters.

Re: Autonumbering within a repeating table

Hilary Stoupa — Thu, 16 Feb 2012 16:57:00 GMT

Is landEstimate the field? Or the repeating group?

I'd try something like:

count(../preceding-sibling::my:RepeatingGroup) + 1

However, if your formula syntax is correct and it is just a data type issue (which would sort of surprise me - I'd expect a count + 1 to return a number) you can always add the number function:

number(count(preceding-sibling::landEstimate) + 1)

Autonumbering within a repeating table

karson6 — Thu, 16 Feb 2012 16:36:14 GMT

I have a number field within a repeating table. How can I have this automatically increment when rows are added?

I tried putting the following within the default value property of my number field but it didnt' work. InfoPath gives me an error saying the value is not valid for the field's data type - which is set to Whole Number (integer):

count(preceding-sibling::landEstimate) + 1

Thanks!