 |
 | 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 / April 2006Create unique ID for every submission
Hello, I have a form which is filled out and sent to one single contact every time someone has a request. The requested person needs a unique ID for every form. I suggested using Email adress in conjunction with date and time but this did not suit his needs. He wants to have a numeric one. Is there a way how to implement that in Infopath? I am not storing the forms anywhere, only Emails to be sent out. The criteria the number must fulfill are only: - numeric - unique No need for it to be ascending step 1 and also no need for it to make any sense. It just shouldn't be like any previous one. Thanks, Martin Linking the form to a database (see elsewhere on this board) would provide the funtionality. On submission of the form the USERID would log itself in the database and return the ID Number which is guaranteed to be unique as it is only generated once the data is written into the table. Otherwise you can do the whole date time thing without any non-numeric characters ie 18 April 2006 11:21:56 would be 04082006112156 Also unique. Hope this helps. Cheers Adam > Hello, > [quoted text clipped - 17 lines] > Thanks, > Martin Check out this link in InfoPathdev.com for the answer. http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=2102 > Linking the form to a database (see elsewhere on this board) would provide > the funtionality. [quoted text clipped - 34 lines] > > Thanks, > > Martin > Hello, > [quoted text clipped - 17 lines] > Thanks, > Martin You can only guarantee the unique ascending number by using a database. It creates a new row each time you call into it for the number.  SignatureGreg Collins [InfoPath MVP] Visit http://www.BrainTrove.com Visit http://www.InfoPathDev.com Hello, I have a form which is filled out and sent to one single contact every time someone has a request. The requested person needs a unique ID for every form. I suggested using Email adress in conjunction with date and time but this did not suit his needs. He wants to have a numeric one. Is there a way how to implement that in Infopath? I am not storing the forms anywhere, only Emails to be sent out. The criteria the number must fulfill are only: - numeric - unique No need for it to be ascending step 1 and also no need for it to make any sense. It just shouldn't be like any previous one. Thanks, Martin |
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.