Wednesday, September 9, 2009

Customizing "Created By" column in Survey lists

Well, I had'to modify the display of a column in a Survey, where it was required to get the email ID displayed instead of the User's name.
By default, you cannot edit the “Created by” in the question lists. But there's a workaround for you to edit this column as per the below steps:

1. Open your survey, click "Survey Settings" (You will need the Admin rights for this).
2. In the Questions section, click any question of your survey;
3. Change the URL parameter in the Browser:
set Field=Author,
Change the aspx page to FldEditEx.aspx
4. The URL should resemble something like this:
http://yourserver/_layouts/FldEditEx.aspx?List=yourlistGUID&Field=Author
(replace "yourserver" and "yourlistGUID" accordingly)

After this you can select the field you want to display in “Created by”, which can be anything from the dropdown list:
- email
- ID
- Firsname
- Lastname, etc.

Things to remember:
- Page to use: "FldEditEx.aspx"
- Use the respective Internal column names for the columns to modify:
[Created By] = “Author”
[Modified] = “Editor”
[View Response] = "DisplayResponseNoMenu"

Interesting !!! kind of hacking the SharePoint.