Answered by:
Determine column value based on a choice column

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- Moved by Mike Walsh FIN Wednesday, April 1, 2009 3:29 PM admin q
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- Marked as answer by Xing-Bing Yu - MSFT Thursday, April 9, 2009 1:06 AM
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.aspxWednesday, 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- Marked as answer by Xing-Bing Yu - MSFT Thursday, April 9, 2009 1:06 AM
Friday, April 3, 2009 6:01 AM -
Thursday, March 22, 2012 10:54 AM