Permanently delete/remove field form fields list in form designer

[Sharon Williams]

I accidentally used the wrong field type when creating a new field in the Form Designer.  I selected string (full UTF-8) instead of String for the field type.  I do not want user to use this new field and I also need to remove it permanently from the list of fields in the Form Designer.  I there a way to do this?

[Joshwa Antony S]

Hello Sharon,

Yes you can delete the field that you created.

Open the form > right click on the field which you want to delete > Configure Dictionary > Click "Delete".

Refer this doc: https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/reference-pages/t... 

Regards,

JAS

[Sukraj Raikhraj]

Why delete it if you can change the data type?

[Dennis R]

Sukraj is correct. You can't convert some field types to others, but String (UTF-8) is convertible to String.

Just look up Tier ID (probably named u_tier_id) in the sys_dictionary table where table is core_company, and change the type from String (Full UTF-8) to String. Save the dictionary record, and voila, you should be good to go.

If you do want to go with deleting the field, it would probably be a good idea to run a background script first to copy the values out of the old field into the new field; otherwise you might have some data loss. Reply if you need help with that, if you go that route.

Hope this helps,
--Dennis R