We help IT Professionals succeed at work.

Set List Column field to Created By

GlynnGiacone
GlynnGiacone asked
on
I need to create a column in a list and have it's content set to the same value in the automaticallty set "Created By"  column
Comment
Watch Question

Top Expert 2010

Commented:
created a calculated column that does this.
or, use a workflow to copy the value from one column to the other.

Author

Commented:
What would the syntax be in the Calculated column field to get the 'created by' value? i.e. '= [xxxxxxx]'

Commented:
Try ["Author"]. The Modified By is ["Editor"] I believe.
http://www.sharepointkings.com/2008/06/sharepoint-column-names-internal-name.html 

Author

Commented:
I get an error when creating a column with the calculated look up of =[Author] or = ["Author"]
I also get an error when creating a column with the default value set to a calculated vlaue of  =[Author] or = ["Author"]
Top Expert 2010

Commented:
why not use [ME] ?
the person who creates the item is [ME] and is also the Created By person...  

the thing to test / watch out for is when the item is edited, the value in that calculated column may get updated to the Edited By person.

the other way to do this is with Sharepoint Designer, create a workflow that copies the value in the Created By field to the other column.

Author

Commented:
I tried using [Me] but that gives the logon id in the form of domain\user.

My client is looking for the same user information (last name, first name) from Created By but without the use of a workflow, to be the default in a column, i.e. Employee Name.

Is there a system field similar to [Me] that gives the user name and can be referenced in a calculated column or set as a calculated value in a text column?
Top Expert 2010
Commented:
nope.

your other option would be a lookup field.  but that requires the user to select the name.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.