
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 11, 2021 06:27 PM
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?
Many thanks.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 12, 2021 09:03 AM
Yes it’s safe to delete, as long as it is not part of some formula in that table, and is not looked/linked-up from another table.
(If my response solved your issue, please mark it as solution, thanks :winking_face: )

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 11, 2021 10:24 PM
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…

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 12, 2021 06:55 AM
Thanks, took the prudent path and it’s fine. Is it now safe to just delete the prior field?
Tim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 12, 2021 09:03 AM
Yes it’s safe to delete, as long as it is not part of some formula in that table, and is not looked/linked-up from another table.
(If my response solved your issue, please mark it as solution, thanks :winking_face: )

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 13, 2021 10:49 AM
Thanks! Much appreciated!
