InfoPath 2010

Re: count(preceding-sibling::*) + 1

Hilary Stoupa — Thu, 03 Oct 2019 18:34:15 GMT

I should have mentioned there was a sample instead of just linking to Jimmy's formula that helped me! Glad you have things working.

Re: count(preceding-sibling::*) + 1

WiReLaD — Thu, 03 Oct 2019 18:28:52 GMT

Hilary - Many thanks this has sorted it...and sorry I didn't see your sample on the first reply. It was this one that did it for me. thanks again, Mike

Re: count(preceding-sibling::*) + 1

Hilary Stoupa — Thu, 03 Oct 2019 16:17:45 GMT

Here's another sample - you just need a concat to do this..... Download the linked file, right click and select Design to open in design mode. From there you can preview and check it out.

Re: count(preceding-sibling::*) + 1

Hilary Stoupa — Thu, 03 Oct 2019 16:15:35 GMT

Oh, and I see now you don't need leading zeros at all - I'm sorry, I'll attach another sample w/out that in a sec.

Re: count(preceding-sibling::*) + 1

Hilary Stoupa — Thu, 03 Oct 2019 16:14:56 GMT

My sample didn't work for you? There is a sample form attached to my earlier post with a complete formula - if you have trouble implementing it in your form, just attach a copy of your form to a reply and I'll help you out.

Re: count(preceding-sibling::*) + 1

WiReLaD — Thu, 03 Oct 2019 16:06:51 GMT

Hello Hilary, thanks for speedy response.

I'm not getting this - I've used Jimmy's concat(substring('000', 1, 3 - string-length(field)), field) and get this to work amd shows 000's but what am I supposed to do with these?

I have a repeating table with a textbox called "ScopeID" in the 1st row - If user clicks add new line, I want this text box to increase by 0.1 eg. 1.2 then 1.3 and so on?

Sorry

Mike

Re: count(preceding-sibling::*) + 1

Hilary Stoupa — Thu, 03 Oct 2019 14:43:51 GMT

Try this - courtesy of this thread: https://www.infopathdev.com/forums/p/20643/71474.aspx - the last post by Jimmy explains how to add leading zeros.

count(preceding-sibling::*) + 1

WiReLaD — Thu, 03 Oct 2019 13:37:23 GMT

Hi,

I'm sure I've seen the answer to this somewhere....? Sorry for asking this again if already covered.

Can you help? I'm trying to count(preceding-sibling::*) + 1 but I want the repeating table to count up in 0.1's eg. 1st value should start 1.0, then 1.1, 1.2, 1.3 and so on?

When I try count(preceding-sibling::*) + 1 it counts 1, 2, 3 etc...

Any help be appreciated

Thanks

Mike