change multi text to list collection or multi choice servicenow

_William_Knight · ‎11-17-2023

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

AshishKM · ‎11-17-2023

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

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

View solution in original post

AshishKM · ‎11-17-2023

Thanks for marking accepted solution, it gives kind of achievement and encouragement to contribute more towards community.

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution