Changing a field from True/False to String - is it possible?

Community Alums
Not applicable

‎10-29-2020 06:46 AM

Hi, 

We created a custom field in the table [rm_release] to allow us to capture information for our teams, however, now the business would like to amend this field type from type = True/False to a String with Choices (yes/no) and make the field Mandatory.
Unfortunately, when trying to amend the type in the dictionary entry, not all Types are showing. 

find_real_file.png

I've seen suggestions on other posts to add a new field, remove the original from the form and map current values as a parent.
However we're trying not to bring more fields into the table and it feels like this is something we should be able to do, but I am missing something.

Any help suggestions would be appreciated,

Aaron

Preview file
144 KB
0 Helpfuls
  • 2,249 Views
1 REPLY 1

Kieran Anson
Kilo Patron

‎10-29-2020 06:52 AM

Hi Aaron,

When you're changing a field type, you're not just changing a visual representation of data but the SQL data type as part of the schema. For this reason, only a few changes can be done where the data structure is similar.

You'll need to create the new field, use a fix script to map values across to the new field and then remove the old field once you've validated all the data has been moved across.