.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Submitting Infopath forms to a Sharepoint Library - how can I generate a unique name for each record

Posted By:      Posted Date: October 09, 2010    Points: 0   Category :SharePoint

I have published an Infopath form to a Sharepoint Library. What is the best way to ensure the following:

1. have a name per saved form (I do have a name field which has a set certain amount of available names in it which I am currently using as the form name - coming from an XML file)
2. users can edit already submitted forms without changing the name of the saved form
3. Ensure that users who may create a new form which happens to have more or less the same data as a previously saved form don't end up overwriting the existing one and hence I end up loosing saved data?

Using the name field + allow overwrite will allow me to have a unique name for the form and allow it to be overwritten but if I create a new form with the same name and maybe just a few small differences I will overwrite the existing form which is what I don't want - someone may not realise that an existing form with the relevant information already exists and we could loose already saved information

Any advice would be greatly appreciated.


View Complete Post

More Related Resource Links

Querying InfoPath forms deployed to a Sharepoint Library


Hello all,

We have a form library that stores a form with information for each database we host for our clients. Each database we host has an associated form with information such as:

Database Owner
Application Supported
Backup Location
Security Requirements
And so on...

I was asked to put the form together back a couple months back so we could inventory our databases.

It works, the library now has over 30 forms.

Now I'm being asked to transfer these records from the infopath forms/libray into a database table so we can report from.

I have no clue if I can connect to these forms and pull data from them, do you guys know?

I would like to loop through this library and pull the data from each form into a SQL table, is this doable?

Let me know if you guys can help.

Best regards,
-Igor Santos

Building InfoPath forms against Sharepoint 2010 Data Connection Library and Form Services...


Hi Sharepoint Experrts,

I'm trying to develop InfoPath 2010 forms that use External Lists that have been created in Sharepoint Server 2010.  I have problems when testing the forms because access is denied to the external lists.

When I try deploying the forms to the sharepoint site, I cannot upload the form template because it says I have to be a member of the local administrators group.  However, I'm running the administrator account used to install and setup sharepoint on the Windows 7 development machine I'm using.

I also tried loading the InfoPath Data Connections to a data connection library on my Sharepoint site... I can see the files when I login to the site but when I try creating a New form from a Data Connection File, I get an error message "This location does not contain any data connection files with the appropriate settings".  What ARE the appropriate settings?

I'm just really confused about this because I cannot seem to be able to build forms that use data connection files loaded onto a Sharepoint site or central server....

I appreciate any help I can get!




Thanks, KBW

Programmatically submit Infopath Forms to the Sharepoint Library from client computer


Hello. I have a task to programmatically sumbit/update/delete infopath forms (from .NET console application) to Sharepoint server 2007. The application must work from client computers (without Sharepoint installed). Therefore I've decided to use Sharepoint web services (Lists.asmx), but after some time of investigation I've figured out that I can't work with Forms Library via Lists.asmx service. Please, advice me the most optimal solution. Some choices that I see:

- use some another web service to work with "Forms Library"

- use "List" (instead of "Forms Library") on Sharepoint (am I right, that I can submit/update/delete forms as file attachments? Am I right that this could be achieved with UpdateListItems/AddAttachment methods of Lists service?)

- implement a server and client applications to use Sharepoint Object Model on server side


Please, advice me the right solution. Thank you.

Integrating InfoPath 2010 Forms with the SharePoint 2010 Data Connection Library

Learn how to create a data connection library on SharePoint Server 2010, and create a UDC file in InfoPath Designer 2010 to define a SharePoint List connection.

File Attachments from info-path forms to Sharepoint document library


Hi Experts,

How to upload file attachements from info-path forms to Sharepoint document library?

I need to add attachement from local-PC/Any User to Sharepoint Document Library.


Any help please?? Appreciated




Infopath Brower enabled form not visible in the sharepoint library after being submitted

Hi, I have created a infopath browser enabled form to submit to a sharepoint form library, however the submitted forms are not visible in the sharepoint link structure.   I'm able to see them in the SPD structure.  I'm using infopath 2007 and MOSS. I actually created a SPD workflow which retrieves specific values from the submitted form and saves it to another sharepoint list. This works fine even if the forms are not visible. Appreciate any help. Thanks

InfoPath Form not showing up in Sharepoint Form Library

I have set up a template form setup that users can fill out and then by pressing the submit button sends an email.My current issue is, when I publish the form to sharepoint, I don't see it, I have sharepoint set to view all documents and I still don't see it.  I can get to the form by clicking the "view my form in browser" pop up after I'm done publishing it.  I would like the users to just be able to click on a link in the library, but I can't find where it was published.Any insight on this would be great thanks.

Infopath form and forms library error

I've created an InfoPath 2010 form and associated it with a forms library on a SharePoint site. When I go to the library and choose "Add document" the form opens up to be filled out by the user. When the form is filled out, and the user tries to submit, they get an error saying that I need to configure SharePoint to allow cross-domain data access for user form templates that use connection settings in a data connection file and store a UDC file in the same site collection as the form. So I've enabled cross-domain data access and I've already created a Data Collection Library for Forms in the Site that is approved. What am I missing?  Why am I still getting the error?  

