The CreatorCon Call for Content is officially open! Get started here.

In the custom application,needs to change data type field from string to reference on the table

Chahak kindra
Tera Contributor

‎03-14-2024 06:34 AM

In the custom application, needs to change data type field from string to reference on the table, it is showing error

error - "Type change not allowed. There exists data records that are not SysID".

0 Helpfuls
  • 188 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

‎03-15-2024 04:17 AM

Hi @Chahak kindra 

 

Yes , we cant change the data type easily. 

 

What need to do

- Take back up of data for the records.

- Delete all data of that particular filed.

- Change the data type

- Upload the back up data.

 

If the table you created is not extended , then better create a new field with new data type and move all old field data in new one quick and easy.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls