NocoDB
Error during column datatype change [Jun 02]
Discord-Discussions
NocoDB
November 3, 2022, 10:01am
1
saki
asked
image0
1371×250 32.8 KB
NocoDB
November 3, 2022, 10:01am
2
dstala
replied
You had a column with type ‘SingleLineText’. It had numbers stored in its rows. You get an error when you try to edit its datatype to ‘Number’.
Is this observation correct?
NocoDB
November 3, 2022, 10:01am
3
dstala
replied
I could see this error. Looks like the empty cell is causing problem (may be is being treated as a string).
I was able to edit column from text > number of clearing the contents of empty cell explicitly. (right click on the cell - click clear data).
NocoDB
November 3, 2022, 10:01am
4
saki
replied
yes, this was the case. the type is single line text, but even when i try to change it to Long Text I get the same error.
NocoDB
November 3, 2022, 10:01am
5
saki
replied
so this is a bug, right?
NocoDB
November 3, 2022, 10:01am
6
dstala
replied
yes
NocoDB
November 3, 2022, 10:01am
7
Autogenerated from discord
Join
NocoDB’s
community
Discord
•
Twitter
•
Reddit
•
Docs
Related topics
Topic
Replies
Views
Activity
Default columns to single line text [Mar 14]
Discord-Discussions
2
188
November 3, 2022
Excel import [Jan 19]
Discord-Discussions
4
220
November 3, 2022
Was there a recent change in the first party hosted nocodb API that makes it so you can't post json numbers into Single line text columns?
2
30
June 2, 2025
We figure if its an auto generated [Sep 27]
Discord-Discussions
2
253
November 3, 2022
Column delete - title length error [Jul 13]
Discord-Discussions
2
279
November 3, 2022