none
how to use formula in the List's title coloumn RRS feed

  • Question

  • my list has a default coloumn with name as Title, and two more coloumns firstname and lastname.

    i want to set Title to a formula so that it appends firstname + " " + lastname.

    how do i do it?

    Friday, June 3, 2011 12:41 PM

Answers

  • ok you need to do the following as you cannot achieve what you want by default.

    1. Change the title column to not be a required field
    2. In advanced settings in the list/library settings, choose to Allow Management of Content Types
    3. Now go into the content type and hide the column title, so that when you add a new item, you only add the first name and last name

    Ok your set now to use SharePoint Designer to create a very simple workflow to do what you need.

    1. launch sharepoint designer and create a new workflow working on the list in question
    2. Set the workflow to start when an item is created or edited
    3. Set the workflow to have NO conditions and the ACTION to be set field in current item
    4. Set FIELD to be the Title field
    5. Set VALUE to be the concatenation of the first name and last name, do this by clicking the ... icon (Display Builder for the parameters) and then adding in the fields you require.

    Now when you add an item, you will only be presented with the option to add a first name and last name, when you save a workflow will run and you will now have a title field which is first name and last name.

    • Proposed as answer by Sergio Giusti 79 Friday, June 3, 2011 12:55 PM
    • Unproposed as answer by Clayton Cobb Saturday, June 4, 2011 5:02 AM
    • Proposed as answer by Clayton Cobb Saturday, June 4, 2011 5:03 AM
    • Unproposed as answer by Nachiket Kamat Saturday, June 4, 2011 5:40 AM
    • Proposed as answer by Clayton Cobb Saturday, June 4, 2011 4:06 PM
    • Marked as answer by Nachiket Kamat Monday, June 6, 2011 4:45 AM
    Friday, June 3, 2011 12:55 PM
  • No. That's what calculated column is used for. This ref is 2007 but there may be an equivalent for 2010:
    http://office.microsoft.com/en-us/windows-sharepoint-services-help/introduction-to-data-calculations-HA010121588.aspx
    Quote: "You cannot reference another column in a formula that creates a default value for a column."
    AK

    Thursday, June 9, 2011 1:44 PM

