InfoPath Dev

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.

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.

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

 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.

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

I corrected my previous message, thank you

Change the formula back and verify you have the prefix correct, I guess? You could also add a calculated value field that shows the result of the userName() function for testing - to make sure the prefix is right. Or you could use substring-after just the "|" char.

it looked empty when I tested with a system account, but it seems to be improved when I try with a user account, thanks

In preview, your userName won't have the claims prefix. Are you checking it in preview or in the browser? Can you tell me what "doesn't work" means here? No result, incorrect result, etc?

I did as you explained but it didn't work.