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

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

Best way to get anonymous InfoPath data into multiple lists/libraries?

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

I'm trying to figure out the best way to create a solution for the situation I have.  I'm still pretty new to SharePoint, and very new to InfoPath.  I'm working with MOSS 2007 and I've created a browser-enabled InfoPath 2007 form that I need to make available to both anonymous users at the top level of my site, and AD authenticated users from within a secured site collection.  It will be important for me to be able to determine whether the form is being submitted by an anonymous or authenticated user, as it will have some fields that need to be handled differently in each case.  Once the forms are submitted, I need to be able to store them in a forms library in the secured site collection, and also create a list item in the top level site with some of the basic info from the form.  That list will be visible and searchable for the anonymous users.

After searching through this forum, I've found at least 2 possible ways for anonymous users to submit forms to a form library.  Right now I'm leaning towards having it submit to a web service which would handle the task of moving/copying the data to the proper places.  Would that be the best solution in this case, or am I missing something?

The next thing I'm not sure about is what my options are for presenting the form 

View Complete Post

More Related Resource Links

External Lists and Infopath forms issue with Secondary Data Sources

I've followed this tutorial for creating and customising forms for external data (http://blogs.msdn.com/infopath/archive/2010/03/11/customize-an-external-list-form-in-infopath-2010.aspx).  The only difference being that my seconday data source is not an XML file (I've tried database connection and existing sharepoint lists both internal and external) When running the design checker I get the message "Additional Data connections not supported" and my form won't publish.  Any ideas?

InfoPath 2010, Multiple Repeating Sections have same name, Diff data connections using same SQL Serv

I've created an InfoPath 2010 form that has three Repeating sections and each one uses a different data connection but all three connections use the same table in SQL Server... "Accounts".  Now you might ask why I would do this? Well I need different sets of data in each section and it all resides in the same table in the repository. Also, sometimes one section will not have information and I do not want a bunch of blank fields displaying in the repeating section. So I split the data into separate sections. Now here is the challenge for you guru's out there. :) I want to use one column in the 3rd repeating section  to refer back to another column in the first repeating section.(for referential integrity) Unfortunately since they both use the same table in the database they possess the same name under advanced view:  myFields/dataFields "d_:Accounts". In fact all three of my repeating sections have the same name based upon the database table used in the data connection. In the SQL statement I attempted to rename each of the connections via the statement. I have not tried to give the table an alias in the statement yet. Will try that one next. 1. Is there a simple way to rename the repeating Section from "d_:Accounts" to something else so that  they are each unique? (Without using backend code as I've only used InfoPath/SP/S

fx Controls instead of Drop Down Lists for Lookup fields in InfoPath Secondary Data Connections


I have a secondary data connection with a lookup field into another list. To display the fields text value instead of the index, I am using a drop down list which gets its choices from the linked list. This information is read-only so I disabled the control via formatting rule.

A calculated value control might be better suited, but my XPath skills are not very "developed". Has anyone done this before? Taken the index from the bound field and extracted the text value from a second data connection? Thx


Show filtered data from multiple data lists in a view


I am attempting to build a very simple Sharepoint site with 3 data lists: 1) Themes,  2) Value Statements, 3) Supporting Details

Each Theme has 2+ Value Statements and each Value Statement has 2+ Supporting Details. 

Currently, I have the Forms setup so that when I enter a new Supporting Detail, the individual must select from the avaialable Value Statements (using a Lookup Column). 

What I would like to do, now, is allow an individual who is looking at a view of all the Value Statements to see the Title field of all the Supporting Details that have been entered for that particular Value Statement (with hyperlinks).

I'm guessing that I need to use SharePoint Designer 2010 to customize the view, but am not certain how to do it from there.


InfoPath: Copying values from a multiple-selection lookup (secondary data connection) to a multiple-

Trying to use "Set Field Value" action in InfoPath to set values in a multiple selection lookup field. Does not not seem to be possible. Has anyone achieved this?

