Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 821
  • Last Modified:

SharePoint Auto Numbering in InfoPath 2007

I am trying to Create a Purchase order form using InfoPath published thru Sharepoint

So I download the Purchase order Template from Microsoft download and tweaked it.

Now i needed to create a Recurring number sequence .. So I found this web site to help me

http://www.bizsupportonline.net/browserforms/autonumber-infopath-form-submitted-sharepoint-library.htm 

Now It seems to work fine. it names the files and adds a number after each one, great..
 
but when i open the file I dont see the number I get a fasle in the text field. instead of the number  
0
gotti777
Asked:
gotti777
  • 3
  • 3
1 Solution
 
melli111SharePoint Administrator / DeveloperCommented:
Could you possibly post your form here so I can take a look at it?  Make a copy of the form and change the file extension to .txt and then attach it to a new comment here.
0
 
gotti777Author Commented:
Sure
here you go

I have some rules for submit that create the numbers..
Purchase-Order-Test.txt
0
 
melli111SharePoint Administrator / DeveloperCommented:
Ok I see the problem... In the formula (on the rule on the submit button to set the value of the autonumber field) you have "autonumber = max(@ID) + 1"..... you don't need the "autonumber = " part... just the max(@ID) + 1.    Having the autonumber =  in the formula is checking to see if the autonumber field is equal to the max ID + 1... which returns a false value.  Get rid of that and you'll be good to go  :)
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
gotti777Author Commented:
Well i removed the autonumber = max  
a
it still names it right  but now when i open it it always reads a 5

 b
0
 
melli111SharePoint Administrator / DeveloperCommented:
Hello, you actually didn't want to remove the max - you need the max part.  In the value from your screenshot above change it to look:

max(@ID) + 1
0
 
gotti777Author Commented:
Perfect thanks....
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now