change multi text to list collection or multi choice servicenow

[_William_Knight]

I have a field on my record producer that is a multi text field. I did like to change this field to a multiple choice field where I can select more than one answer as a choice or a list collector which will also allow me to select multiple options 

How if possible can I convert this multi text field to a multiple choice field 

Thank you all

[Shubham Singh]

Hi @_William_Knight 

Create a label type variable to show the label of your multiple choice question and then create checkbox type variables for each choice. It will fulfil your requirement.

Example, if you have 3 choices, then you have to create 4 variables.

• 1 for the label
• 3 variables of checkbox type for each of 3 choices.

Thanks!

Please mark this response as correct and helpful if it works 👍✔️

[AshishKM]

Hi @_William_Knight ,

Yes, you can convert multi text to multi choice ( or list collector ).

I would suggest to create new variable for this multi choice ( or list collector ) and disable the existing multi text field. 

-Thanks,

AshishKMishra

[_William_Knight]

If I select list collector, then I have to select a list table

But the choices are new and is not currently associated with any table? This is where I am getting stuck

Please guide

[AshishKM · Accepted solution]

Hi @_William_Knight ,

You can use OOTB Choice table [ sys_table ], insert all new entry in sys_choice table and add this table this List Collector.  The record producer must creating records in main table where this multi choice values are being used. So you can create these new value on the same table with field name. 

Map the table and add the ref value to display only valid/matched record. You can filter these new values on sys_choice table in LIST VIEW and "Copy query" and past it here in Reference qualifier

Let us know it it works for you or need more help.

-Thanks,

AshishKMishra