Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Saturday, October 27, 2012 2:33 PM
I have a column 'Student Name' that is typed as Choice. It contains a list of student names. There is a second column 'Student Number' also typed as Choice. It contains a list of numbers. The list containing these columns are already in use. There is also a batch program the reads the value from these fields each night and loads them into another list on another site. Currently the user has to select the name from one column then select the number from another column. It would work better if the user only select from one column containing both the student name and number e.g. 01 MyName. To to this I want to create a new Choice column called 'Student Name and Number '. Then change the existing 'Student Name' and 'Student Number' to Calculate field with a Left and Right + Len formula to get the student name and number into these fields from the Student Name and Number field. The problem is that I cannot change the existing column type of the Student Name and Student Number fields from Choice to Calculated. I tried to just delete the exiting fields and define new calculated fields but with the same names but that seems to break the existing programs that was referencing the exisitng fields. What should I do? Thanks
All replies (4)
Wednesday, October 31, 2012 3:01 AM âś…Answered
Hi,
Sorry for misunderstanding, the Choice type field can't be changed to Calculated field by design. Based on my understanding, you can't achieve this as the columns are being used.
Regards,
Kelly Chen
Saturday, October 27, 2012 3:46 PM
To know about calculated columns refer http://tad.co.in/?p=152
Monday, October 29, 2012 8:27 AM
Hi,
I understand that you want to combine the student name and student number columns, because the two columns are used for programs, then if you deleted them then it will cause issue. Then I think you can create a extra calculate column, add the formula like =[student number]&" "&[student name] .
Regards,
Kelly Chen
Wednesday, October 31, 2012 2:52 AM
Hi Kelly,
Thanks for taking time to reply, but my issue is not with how to use calculated colums. I explained badly. But what I have is exising Choice Type column Student Name and exising Choice Type column Student Number. These are site columns that are part of cotent type. A Program is already referencing these columns. However, I do not the user to have to first select the name and then select the number. So I have already created another Choice Type colume that contains both student name and number. The issue is I want to parse the name and number from the new column I created to populate the exisitng Student Name and Student Number columns. And the easiest way for me to do this is to Change the exisng Student Name and Student Number fileds to Calculated columns so that they can use the Right or Left and Len functions to get the Name and Number from the new columne. I cannot find a way to change the Column type from Choice to Calculated so I deleted the fields and create new ones with the same name (display name) and that breaks the exisiting program that references these fields. My question is there any way around this. Thanks