0
votes
1answer
38 views

Populate field in a form depending on value on another from database in SP2010

I have a List with three fields, all three text boxes. The first field is an ID, which when populated needs to trigger a DB query to pull corresponding title and description from a table in SQL Server ...
3
votes
1answer
266 views

Extracting browser-compatible InfoPath 2013 form submission data into a SQL Server 2008 Database as well as a SharePoint 2013 list

We are looking at using InfoPath 2013 to capture simple sets of data without the need the need for writing custom applications. However, we still need the information to be stored in a SQL Server 2008 ...
1
vote
0answers
151 views

Using InfoPath inBrowser forms, create reports from captured data, and present those reports back in SharePoint

I'm using SharePoint 2010 and I have access to InfoPath and BCS services. I’m looking to use InfoPath forms that are accessed IN-BROWSER through SharePoint to capture data, and use that data to ...
0
votes
1answer
617 views

InfoPath 2010: Populating drowdown from SQL on load form

I have a data connection to SQL database already set and for the form to query the database on form load. In the dropdown list property I have it pulling from an external data source and in the ...
0
votes
3answers
2k views

Populate Data From SharePoint List to a SQL Table

Is there a way that i can populate a custom share point list into a table in SQL server Database . I have a custom list which i modified it and made it as an info path form and on submit i want that ...
1
vote
1answer
290 views

Use REST to sum a column?

I want to retrieve items from a SharePoint list using REST, and then sum one of the columns. I'm brand new to REST, and didn't see a way to do this on MSDN. Is it possible to sum a column in a REST ...
2
votes
2answers
1k views

Import a SQL Server table into a SharePoint list to use in InfoPath

I need put the SQL table (with over 20000 records) into a SharePoint list, and use it in InfoPath.
1
vote
1answer
737 views

Looking up a value in SQL to set a value on the InfoPath Form

Looking up a value in SQL to set a value on the InfoPath Form. I have a data connection setup in my form. If I use this connection alone, in a control by itself, it pulls in data from my SQL server. ...
4
votes
1answer
2k views

Form for user to input data and submit to run sql command

We're looking for an quick and easy way for an HR person to enter data into a couple fields and then have them click submit and have it execute some SQL Update query on the database. We don't need to ...