I have built an app that does what it needs to do. However I have come across a problem with telephone numbers now I am adding data. As such I need to change the field type from number to text. The only way I can see to do this is to delete the current field and replace it with a new one.
Is there another way, either to stop the telephone numbers from changing format, or to change the field type.
If not, is there a way I can update all instances of the current data field (that I will be deleting) with the new data field?
I had a look around the forum to see if this was answered, but I couldn’t find anything obvious.