All replies

  • you can't apply forumla to tile column. It's a SHP build in column

    Better it's to create your own column, calculated based on [firstname]&" '&[lastname]

    If you don't 'like' title column, you can hide this column


    romeo donca
    Friday, June 3, 2011 12:53 PM
  • ok you need to do the following as you cannot achieve what you want by default.

    1. Change the title column to not be a required field
    2. In advanced settings in the list/library settings, choose to Allow Management of Content Types
    3. Now go into the content type and hide the column title, so that when you add a new item, you only add the first name and last name

    Ok your set now to use SharePoint Designer to create a very simple workflow to do what you need.

    1. launch sharepoint designer and create a new workflow working on the list in question
    2. Set the workflow to start when an item is created or edited
    3. Set the workflow to have NO conditions and the ACTION to be set field in current item
    4. Set FIELD to be the Title field
    5. Set VALUE to be the concatenation of the first name and last name, do this by clicking the ... icon (Display Builder for the parameters) and then adding in the fields you require.

    Now when you add an item, you will only be presented with the option to add a first name and last name, when you save a workflow will run and you will now have a title field which is first name and last name.

    • Proposed as answer by Sergio Giusti 79 Friday, June 3, 2011 12:55 PM
    • Unproposed as answer by Clayton Cobb Saturday, June 4, 2011 5:02 AM
    • Proposed as answer by Clayton Cobb Saturday, June 4, 2011 5:03 AM
    • Unproposed as answer by Nachiket Kamat Saturday, June 4, 2011 5:40 AM
    • Proposed as answer by Clayton Cobb Saturday, June 4, 2011 4:06 PM
    • Marked as answer by Nachiket Kamat Monday, June 6, 2011 4:45 AM
    Friday, June 3, 2011 12:55 PM
  • ok you need to do the following as you cannot achieve what you want by default.

    1. Change the title column to not be a required field
    2. In advanced settings in the list/library settings, choose to Allow Management of Content Types
    3. Now go into the content type and hide the column title, so that when you add a new item, you only add the first name and last name

    Ok your set now to use SharePoint Designer to create a very simple workflow to do what you need.

    1. launch sharepoint designer and create a new workflow working on the list in question
    2. Set the workflow to start when an item is created or edited
    3. Set the workflow to have NO conditions and the ACTION to be set field in current item
    4. Set FIELD to be the Title field
    5. Set VALUE to be the concatenation of the first name and last name, do this by clicking the ... icon (Display Builder for the parameters) and then adding in the fields you require.

    Now when you add an item, you will only be presented with the option to add a first name and last name, when you save a workflow will run and you will now have a title field which is first name and last name.

    there is some thing like formula when u edit properties of TITLE field..what is that?
    Saturday, June 4, 2011 5:00 AM
  • Use a workflow that sets the Title to the dynamic string of "FirstName LastName".
    SharePoint Architect || Microsoft MVP || My Blog
    Planet Technologies || SharePoint Task Force
    Saturday, June 4, 2011 5:02 AM
  • "there is some thing like formula when u edit properties of TITLE field..what is that?"

    What does this question mean??


    SharePoint Architect || Microsoft MVP || My Blog
    Planet Technologies || SharePoint Task Force
    Saturday, June 4, 2011 5:03 AM
  • "there is some thing like formula when u edit properties of TITLE field..what is that?"

    What does this question mean??


    SharePoint Architect || Microsoft MVP || My Blog
    Planet Technologies || SharePoint Task Force
    sorry i got it wrong.. there is a calculated value field inside Properties of Title..maybe we can set some formula into this ?

    Saturday, June 4, 2011 5:51 AM
  • how to use CALCULATED VALUE property of List's TITLE (column) field?
    • Changed type Nachiket Kamat Saturday, June 4, 2011 10:13 AM
    • Edited by Clayton Cobb Saturday, June 4, 2011 4:05 PM Fixed misspelling of column
    • Merged by Clayton Cobb Saturday, June 4, 2011 4:06 PM Created another thread on the same topic for some reason
    Saturday, June 4, 2011 9:34 AM
  • What do you want to do exactly with calculated field, please provide more details ..
    Mai Omar | Senior Solutions Developer | ITEgyptCorp | MCP, MCTS, MCPD, MCITP & MCT Microsoft Certified Trainer | Email: mai_omar_86@live.com | Blog: http://maiomar.itegyptcorp.com
    Saturday, June 4, 2011 12:42 PM
  • Where is there a calculated value field inside the properties of Title?  The Title field has no properties when you click on it.
    SharePoint Architect || Microsoft MVP || My Blog
    Planet Technologies || SharePoint Task Force
    Saturday, June 4, 2011 3:53 PM
  • Why did you make another thread on this same topic, and why are you not explaining exactly what you're talking about?  The Title field has no properties to set for calculation.  If you are talking about something else deep in the XML, then please explain exactly what you're talking about.  Also, people have given you an answer, and you've dismissed it completely.  That is not how to use the forums.  YOu ask tons of questions as if you think you deserve to be given free answers to everything you don't know how to do, but that is not how this forum works.  People are spending their FREE time giving you FREE support so you can go make money with your clients, yet you dismiss responses as if people didn't even reply.

    Do not continue to behave like that.


    SharePoint Architect || Microsoft MVP || My Blog
    Planet Technologies || SharePoint Task Force
    Saturday, June 4, 2011 4:08 PM
  • Why did you make another thread on this same topic, and why are you not explaining exactly what you're talking about?  The Title field has no properties to set for calculation.  If you are talking about something else deep in the XML, then please explain exactly what you're talking about.  Also, people have given you an answer, and you've dismissed it completely.  That is not how to use the forums.  YOu ask tons of questions as if you think you deserve to be given free answers to everything you don't know how to do, but that is not how this forum works.  People are spending their FREE time giving you FREE support so you can go make money with your clients, yet you dismiss responses as if people didn't even reply.

    Do not continue to behave like that.


    SharePoint Architect || Microsoft MVP || My Blog
    Planet Technologies || SharePoint Task Force

    i have dismissed it as i did not wwant to create a workflow.. this is because when i look into the properties if the TITLE field, i can see a radio button for CALCULATED VALUE.. if the answer is as simple as that, then i wouldnt like to create a workflow.. and if there is no other way out, then i will use a workflow..

    ok my mistake..sorry. but can u tell me what is that calculated field usede for?

    i am pasting the image link so that u can have a look:-

    http://tinypic.com/r/2qxojzk/7

    ----------------------------------------------------------------------------

    Why did you make another thread on this same topic,

    in my 2nd topic, i askd specifically about the TITLE property(calculated field).


    why are you not explaining exactly what you're talking about? 

    iv tried my best to explain.

    The Title field has no properties to set for calculation. If you are talking about something else deep in the XML, then please explain exactly what you're talking about.

    title field properties does have a calculated value textbox..please have a look at that.

    Also, people have given you an answer, and you've dismissed it completely.

    i did not dismiss it, u r taking things in a very negative manner, its just that it was another way around.That is not how to use the forums.  YOu ask tons of questions as if you think you deserve to be given free answers to everything you don't know how to do, but that is not how this forum works.  People are spending their FREE time giving you FREE support so you can go make money with your clients, yet you dismiss responses as if people didn't even reply.

    ok it was an anaswer .. my mistake . 



    Monday, June 6, 2011 4:40 AM
  • what is the purpose of Calculated value under properties of TITLE field of any LIST?
         
    • Merged by Clayton Cobb Friday, June 10, 2011 5:16 AM Asked the same question YET AGAIN with different wording
    Thursday, June 9, 2011 12:34 PM
  • if you mean the column properties of the Title, default value: text or calculated value, you could set a default value in case you want it set according to some business rule or if an automated process creates list items (ex. order no - current date).
    AK
    Thursday, June 9, 2011 1:14 PM
  • if you mean the column properties of the Title, default value: text or calculated value, you could set a default value in case you want it set according to some business rule or if an automated process creates list items (ex. order no - current date).
    AK

    suppose if my list's custom new form has input boxes to enter 2 values,

    value1= 5

    value2=10

    can i use the calculated value property on title and say =value1+value2?

    Thursday, June 9, 2011 1:17 PM
  • No. That's what calculated column is used for. This ref is 2007 but there may be an equivalent for 2010:
    http://office.microsoft.com/en-us/windows-sharepoint-services-help/introduction-to-data-calculations-HA010121588.aspx
    Quote: "You cannot reference another column in a formula that creates a default value for a column."
    AK

    Thursday, June 9, 2011 1:44 PM
  • No. That's what calculated column is used for. This ref is 2007 but there may be an equivalent for 2010:
    http://office.microsoft.com/en-us/windows-sharepoint-services-help/introduction-to-data-calculations-HA010121588.aspx
    Quote: "You cannot reference another column in a formula that creates a default value for a column."
    AK

    thanks abed
    Friday, June 10, 2011 6:32 AM