General

Re: InfoPath Unique ID Number

duffer73 — Tue, 05 Oct 2010 09:10:14 GMT

A soluton I have used is to query the ID of the form library on submission of the form, not when opening the form.

Setup a new Data Connection to query the form library and retrieve the ID

On a custom Submit button set the rule to run the query using the above Data Connection, and then set an action to set a field value to the ID+1.

The set an action to Submit the form to the library, using the field as part of the filename.

So, even if more than one user has the form open at the same time, it WON'T retrieve the ID until the user submits (there is still the potential for users to hit submit at the same time down to the millisecond albeit slight - this can be overcome (slightly) by appending the users ID to the filename as well further reducing the risk of duplicate filenames)

Re: InfoPath Unique ID Number

SethMW — Tue, 24 Mar 2009 22:14:42 GMT

Clay Fox:
The best way is to use SQL which will generate a unique sequential ID with each submit.

Not to hijack, but I tried this today, and an issue I ran into is the ID doesn't fully get set until you submit. In my case I had a repeating table/section with a couple fields and allowed the user to insert. I then had a button to go to a view of the item where all the fields are available. On this view I wanted to filter a repeater so that only the selected row's fields would show, but I wasn't able to use the ID because the form hadn't been submitted yet.

Re: InfoPath Unique ID Number

Jason_2009 — Tue, 24 Mar 2009 15:48:51 GMT

Clay Fox:
The best way is to use SQL which will generate a unique sequential ID with each submit.

In your case I would maybe have two libraries. Have one that is hidden by obscurity and you can control the view getting changed. That should help not being dependent on the main default view.

Or sometimes putting a date or time portion in the name could help as well.

How does the ID get incremented if there are no documents going into the hidden library?

Re: InfoPath Unique ID Number

Clay Fox — Fri, 17 Oct 2008 13:46:16 GMT

The best way is to use SQL which will generate a unique sequential ID with each submit.

In your case I would maybe have two libraries. Have one that is hidden by obscurity and you can control the view getting changed. That should help not being dependent on the main default view.

Or sometimes putting a date or time portion in the name could help as well.

InfoPath Unique ID Number

phamj — Thu, 16 Oct 2008 00:31:34 GMT

Hi all,

This has been a big issue that I've been having for awhile and I'm sure heaps of people have come across this same situation before.

I have read a few threads regarding this issue:

http://www.infopathdev.com/forums/p/2197/19655.aspx

http://www.infopathdev.com/forums/p/4742/18390.aspx#18390

Quite interesting but still no solution. I just want to know what you guys have been saving your InfoPath forms as - what unique name did you use?

I've tried many ways... One of which is using the SharePoint ID.

Once the form has been publish to a SharePoint library, I did a data connection back to the InfoPath form to retreive that SharePoint ID.

And using the function max(@ID) + 1 to generate the new ID number for the next form. Success! Works okay...

Problem: If the owner of the form library decides to change the default view of that form library to another view with filters/sorting etc set on the view - not all form records will be there...

and the function max(@ID) + 1 will only grab the largest ID number within that default view but not the max of the entire form library.

Any ideas on how I could solve this by like some how referencing the GUID of the Form Library instead? OR is there a better way to generate an ID number?

Thanks in advance.