locked
Determine column value based on a choice column RRS feed

  • Question

  • Hello,
    What I want sounds simple in practice, but I can't find any way to do it in the out of the box performance of SharePoint.
    All I want is to be able to chance a single line of text column value to a specific text based on what a user chooses in a choice drop down column.

    Is there any way to do this?  I'm able to create web parts, but I don't know how to create an actual new column type aside from the Create option in SharePoint under Galleries-->Columns.

    I thought about using Calculated Value as the column data type, but as far as I can tell all that allows you to do is mathematical calculations and string manipulations.

    Thanks in advance for any help
    May your code never smell
    Wednesday, April 1, 2009 2:30 PM

Answers

  • Hello,

     

    I understand your requirement as that you want let your single line of text column to change its value according to changing of another choice drop down column. If I’ve misunderstood you, please let me know.

     

    Then, a custom workflow created in Sharepoint Designer can help you. The clue of create such a workflow is as follows:

     

    1.       Make the workflow triggered by item changing event.

    2.       Create the action to be like update current item to make current item’s single line text column value= choice drop down column value.

     

    You can refer to following link to get detailed information about how to create custom workflow in SharePoint Designer:

     

    http://office.microsoft.com/en-us/sharepointdesigner/CH100667661033.aspx

     

    Regards,

    Jerry


    Xing-Bing Yu
    Friday, April 3, 2009 6:01 AM

All replies

  • Moving to Admin.

    Not a programming question of the kind covered in Dev/Programming.

    WSS FAQ sites: WSS 2.0: http://wssv2faq.mindsharp.com WSS 3.0 and MOSS 2007: http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 and MOSS 2007 Books (including foreign language titles) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx
    Wednesday, April 1, 2009 3:29 PM
  • Hello,

     

    I understand your requirement as that you want let your single line of text column to change its value according to changing of another choice drop down column. If I’ve misunderstood you, please let me know.

     

    Then, a custom workflow created in Sharepoint Designer can help you. The clue of create such a workflow is as follows:

     

    1.       Make the workflow triggered by item changing event.

    2.       Create the action to be like update current item to make current item’s single line text column value= choice drop down column value.

     

    You can refer to following link to get detailed information about how to create custom workflow in SharePoint Designer:

     

    http://office.microsoft.com/en-us/sharepointdesigner/CH100667661033.aspx

     

    Regards,

    Jerry


    Xing-Bing Yu
    Friday, April 3, 2009 6:01 AM
  • Hi JasonFr,

    Did you find a solution to your problem please.

    Bes Regards,

    Avatar of JasonFr

    ,

    Thursday, March 22, 2012 10:54 AM