Browser Forms

Re: How to get the ID of the item added to the Sharepoint list

poonam.banthia — Sat, 02 Aug 2008 17:19:35 GMT

Thanks for your inputs Paul. Let me explain you my requirement in details:

I have created an infopath form using which the users create Products and also create some metadata information once the Product has been created. While creating the Products the users provide the Product Name but this is not a primary key as per the business requirements. When the users submit the form I am adding an item in the Products list. Now I need to create a unique identifier for identifying the created product which I thought can be "ProductName_ID" & I can use this later while storing the metadata information abt the product.

Consider the following scenario:

Step 1: Create a product with name "Product1". Once the product is added MOSS autogenerates an ID for the item

Step 2: Again create a product with the same name "Product 1". Another ID is generated for this item.

Now if I create a Receive Data connection how can I get the desired ID for the two products created i.e. I have no means to query the list to get the correct ID.

Pls suggest a way to meet this requirement.

Does the "Submit Data Connection to a Web Service" have any return parameters?

Thanks!!

Re: How to get the ID of the item added to the Sharepoint list

Paul Houtz — Fri, 01 Aug 2008 17:15:37 GMT

Yes, if you want an ID after submit, then you should be good to go. If you need to give the record an ID before submitting the form, then you will have some complex issues. (too complex for me, anyway) I've seen posts on using a SQL table to do that.

My example uses a workflow to set a value in a form library field using the ID and a prefix. It is then displayed in a field on the form by using a seconday data source to recieve data from the list (the field that the workflow set the value of). You could just use the ID itself, but I don't like to show "meaningelss" numbers to end users. Meaningless to everyone but the system itself.

Re: How to get the ID of the item added to the Sharepoint list

poonam.banthia — Wed, 30 Jul 2008 17:15:41 GMT

Hi Paul,

Are u talking about adding a Receive Data connection to the Products Custom List?

Thanks!!

Re: How to get the ID of the item added to the Sharepoint list

Paul Houtz — Thu, 24 Jul 2008 17:15:06 GMT

Add a secondary data source pointing to the list (Manage Data Connections - Create New Connection to receive data) add the ID field to the connection.

Some screen shots are on my blog http://sharepoint2007only.blogspot.com/

Hope that helps!

Re: How to get the ID of the item added to the Sharepoint list

poonam.banthia — Wed, 23 Jul 2008 05:47:36 GMT

Hi Shiva,

Sorry, but I could not understand how can this help me with my issue. I'll try to explain the scenario in a bit more details.

I have a sharepoint list say Products into which items are added from an infopath form. Since the product name is not a unique column, I need something that can be used to uniquely identify an item in the Products list. And hence I think the ID column is the only thing that I can use.

Can you pls explain in detail how to go about this issue?

Thanks!!

Re: How to get the ID of the item added to the Sharepoint list

Shiva — Tue, 22 Jul 2008 06:15:34 GMT

Hello Poonam,

Go through the link once,http://www.infopathdev.com/blogs/agni/archive/2006/06/28/Get-Name-of-Person-Logged-Into-SharePoint.aspx

How to get the ID of the item added to the Sharepoint list

poonam.banthia — Sun, 20 Jul 2008 13:39:59 GMT

I am creating an infopath 2007 browser-enabled form. I am using the standard process to submit the data to a sharepoint list. Each item in list is assigned a unique ID that is stored in the "ID" column of the list. I need to use this value for further operations in my form.

How can I get this value returned after the item is successfully added to the list?

Thanks!!

Poonam