 |
 | 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 / August 2007how do i set up automatic sequential numbering
Trying to create a form where my case number is automatically generated based on the last number used and a specific format At what point does it need to "know" the new, case number? Does it need to assign that number as soon as the InfoPath form is opened or, can it wait until the form is "submitted" to a back-end process (i.e.: via a WebService). Also, is the form used by one person or by multiple users within the organization? The number is needed when the form is opened. If possible, when the enter key is used in the case number box, which is the first box on the form. The case number is also used in another area of form. The form will be used by a few people. > At what point does it need to "know" the new, case number? Does it need to > assign that number as soon as the InfoPath form is opened or, can it wait > until the form is "submitted" to a back-end process (i.e.: via a WebService). > > Also, is the form used by one person or by multiple users within the > organization? Hi fans ! Do you mean automatic number generation ? There is one articel in the knowledge base already. Should I look for it ? Best wishes please! > Hi fans ! > [quoted text clipped - 3 lines] > > Best wishes are you referring to an autoincrement column? if so then within sql database, define a column as ID, int(4), select it as a primary key, uncheck "allow nulls", in the details section(bottom left of your enterprise manager), set identity as yes, and increment by 1. hope this is something you were looking for. NK Is there a way to do this out of an Access database? Absolutely. In the design view for a table, set the Field Name as "ID" or whatever you want to. For the "ID" column, set the Data Type to AutoNumber. In the field properties (bottom pane), check the Indexed value, if you want ID to be primary key then choose Indexed as "Yes (No Duplicates)" That should do the trick. NK I would like to have the same function in InfoPath. I created an issue tracking form and I would like to have an autonumber generated for the ID field in this form. I am not using MS Access to store all the data entered in this form, instead, this form will be published to Sharepoint and users will be entering data from there. How can I assign the next sequential number to my ID form everytime when the form is loaded? Please help. > Absolutely. > [quoted text clipped - 6 lines] > > NK You need to set up a web service somewhere to generate these unique ID's. The logic for that web service should be very simple: open some text file, read off the number from it, give it to the client, increment the number, write back to the file. Be careful with synchronization and locking, though. Add that web service as a data connection to your InfoPath form. Good luck, Alex @ Microsoft >I would like to have the same function in InfoPath. I created an issue > tracking form and I would like to have an autonumber generated for the ID [quoted text clipped - 18 lines] >> >> NK So I understand the concept behind this Alex, but since I am a newby, steps would be very helpful. Steps creating the code to do this, where to put the code, or the text file, etc etc. If someone can please take the time to show this step by step, that would be most helpful! Thanks. > You need to set up a web service somewhere to generate these unique ID's. > The logic for that web service should be very simple: open some text file, [quoted text clipped - 5 lines] > Good luck, > Alex @ Microsoft |
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.