Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a list with a column which consist of user id. there is also a calculated column which has to get the full name from this id. I was able to achieve this by installing custom WSP.
Is there any way to get this Full Name just by entering calculated value in the column(or Out of Box)?

Suppose,if we use 'Created By' field ,the problem is the data displayed under 'created by' field would be LastName,FistName. When use it for email purposes, it will be displayed as domain\username. Instead of this i need to display the name as FirstName,LastName.

share|improve this question
add comment

2 Answers

up vote 3 down vote accepted

Don't think you can do it with a calculated column, but you can use a list workflow to set a text field.

Add a Set Field in Current Item action. Configure the value with User Profiles as data source and select the Name field from source. Then match the Account Name field (only option available) to the column with your User ID (assuming that the user id is the user's logon name).

If you use a Content Type instead of creating columns directly on the list, you can set the full name column as Hidden so that it doesn't show in forms.

share|improve this answer
add comment

The Created By field shows the users Full Name by default. Is there a particular reason why this can't be used?

share|improve this answer
    
Yes,but it shows the name as domainname\username. Instead of that Full name is required. –  Thomas Mathew Jan 18 '12 at 15:15
    
I'm not understanding the requirement as to why you need a calculated column to display data that is already displayed automatically. –  PirateEric Jan 18 '12 at 15:30
    
Sorry if the requirements are not clear. The problem is the data displayed under created field would be LastName,FistName. Suppose we want to use it for email purposes, it will be displayed as domain\username. Instead of this i need to display the name as FirstName,LastName. –  Thomas Mathew Jan 18 '12 at 15:58
1  
If you're wanting to use it in a workflow situation for emails and using SharePoint 2010, you can fetch that data automatically in the workflow. If you're on 2007 then you need to resort to other methods as using a person/group field in a calculated column always returns domain\userid regardless of how the dta is displayed on the screen. –  PirateEric Jan 18 '12 at 16:19
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.