Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Change populated field type

Solved
Jump to Solution
237 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Solution

Accepted Solutions

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: )

See Solution in Thread

4 Replies 4

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…

Thanks, took the prudent path and it’s fine. Is it now safe to just delete the prior field?
Tim

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: )

Thanks! Much appreciated!