I have a POSTCODE_SUBURB form that has a POSTCODE field as a number. I will now be adding UK postcodes that are in a alphanumeric format so I want to change the field to string type.
The POSTCODE field is referenced in many other forms and scripts. I cannot easily recreate the relationships/script logic/etc. The import fields that reference the POST_CODE field are also used in other script logic.
How can I change the field to string without spending too much time? Please do not give advice to create a new field and slowly phase out the old field as it is referenced is multiple parts of my application.
Note, the application is shared for support access