I have a list (Account Exec Distribution List) in SharePoint 2007 that provides the Client Name and the associated Account Exec (AE). The AE team would like to complete a survey of sorts that will provide senior management with a feel for the health of each account. This survey of sorts will be either monthly or quarterly. I have considered using the Survey in SharePoint but there doesn't seem to be an easy way to create hundreds of surveys (one for each client) by Account Exec and getting them to automatically generate every month/quarter. I've also considered creating a list/spreadsheet that the AE could complete. However, I also need some way to track progress. Does anyone know of an efficient way to create tasks from data in a list or imported spreadsheet (Account Exec Distribution Report)? I'm also interested in any thoughts regarding a good approach for collecting the answers to 5-6 questions that ultimately will guage the health of a client account. I can utilize SPD or OOTB SharePoint to accomplish this.
The very, very easiest approch I see would be like this:
- You create a new document library called "AE Surveys"
- You might to enable versioning, depending on your needs
- You create a new content type called "AE Survey"
- You add a column "AE name" to the library (maybe a dropdown)
- You add a column "Month" and "Year" to the library
You create a view that is grouped by "AE name" and then grouped by "Year". Sorted by Month.
You attach a new document tempate (I suggest Excel) to that content type, which looks like this:
..................Question 1......Question 2...... Question n.....
When a AE comes to that document library the first time, he clicks "New" to add a new survey. He will then have to enter his accounts to the "Account" column in Excel (replacing the "Account 1", "Account 2", "Account n" with actual Account names). He will then answer the questions and save the documents with proper metadata (AE name, Year, Month). The next time he has to do the survey he OPEN THE EXISTING one and just updates the answer to the question as well as the metadata (Month and Year only).