Newbie Questions

Re: Multiple users submitting 1 form to SharePoint for status report

Hilary Stoupa — Tue, 04 Aug 2009 15:04:32 GMT

If your status report form saves its data to a database, like SQL or Access, you can use Excel to report on that data (thus, compile all the data in a single sheet). You can either base your form off a database or use a web service to submit to a database.

Re: Multiple users submitting 1 form to SharePoint for status report

brobins75 — Tue, 04 Aug 2009 12:41:33 GMT

I hope you get an answer soon. I am trying to do the exact same thing. i am a newb.

my boss is expecting this. I too manually enter all the data and spit out a final status report. i dont think the supervisors can access forms simultaneously, but it would be nice. that would solve half the battle.

the only solution i have found, however i have not fully tested or finished, is to map to excel and manual export to excel, to a separate worksheet for each supervisor, then sum all sheets to spit out the chart/report. i might as well continue to manually enter the data!

please help!!!

Multiple users submitting 1 form to SharePoint for status report

macronerd — Fri, 24 Jul 2009 07:30:50 GMT

I have an Excel form that multiple users fill out daily as a status report and email to me. I gather all of the submitted forms and manuall enter the submitted data in a new Excel spreadsheet which serves as the final report of everyone's status. I obviously need to automate this process. What I would like is to have 1 central location or URL for the form and multiple users should be able to access it simultaneously and submit their status. The submitted data should show up in a status report in SharePoint. I can't seem to do this with a custom list in SharePoint because the Excel form is too complex. How can I do this with InfoPath? Any other suggestions?