Changing fields while updating an InfoPath Form to a SharePoint 2010 Document library

My document library has following EventReceiver: <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <Receivers ListTemplateId="101"> <Receiver> <Name>EventReceiverDocumentLibraryItemUpdating</Name> <Type>ItemUpdating</Type> <Assembly>$SharePoint.Project.AssemblyFullName$</Assembly> <Class>EventHandling.EventReceiverDocumentLibrary</Class> <SequenceNumber>10000</SequenceNumber> </Receiver> </Receivers> </Elements> Updating a browser enabled InfoPath form in the document library fires following event: Public Overrides Sub ItemUpdated(ByVal properties As SPItemEventProperties) Try Me.EventFiringEnabled = False properties.ListItem("Lastname") = "Testperson" properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = True properties.ListItem.SystemUpdate(False) ' solution 1 properties.ListItem.Update() ' solution 2 properties.ListItem.UpdateOverwriteVersion() ' solution 3 properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = False Me.EventFiringEnabled = True MyBase.ItemUpdated(properties) Catch ex As Exception Me.EventFiringEnabled = True E

Submitting InfoPath data to a SharePoint 2007 List

Clayton, i sure hope you get this.  I would like to let the form get published to the form library and then workflow can create the new list item with all the required metadata mapped.  if data is updated i would like for the list item data to update as well.  currently i have an infopath form that is web-enabled.  i several views based on a status field as which view to open to.  this form have drop-down fields linked to list already on the sharepoint site.  i have tried using the "Submitting Data from Infopath 2007 to Sharepoint List" and it works as designed but unfortunately i cant customize the fields.  i need a dynamic user friendly form with drop downs etc.  any suggestions?

Updating an InfoPath Form Library Template breaks preexisting SharePoint List Views

When updating an InfoPath template (e.g. adding a new field), any views I have created on the library lose their filters and sorting, as if the columns on which they were built no longer exist.  Has anyone else encountered this and, if so, is there a solution? V/r Noelle

Using Workflow to create an InfoPath item in a Forms Library

Hi Experts: Here is my situation: I have a MOSS 2007 server with list A (regular sharepoint list) and List B (InfoPath form library with a published form) This is what I am trying to accomplish using SharePoint Designer: List A is just a basic list User changes a column in list A to a specific value A new form needs to be added to the forms library B SharePoint designer Workflow will not create a valid xml file in the List B forms library. It just creates an invalid file based on the .xsn file template. Does anyone have any experience creating a valid xml form in a forms library using SharePoint Designer workflow? I can't migrate to 2010 so that is not an option. Thanks for all your advise.

Anonymous users submitting Infopath forms via InfoPath Form Web Part

Is there a way for anonymous users in a public facing site to submit InfoPath List Forms via an InfoPath Form Web Part? Currently when I go to a page with the InfoPath Form web part configured as an anonymous users I get the following error message: Error loading the form A form template (.xsn) file cannot be accessed. You may not have the required permissions to open the file The list allows anonymous users permissions to add and view items When logged in the form works fine

InfoPath Forms library in visual studio 2010

If I create a list definition of document library type, and add some new fields to the list.  Is there any way to only allow infopath forms to be submitted to the list?  And also can I change the "add new item" link on the default list to point to my infopath form?

Infopath Form Data submitting to Sharepoint 2010 List

Making a Client intake form that once submitted will send data to  a sharepoint 2010 List called contacts. Short Summary the form will have repeating fields and alot of information to submit. I have looked and read all over but I cannot find an easy step by step guild on how to submit the form data like that. Long Summary on the sharepoint site a button will open a form for adding a new client.  once the form has been filled out and the user hits submit sharepoint will then create a User File, in clients file, and take the data and put it into contacts list. I am trying to make use of Sharepoint as I would with access, meaning the more information I have on a client the easier it will be to mail merge letters, motions, basicly any file prepaired stuff. So once I have css designed forsharepoint to make it look the way I want then the forms should intergrate perfect

Sharepoint 2010 workflow using asp.net forms and or infopath forms

Hi, Does anyone know of any good step by step articles on a state machine workflow with ASP.NET forms and or inforpath forms ? Ive created a blog on a generic workflows but want to learn more about the forms side of things - any pointers would be great. Paul.   PS here is my how to guide : http://sp2010site.blogspot.com/2010/09/how-to-create-and-debug-state-machine.html  

Creating report from Infopath library/submitted forms

Hi, I got a form that has repeating table containg data. The form is submitted to a form library on MOSS 2007 site. Some of the key fields from the form has been promoted to the library, which allows creating views and gives the user a quick report based on the filter. Now, the user wants similar function, however the data is stored in the repeating table. I can use double eval function to combine data from each columns and promote them to the library. But obviously, it doesn't give the user accurate/the kind of report he is looking for using the views. Do you have any suggestion? The only option I can think of is storing each row from repeating table into an Access database or sharepoint list. But that'll also involve making sure correct data is being updated in these secondary data source when updating the form.  Pman http://www.pmansLab.com/
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend