Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

More about InfoPath form data into a Database or Excel spreadsheet

  Asked By: Carlton    Date: Oct 03    Category: Sharepoint    Views: 3567

Took awhile, but I finally managed to create a working form, have it
successfully published to a SharePoint library, and have the approval workflow
in place. Now, the next question. How do I use the data that SharePoint is
creating from the submitted forms??

First, where do I find the data? Second, how do I connect to it?



2 Answers Found

Answer #1    Answered By: Dewayne Clay     Answered On: Oct 03

If the form  is submitting to a SharePoint library, you'll want to
promote/publish the relevant fields in the form template so they show up as
attributes of each form's list item. The alternative is to parse the XML in
the stored form, but that can be pretty ticklish.

How you connect  to it depends on what you want to do with it.

Answer #2    Answered By: Angelina Newman     Answered On: Oct 03

I did publish the fields from the form  and have the library  set up to use
content types ... I do "see" the fields available. I'm just not sure where to go
from there.

I'm figuring I need to set up some views on the library to pull just the data
fields we want and I'm going to need a calculated column, I think, to give me a
running total of the hours.

The form is for professional development. Each form calculates total hours by
adding together travel hours and class hours. What we need to do with the views
is allow users to see their own cumulative professional development hours for
the calendar year and for HR to be able to run reports for individuals,
departments, and divisions.

Hopefully this makes some sense. If you need more detail, let me know.