Browser Forms

Re: Unique ID Generation

kalaicompute — Wed, 31 Dec 2008 11:41:28 GMT

I guess it will help you. http://bladah.com/?p=51

Re: Unique ID Generation

Frederik Van Lierde — Mon, 08 Dec 2008 14:01:20 GMT

Add a submit button to the page
Select to use Action: Rules and Custom Code
Add 3 Actions:

1. Action Query using a dataconnection to get the new number
2. Set the ID textbox to 1 if previous action returns Nan (Using Set Condition)
3. Action: Submit using a dataconnection to submit the form

Frederik Van Lierde

Re: Unique ID Generation

Geekavenger — Fri, 05 Dec 2008 16:13:49 GMT

Just thinking out loud here, I thought of a messy way in which I would accomplish this (and this is by no means Ideal but I think it will accomplish your goal)

-Add a new field in your form called form number

- Republish your form making sure that the form number collumn is promoted and that it is editable outside the form.

-Set your Document library as a data source

-Save a place holder document and filter it out of all views

-Now in the form set the default value of Form Number to max(@Form Number)

(Here is where it gets painfully convoluted and messy)

-Write a SharePoint Designer workflow which will Update the Placeholder Documents form number with max(@Form Number)+1 whenever a item is created in the list.

There are too many moving parts to this solution and I really don't suggest it if there is a lot of traffic with this document library but hopefully you'll be able to glean some ideas from this.

Re: Unique ID Generation

Anuma — Tue, 11 Nov 2008 14:17:32 GMT

Hi,

Read these links:

http://www.infopathdev.com/blogs/agni/archive/2006/05/15/Query-for-Items-in-SharePoint-Form-Library-Using-GetListItems-Web-Method.aspx
http://www.infopathdev.com/forums/p/9515/33664.aspx#33664

Unique ID Generation

sriram iyer — Tue, 11 Nov 2008 13:15:07 GMT

hi,

I am a new to this site & Infopath.

I have a lib in which i submit my forms and send the view of the form in mail like with my subject as concat("ABC","-",max(@ID))

Now if my lib. is empty it shows NaN in my subject were i am including the ID.how do u take care of it.

And if i have say 10 files in my lib. and i delete the 10 file, then the id also get altered for the next form which is submitted(say i del my 10 file and now add 11 one, now the Id in my mail subject is the previous one which is already deleted.)

So how can u create a unique id that gets incremented by itself when my lib is empty and also retains the value irrespective of anyone deleting the forms.