 |
 | 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 2005Assign identification to a form
Is there a script that can be written in visual basic to attach to a form that will auto generate a number each time a form is filled out? Seems like a basic concept but I can't find anything about it. Hi Diana, Autonumber based on what? a central DB, all the local copies of 1 form? Do you have more than 1 user using that form? Regards, Franck Dauché > Is there a script that can be written in visual basic to attach to a form > that will auto generate a number each time a form is filled out? Seems like > a basic concept but I can't find anything about it. I have forms that a user will fill out and submit to SharePoint. There is no uniques "title" or other identifying info when submitted. Another user could come along and fill out the form with the same information in the title field and it would overwrite or just not save this totally new submission to SharePoint. The only fix I have been able to come up with is to have the user enter the title plus a description which would have to be different everytime. This is kind of like using a change request form and having the CR field as the title field and making the title CR-1, CR-2, CR-3, etc., however I cannot depend on the user to number or uniquely identify the request they are submitting by the title, so I thought if there was an auto-generate feature already built in to InfoPath I could use that as the "title" and relieve the user of having to do anything. Or would this need a VB script? > Hi Diana, > [quoted text clipped - 8 lines] > > that will auto generate a number each time a form is filled out? Seems like > > a basic concept but I can't find anything about it. > I have forms that a user will fill out and submit to SharePoint. There is no > uniques "title" or other identifying info when submitted. Another user could [quoted text clipped - 22 lines] >>>that will auto generate a number each time a form is filled out? Seems like >>>a basic concept but I can't find anything about it. I have gone about this by holding a table in a central database with a unique identifier field that holds a serial number that increments everytime that a record is added. I have then written a webservice in C# that generates a GUID, inserts this into a second field in my database table and then returns the GUID and the unique identifier. I have set up this webservice as a secondary datasource for my Infopath form and use it to populate a couple of fields on submitting to SharePoint. Paul Webster http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=723 Regards, Franck Dauché > Is there a script that can be written in visual basic to attach to a form > that will auto generate a number each time a form is filled out? Seems like > a basic concept but I can't find anything about it. |
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.