Controls

Re: Auto generate number

John Jayaseelan — Wed, 03 Aug 2011 10:38:12 GMT

Hi, So you want Unique Id right, Date with seconds will have unique ID. eg:- Create a text box with data type "Text(String)" and in the default value create this formula concat(userName(), now()) - it concatenates username with Date and Time. The value should be a Unique One.

Hope it was helpful.

Good Luck

John Jay

Re: Auto generate number

jchapin — Mon, 13 Jun 2011 19:33:05 GMT

I know this is really late, but the following link describes how to do it:

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

I'm pretty sure the thread posted above this reply was originally for random numbers.

Re: Auto generate number

Ted Fitch — Fri, 29 Jan 2010 01:20:34 GMT

Hi!

It sounds to me like you want to auto generate a unique ID for a new form and you want it to be sequential?

This is a pretty common question, if you search the forums you should find a number of threads on this.

For example here is one good thread that discusses several different ways of doing this including querying SharePoint for the SharePoint ID of the form thta was just created:

http://www.infopathdev.com/forums/p/2197/19614.aspx#19614

Good luck

Ted

Auto generate number

samdk — Thu, 21 Jan 2010 23:55:21 GMT

I have a IP2007 form having a text box control which should able to auto generated number. For example: In form library - (enable this textbox as column name) I have a form with N0001 number and when I click new form this number should to N0002 and so.... Any advices please!!! Thanks