-
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.
-
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.
-
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.
-
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.
-
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?
-
It really depends. You could display a calculated value using a formula that trims that off for display purposes. I see in one of the forms you sent me that the KullaniciAdi uses the userName() function as a default value - you could replace that with the substring-after function to trim off the unwanted chars.
-
I think happy is the appropriate response - I didn't think about the data type as the issue. Good job and I'm glad you found it and fixed it!
-
Your new SharePoint site uses Claims Authentication. That is a claims prefix. You should be able to use the substring-after function to remove them.
-
Can you attach a sample form in a reply under the options tab? Basically - add the filter to show only those that are selected, then change the first dropdown in the filter builder to "The expression", and wrap the entire expression in not().