I have a SharePoint 2010 Form Library that will have multiple documents. I have one form that will be feeding/creating each of these documents.
Essentially, I need to have one document per each office for our company. Each office will fill in the forms and submit them. Most of the data is for a checklist of items to complete. Each item will have a modified and modifiedby field with a home office chcek bod to confirm, also with mod/modby fields.
I'm going to need to be able to run reports off of the data that is stored in these individual XML files. I have yet to find a definitive answer through Lord Google... Hopefully someone here will have the answer!
Matt Lansing, MI
Thanks very much for both answers!
I’d like to give a little more detail into why I was choosing to use a Form Library instead of a SP list…
The requirements for this project is to have approximately 70 check boxes as a readiness process for cutting over to a new software system. Each check box needs to have 5 pieces of extra data associated to each. A Modified, ModifiedBy for the check box and another checkbox to show that Home Office confirmed this with a Modified, ModifiedBy associated to it.
Potentially I would have 420 items of data per office. We have over 200 offices.
I’m trying to figure out the best way to have this data collected while being able to run reports on who has completed what portion of their form.
By default, a list will have a modified and modifiedby columns for the entire form. I need it for each line item. I figure that using the Form Library, I can force each office to have its own file with the office number as the file name.
Can you think of a better way to accomplish this?
I appreciate any assistance any of you can give! Thanks!