General

Re: Unique form number/name generation?

bladah29 — Wed, 29 Oct 2008 00:36:05 GMT

Here's the method that I found works the easiest:

The solution will allow you to generate a unique ID when the form is submitted to the library. It will also give you the capability to edit the form and re-submit without creating a new item every time it is re-submitted.

Re: Unique form number/name generation?

altfeder — Fri, 30 May 2008 20:11:18 GMT

Here's an approach which avoids a specific problem. The problem: if you save your InfoPath form using a name generated from a concat of field values, then save the form, then go back and edit one of those field values, then save again, you will result in 2 files: the original (pre-edited) form and a new form with a file name reflecting the new field values. In other words, 2 forms. VERY BAD!!

Here's the solution: simple and takes 5 minutes to implement: http://davesmossblog.blogspot.com/2008/05/how-to-submit-infopath-forms-with.html

Re: Unique form number/name generation?

10basetom — Thu, 24 Jan 2008 05:33:19 GMT

Thanks for the input, Clay. This helped me resolve my problem. 8)

Tom

Re: Unique form number/name generation?

Clay Fox — Thu, 24 Jan 2008 02:56:33 GMT

Instead of using now() each time. Set in Open Rules if the form is new (a required field is blank or whatever) to populate a field with Now() which essentially is creationdate.

Then use this new creationdate field in your file name and do not modify if the form is opened again. That way your file name remains the same through out the life of the file.

Another method would be to put a file name field in the form, use your rules to create the name if the field is blank, then use the field as the file name. That way it is created once and gets reused each time.

Re: Unique form number/name generation?

10basetom — Thu, 24 Jan 2008 02:24:49 GMT

Ted Fitch:
Hi Jeff,

You can do this without code. One way I have done this within InfoPath is to concenate a unique name by using:

the user alias of the person submitting the form, data from one required field in the form, and then the now() function that returns the current date/time in ISO format. This should give you a unuqie name that would be very hard to duplicate.

Hope that helps

Hi Ted, I tried this solution before, but it didn't work for me because every time a user edits the form from within SharePoint, a new form filename gets generated, so when they resubmit the edited form, a new record is added to the SharePoint list. I'm struggling with the same thing: how to generate a unique form filename ONCE only when the form is initially created. Now if there was some way to reference the form file's Creation Date... Tom

Re: Unique form number/name generation?

Jeff.Wang — Wed, 20 Jun 2007 00:31:31 GMT

Thanks a lot Ted, this definitely will be one of my options, but is there any way to have a predefinable string format setup? e.g. I need the form name like "JSA-001" or something based on a serial number, instead of a date/time based string?

Re: Unique form number/name generation?

Ted Fitch — Tue, 19 Jun 2007 06:56:04 GMT

Hi Jeff,

You can do this without code. One way I have done this within InfoPath is to concenate a unique name by using:

the user alias of the person submitting the form, data from one required field in the form, and then the now() function that returns the current date/time in ISO format. This should give you a unuqie name that would be very hard to duplicate.

Hope that helps

Unique form number/name generation?

Jeff.Wang — Tue, 19 Jun 2007 06:03:53 GMT

I am submitting InfoPath forms into MOSS2007, and this needs generating a unique form name (XXX.xml) each time, is there any solution we can avoid web service and database? Better to figure out within InfoPath or MOSS.

Jeff.