need to change a boolean field into choice field

[suresh kaliappa]

Hello All , My requirement is i have a user defined boolean field and i want to convert it to choice field. Can someone please assist. The modification should happen without any data loss in the existing records. 

[Community Alums]

Hi @suresh kaliappa ,

 You can use this example as reference and try :

https://www.servicenow.com/community/developer-articles/get-boolean-value-for-fields-client-script-a...

[Raghav Sharma24]

If your table column has data, you cannot change the field type. As per servicenow that way is to clear the column and then change the type.

Workaround: Create a choice field with same label but different name, then write the fix/background script to copy old field  value to new field.

Please mark the answer correct/helpful accordingly.

[suresh kaliappa]

If you aware of fix background script can i have it please.

[Raghav Sharma24]

you need to provide the boolean to choice list mapping for that.