https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/121683.aspxWed, 02 Oct 2019 21:48:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121683noartist0https://www.infopathdev.com:443/forums/thread/121683.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121683I corrected my previous message, thank youhttps://www.infopathdev.com:443/forums/thread/121682.aspxWed, 02 Oct 2019 21:44:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121682Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121682.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121682Change 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.https://www.infopathdev.com:443/forums/thread/121681.aspxWed, 02 Oct 2019 21:35:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121681noartist0https://www.infopathdev.com:443/forums/thread/121681.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121681it looked empty when I tested with a system account, but it seems to be improved when I try with a user account, thankshttps://www.infopathdev.com:443/forums/thread/121680.aspxWed, 02 Oct 2019 21:00:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121680Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121680.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121680In 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?https://www.infopathdev.com:443/forums/thread/121679.aspxWed, 02 Oct 2019 20:55:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121679noartist0https://www.infopathdev.com:443/forums/thread/121679.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121679I did as you explained but it didn't work.https://www.infopathdev.com:443/forums/thread/121678.aspxWed, 02 Oct 2019 19:34:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121678Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121678.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121678It 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.https://www.infopathdev.com:443/forums/thread/121677.aspxWed, 02 Oct 2019 19:20:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121677noartist0https://www.infopathdev.com:443/forums/thread/121677.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121677where and how can I make this change?https://www.infopathdev.com:443/forums/thread/121674.aspxWed, 02 Oct 2019 19:05:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121674Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121674.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121674Your new SharePoint site uses Claims Authentication. That is a claims prefix. You should be able to use the substring-after function to remove them.https://www.infopathdev.com:443/forums/thread/121673.aspxWed, 02 Oct 2019 17:56:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121673noartist0https://www.infopathdev.com:443/forums/thread/121673.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121673After moving the forms began to work where the number left, thank you. i:0#.w| These characters appear at the beginning of the domain and username field, how do I prevent them from appearing?https://www.infopathdev.com:443/forums/thread/121660.aspxTue, 01 Oct 2019 21:36:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121660Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121660.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121660Right. That's the behavior I'd expect. Max(ID) is now returning a number. When you move the old docs into the library, there will be IDs returned to the data source, so the formula should work as anticipated.https://www.infopathdev.com:443/forums/thread/121656.aspxTue, 01 Oct 2019 20:54:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121656noartist0https://www.infopathdev.com:443/forums/thread/121656.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121656When a new document is added, the number increases to "+1". how did this form generate the first number "01"? What should I do to continue counting? Can you look at the two screenshots I've added? I haven't added a document to the new library yet, so doesn't "NaN" generate numbers? If I move "xml" documents from the old library to the new library, will "NaN" continue to generate numbers?https://www.infopathdev.com:443/forums/thread/121653.aspxTue, 01 Oct 2019 20:30:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121653Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121653.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121653My guess is that max(ID) returns a value in your old form because there are files in the library. If there aren't any items in the library, max(ID) + 1 will return not a number. If you use rules to set the field instead of a default value, you can work around that - add conditions for what to do if ID is not present.https://www.infopathdev.com:443/forums/thread/121651.aspxTue, 01 Oct 2019 20:16:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121651noartist0https://www.infopathdev.com:443/forums/thread/121651.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121651I've added both forms. working and non-working forms are attached. Meanwhile, the language of sharepoint 2010 is English. The language of Sharepoint 2016 is Turkish.https://www.infopathdev.com:443/forums/thread/121649.aspxTue, 01 Oct 2019 19:52:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121649Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121649.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121649Can I see a copy of your form? You can attach it in a reply under the options tab.https://www.infopathdev.com:443/forums/thread/121648.aspxTue, 01 Oct 2019 16:29:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121648noartist0https://www.infopathdev.com:443/forums/thread/121648.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121648I'm transferring a form on 2010 SharePoint to Sharepoint 2016. but I have a NaN problem. I'm having trouble as I showed in the video on the link. https://www.youtube.com/watch?v=WZtCzv-PVoc