When I first set up my base, I established one field, mistakenly, as single line text instead of a number. I recognized it with 100+ records in, and have lived with it ever since. Now I want to change the field type for this field from single line text to number, without losing the entries.
I could probably sort the records by that field and add a new field as I want it, then add in all the new field entries, and last delete the old ones. Is there a faster or base-wide way to accomplish this?
Solved! Go to Solution.
Fastest method: [Customize this field] and change type to number. Numeric values will be retained, however non-numeric values will be lost.
Less fast, more prudent method: [Duplicate] that field with data option selected, then [Customize this field] change type to number, and see what happens…