 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / December 2004How do I create a auto number field on a form?
I want to use Infopath to create Field Tickets. I need to generate a sequential number automatically everytime I fill out a new form. Search this Newsgroup for earlier information but here's a quick recap. Create a seperate file with just the ticket number. Using script, open the file, increment the number then save and close the file. Don't forget to include code for issues such as retries when the file is busy. You can get unique, sequential numbers using a combination of users ID and a date and time stamp, but that probably wouldn't be a good option for ticket numbers.  SignatureJerry Thomas[MSFT] <Jerryth@online.microsoft.com> Microsoft Office InfoPath --------------------------------------- This posting is provided "As Is" with no warranties, and confers no rights. Use of any included script sample are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm. Please do not send email directly to this alias. This alias is for newsgroup purposes only. > I want to use Infopath to create Field Tickets. I need to generate a > sequential number automatically everytime I fill out a new form. Why not Use the XPath generate-id() to create a Unique ID on first open the store it to what ever data source your using... > Search this Newsgroup for earlier information but here's a quick recap. > [quoted text clipped - 9 lines] > > I want to use Infopath to create Field Tickets. I need to generate a > > sequential number automatically everytime I fill out a new form. >> > I want to use Infopath to create Field Tickets. I need to generate a >> > sequential number automatically everytime I fill out a new form. >> Search this Newsgroup for earlier information but here's a quick recap. >> [quoted text clipped - 7 lines] >> date and time stamp, but that probably wouldn't be a good option for ticket >> numbers. >Why not Use the XPath generate-id() to create a Unique ID on first open the >store it to what ever data source your using... First, that generates a string of random alphanumeric characters, not a sequential number. Second, there's no way to store the value. Regards, Steve -- Please post questions to the newsgroup; everyone benefits. This posting is provided "AS IS" with no warranties, and confers no rights. Sample code subject to http://www.microsoft.com/info/cpyright.htm One way is to use store your unique counter in a file and increment i after setting ur ticket number in infopath form and save it back. Fo this you need to open file in your infopath everytime new form i created - advanceduse Dear deers ! I got a hint, but I do not know how to program the autonumber field. Do you have scrip in .net 2003 for example ? Merry christmas. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.