Can we convert List Type field into Choice Type field?

[Sid_Takali]

Hi all,

I wanted to know is there any to convert to List Type field into Choice Type field? If yes then how? As I'm able to convert it from Reference Type field but in not sure how we do it for List field.

[AndersBGS]

Hi @Sid_Takali ,

No, you can't convert the type of the field. To come with a solution, you can either delete the field from the dictionary table - but please remember, that if you have already some data in this column on the table, this will be deleted as well:

Option 2, is to remove the field from the table, but leave it in the dictionary. Afterwards create a new field of the correct type, and give it the same label. Afterwards you need to transform the data of existing field into the new field value, where after you can delete it from the dictionary not to create in confusion.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders  

[Sid_Takali]

@AndersBGS  On a Reference field dictionary we have an option Choice List Specification. When we select the option Dropdown With-None or Dropdown Without-None and in Attributes field if we add "ref_auto_completer=AJAXReferenceChoice" attribute, the reference field will display as a choice.  Is there any way to make a List field display as a Choice. I have tried this same configuration on List field but it is not displaying as Choice field. List field give an option to select multiple values, I think this can be reason that we can not display List Field as a choice field. @AndersBGS I wants your thoughts on this. 

[AndersBGS]

Hi @Sid_Takali ,

I investigated a little what there could be done to the list type, but from my perspective it was not a pretty solution, but more a choice selection within a list type:

I also found the following KB article, which also refers, that it's highly recommend to not try to change to field type, but rather create a new field and copy data (earlier suggested solution 2): https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0966730

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders