enter image description hereI used this as my reference:

Auto-numbering InfoPath forms when they are submitted to a SharePoint form library

I followed that link but it wont work correctly,instead of having 1,2,3... as filename it creates NaN as it's file name.. what should I do?

look at the image:

enter image description here

  • What is the data type of the field RFQ No? What is the data validation? What rules are applied? How is the field populated? Put the details in the question. – teylyn Sep 10 '14 at 20:32

NaN is the error code for "not a number". The steps you take to increment do not result in a number. If you are using the MAX() function as described in the tutorial, check that the field you are using in that function is a number, not text.

Note the "caveat" on the tutorial: If the library does not yet contain any documents, the Max() function will return NaN. You must name the first form manually.

| improve this answer | |
  • ahhh okay ill try – doraemon27 Sep 10 '14 at 3:15
  • telyn, i did what you said but i still get NaN... what should i do? – doraemon27 Sep 10 '14 at 4:09
  • How many items are in the library? – teylyn Sep 10 '14 at 4:48
  • items? You mean textboxes?? i got 14 textboxes and a repeating section – doraemon27 Sep 10 '14 at 4:53
  • No, the library where you want to save the form. How many forms are already in the library? – teylyn Sep 10 '14 at 5:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.