Newbie Questions

Re: Unique ID Generation

Hilary Stoupa — Mon, 09 Apr 2012 16:07:08 GMT

Yup, we are referring to an ID in the SharePoint library the document would be submitting to - I hadn't realized that your form would be moving around. I can't think of a way you can do this inside your form with no dependency on secondary data of some kind - you need to know what numbers have been used, after all. I suppose you could leverage a SharePoint list for this, and use a CAML query to submit each id to the list as used.

Re: Unique ID Generation

Daniel Clarke — Mon, 09 Apr 2012 15:49:53 GMT

Patrick, thanks, I will have a look at that to see if it helps.

Hilary are you guys refering to the ID field in a SharePoint List? If so I would really like to avoid this as the form will be copied and moved to another list which will replace the ID from the original list anyway so this wont work. I would really like to find a way to create this unique ID inside of Infopath so I can use that as the saved document name in SharePoint without it changing as the form gets moved around between SharePoint lists.

Thanks for any additional help

-Daniel

Re: Unique ID Generation

Hilary Stoupa — Mon, 09 Apr 2012 15:38:33 GMT

As Anson mentioned, an option is to query the library you will be submitting to, and then use a formula to get the max ID from that list and add a one to it. Please do this right before submitting so you don't end up with multiple forms with the same ID number.

Re: Unique ID Generation

Patrick Halstead — Mon, 09 Apr 2012 13:55:39 GMT

Have you read Kaoru's blog: http://www.infopathdev.com/blogs/kaoruo/archive/2011/08/26/use-qrules-to-create-unique-form-names.aspx ?

Re: Unique ID Generation

Daniel Clarke — Mon, 09 Apr 2012 13:26:15 GMT

Bump...Anyone?

Re: Unique ID Generation

Daniel Clarke — Thu, 05 Apr 2012 18:34:01 GMT

Thanks for your response, but is there a way to do this directly from Infopath 2007 without having to use third party products or changing anything on the sharepoint list? I would like to use just the native Infopath 2007 software to complete this if possible.

Thanks

-Daniel

Re: Unique ID Generation

Anson Hidajat — Thu, 05 Apr 2012 18:18:37 GMT

You could generate a GUID using qRules and use that as your ID. Another method could be to take the max(ID) + 1 on the current IDs of the list.

Unique ID Generation

Daniel Clarke — Thu, 05 Apr 2012 15:11:41 GMT

Hey All,

Hopefully this is an easy one. What is the best way to create a unique ID for a form that is being submitted to SharePoint 2007?

Just to clarify I would like Infopath to be creating the Unique ID and not SharePoint. I use Infopath 2007

Thanks in advance

-Daniel