Is a Site that contains multiple Lists where the list should be able to create an InfoPath Form(form


I guess what I'm asking is, is this possible?

I have a System that I'm trying to implement in SharePoint. It basically is a Site that contains multiple Lists. The list should be able to create an InfoPath Form(form1). Then I need to create multiple InfoPath forms(form2) that is basically a sub-form of form1. Form2 will have its own List containing only form2's that relate to form1. Then create sub-form(form3) to form2.

Using a combination of InfoPath and SharePoint is this possible?

Query data from multiple calander in InfoPath button click


Hi, I am building event booking system on InfoPath 2010 , I need to show available rooms for given start and end date time.

All calendars library are under same site.

I don’t want to use code behind. I have calendar lib for each room defined.









data from multiple row



I have a dataset in my SSRS report where I am getting the data like this. It has 3 rows.

ID Parameter Value

1. Client Name-  XYZ

2. Client Email - xyz@s.com

3. Clinet Phone- 234567

I need to check condition in expression, so If parameter is Client name then It will show in client name textbox of Report. How can write expression for this.

Zip Your Data: Using the Zip Classes in the J# Class Libraries to Compress Files and Data with C#


Zip compression lets you save space and network bandwidth when storing files or sending them over the wire. In addition, you don't lose the directory structure of folders you Zip, which makes it a pretty useful compression scheme. The C# language doesn't have any classes that let you manipulate Zip files, but since .NET-targeted languages can share class implementations, and J# exposes classes in the java.util.zip namespace, you can get to those classes in your C# code. This article explains how to use the Microsoft J# class libraries to create an application in C# that compresses and decompresses Zip files. It also shows other unique parts of the J# runtime you can use from any .NET-compliant language to save some coding.

Ianier Munoz

MSDN Magazine June 2003

Updating Task Lists and Form Libraries From Workflow Form


There are actually two separate (I think) problems here. The scenario: I used the SharePoint Designer 2007 to create a workflow attached to a form library. When a form is submitted to the library, a To-Do-Item is created on a task list. The To-Do-Item is initially assigned to a GROUP. A user from the group then selects the name of an individual from a choice list in edit item. This person now becomes the Assigned To for the task.

What is needed is 1) To update the Assigned To column of the Form library when someone in the GROUP assigns the task to an INDIVIDUAL; and 2) To have the Due Date from the submitted InfoPath form propagate to the task list.

I've tried having one workflow try to do everything and also having a secondary workflow set up on the task list to do the task assignment update but have not been successful in solving either issue. I don’t think that I am really understanding how to Define Workflow Lookup when not working with the Current Item. I know what fields I want but I don’

Infopath resets all data on a web from when submitting via the MAC



I'm seeing some very strange behaviour with some browser based Infopath forms.  The user is trying to fill the infopath form using safari on the Mac and when the user hits the submit button the form reset itself.

An other behaviour is that when the user click on a form field all the form fields will automatically populate one value.  This happen intermittently.

We have two load balancing web front ends. Server1 and Server2 the users that a reporting this problem get served by Server1 when I test on my Mac to replicate the problem the request get served by Server2. This problem occurs on different forms across the sharepoint implementation.

Can anybody shed any light on the problem?




Combining data from 2 lists, then summing a field


I have 2 lists, one is a contact list (client, client title, address, etc.), the other is a list of meetings with these clients (client name, type of meeting, date, etc.).  The 2nd list has multiple entries for the same client.  I am trying to create a report that combines the data in these lists and displays them like this:

Client--Client Title--MeetingType1--MeetingType2




In addition to combining the list data, I also need to break up the Type of Meeting field and sum the number of different types of meetings for each client.  I added the 2 lists to a linked source, then inserted the data into a DVWP adding data from the 2nd list as a joined subview.


I tried this: xsl:value-of select="count(/dsQueryResponse/Rows/Row[@TypeOfMeeting = 'MeetingType1'])" but it just returns 0.  I'm not sure if that's the correct method though as I think it will return a count of ALL the rows, not the current row.  Any ideas would be appreciated!

wss2.0 Infopath 2007 'This form requires connections to data sources when it is loaded. At least on


Hi all

I have a user who receives the error 'This form requires connections to data sources when it is loaded. At least one of these connections is not available. As specified by the form designer, this form will not open' when trying to Submit an infopath form located on a WSS2.0 site.

The user has been having this issue since upgrading to Office 2007 and IE7. I have had the user run an Office Diagnostics but this has not resolved the issue.

I am not aware of any other users experiencing this issue.

Any ideas please?

How do you create a custom BDC data field that allows for multiple selected values?

I need help creating a custom data field using the BDC column as a base.  We need to allow for multiple selected values instead of just a single one.  I can't find anything on the net which shows how to do this.

Quick Note: Accessing Multiple SharePoint 2010 Lists by Using LINQ

In this exercise, you develop and deploy a visual Web Part that reads data from three lists by using LINQ queries and displays the results in a grid view control.

Creating .NET Assemblies That Aggregate Data from Multiple External Systems for Business Connectivit

This article describes a quick, four-step process for creating a .NET assembly that BCS can use to retrieve external data for SharePoint Server 2010 by using Visual Studio 2010.

Video: Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists

Learn how to use the Open XML SDK 2.0 to create Excel 2007 PivotTables that are connected to data stored in SharePoint lists.
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