Data Connections

Re: Populate a form with default values....

Clay Fox — Tue, 04 Dec 2007 15:53:52 GMT

Hi Kon.

You are in the same boat as you were before with Excel, the SharePoint list does not really make a difference.

You still need a mechanism to extract each row and then submit a form for each, since you want an individual form for each row of data.

You need a tool that will create the basic xml for each file from the data in your list, spread sheet, DB, whatever.

You either need to do this break up or put the data in a database and have one form which can browse through all the records.

Re: Populate a form with default values....

nukkumatti — Tue, 04 Dec 2007 15:45:36 GMT

you should bin a drop down list to the field coming from your sharepoint list as the data coming from there is repeating. you cannot bin repeating infomation to a text box just like this. does this help ?

Populate a form with default values....

konquistador1 — Tue, 04 Dec 2007 15:01:15 GMT

Hi Guys, this is what i have done:

I have imported Data from an Access database into sharepoint by:
1) First Importing the Access table to a Sharepoint List
2) In Infopath i created a new Connection to receive data and
3) Created a text box in Infopath and in the Datasource Option--> default Value , i selected the
field name from the secondary data source.
But here i can only see the first row values prefilled in my Infopath form.
How do i create a Infopath Form(a .xml file) for each row of the table. Please give some ideas.

P.S : How to move data from access to sharepoint.

http://www.sharepointblogs.com/ssa/archive/2007/09/04/importing-ms-access-data-in-infopath.aspx