Wednesday, May 07, 2014

Adding views or list columns to a SharePoint Survey

The following action plan allows extending the SharePoint survey template as a quiz or any combination of a survey and a regular list.

When you create a Survey in SharePoint 2010, you are pretty much limited to the questions you added and several available survey views. In the survey's List Settings you can't add views or list columns as in other lists.
However, the standard List Settings page is also available, though hidden from a direct access.

Click this link for an example of how to construct the link and create a desired new view.
The same way you can add columns. Just concatenate the sub-site address with the create column page and the survey list ID to be able to add columns. 
http://mySiteURL/mySubsite/_layouts/fldNew.aspx?List=%7B3DB4059C%2D03F1%2D4A0C%2DAEF1%2DFBF5369E3473%7D

The same reasoning you can apply to other maintenance pages like edit page.

Why would you need to add columns?
Consider the case where you used the survey as a quiz, and would like to notify the user that he or she failed the test because of 3 or more wrong answers.
For this, you just need to create a calculated column that counts the # of wrong answers which will trigger an SPD workflow based on the count.
Alternately, create a filtered view and subscribe the item creator.
  

2 comments:

  1. Hi there! glad to drop by your page and found these very interesting and informative stuff. Thanks for sharing, keep it up!

    ReplyDelete
  2. You can record the Excel macro or you can type the Excel VBA that makes the macro. Recording Excel macros is the easiest way to start automating your files.excel dashboard software

    ReplyDelete

Enter your comment here