I've set up a feature on our website which allows members to submit book reviews for the purpose of recommending ones that they've enjoyed to classmates(or maybe warning of bad ones).

I created it as a survey, which works pretty well as far as capturing the information. It uses drop-down lists for category, sub-category, overall rating, etc. and provides a text box for inputting comments. This part works pretty well.

The problem is in the way survey results are reported, since they group results by answer, rather than keeping each members survey answers together. This is obviously the right way to summarize for a normal survey, but it doesn't work well for the purpose I'm using it for.

So I'm wondering if anyone has found a better way to do something like this. Any thoughts would be appreciated.

Thanks.

Don't know if it will be helpful or not but if you export all the results to Excel, put in a row at the top and then do a data filter you can access the info by member.

What a great idea. I think I will "borrow" it, but I'll try it as a forum rather than a survey. We will see how that works.

F C Bock wrote:

Thanks for the suggestion. It's really not too much effort to copy/paste directly from the survey statistics page, which is what I've done so far, but I'll try the Excel approach too.

Venita Cronk wrote:

Please let me know how that works out. Thanks.