GlynnGiacone
asked on
Set List Column field to Created By
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
ASKER
What would the syntax be in the Calculated column field to get the 'created by' value? i.e. '= [xxxxxxx]'
Try ["Author"]. The Modified By is ["Editor"] I believe.
http://www.sharepointkings.com/2008/06/sharepoint-column-names-internal-name.html
http://www.sharepointkings.com/2008/06/sharepoint-column-names-internal-name.html
ASKER
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"]
I also get an error when creating a column with the default value set to a calculated vlaue of =[Author] or = ["Author"]
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.
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.
ASKER
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
or, use a workflow to copy the value from one column to the other.