InfoPath Dev

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

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

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.

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