Enable Field Type of Table

[CrysZzz]

Hi Experts, I have a problem on changing the type of field in the Table. I want to set my field type to Integer, but in the lookup list of field class, it is not showed. How can I make it enabled for my field?

Wish to get your helps. Thank you.

[AnveshKumar M · Accepted solution]

Hi @CrysZzz 

What is the current type of field? And do you have any records having value stored in it?

ServiceNow will only allow you to change the field type to compatible fields only when there is any existing data for that field.

If you really want to change, and you don't want the name of the field to be changed, the better approach is backup the data in that table and delete the field and create a new one with the same name and re insert the data for that particular field from Backup.

For more information and instructions you can refer the following KB from ServiceNow.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0715663

Please mark my answer helpful and accept as solution if it helped you 👍✅

[CrysZzz]

Thanks for your help, I have already changed it when I remove the records