# šŸ†• Change type of basic column **URL:** \ **Category:** General\ **Created:** [September 4, 2020, 1:15pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272 "2020-09-04T13:15:07Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [September 4, 2020, 1:15pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/1 "2020-09-04T13:15:07Z")
You can now change the type of basic column in the data editor. This is really useful if for some reason the data editor hasnā€™t picked up your type or if you change your mind after adding a new column. Of course, different types of columns have different settings ā€“ e.g. with the image column, you can upload or browse Unsplash images and date/number columns have really useful formatting options. So this is worth playing around with if you havenā€™t already. ![Screen Shot 2020-09-04 at 2.14.18 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b35124365117d469a8b91bc44cdd3024399b4f4b.jpeg) ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [September 4, 2020, 1:20pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/2 "2020-09-04T13:20:09Z")
Is it gonna validate the entry of the user input ?@JackVaughan ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [September 4, 2020, 1:21pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/3 "2020-09-04T13:21:29Z")
Youā€™ll need to do this with components. I.e. number component for numbers etc. Is that what you mean? ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [September 4, 2020, 1:23pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/4 "2020-09-04T13:23:02Z")
What I mean is to add component and it doesnā€™t allow any text other than email to be able to avoid typos and errored mail entrys ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [September 4, 2020, 1:24pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/5 "2020-09-04T13:24:53Z")
Like this? This validation is done by the component. The type of basic column doesnā€™t affect this. ![Screen Shot 2020-09-04 at 2.24.23 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/ae087d7006af805728272650ad64db630b670337.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 4, 2020, 1:32pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/6 "2020-09-04T13:32:40Z")
Yes! I have old columns that have always been stuck as text. Now I can fix them without recreating them! ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [September 4, 2020, 2:26pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/7 "2020-09-04T14:26:48Z")
This just solved a problem that I had with my wifeā€™s app. Thanks a lot! ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [September 4, 2020, 3:01pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/8 "2020-09-04T15:01:48Z")
Ey @JackVaughan I have an issue with a Glide column I canā€™t deleteā€¦ no option. Look at the capture. Thanks! ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/cdbfbe98ba4aa02df1b4fc48b665c9683d8563a8.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 4, 2020, 3:03pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/9 "2020-09-04T15:03:10Z")
You canā€™t delete sheet columns from within glide. You can only do that with glide only columns. You have to delete it in the Google sheet itself. ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [September 4, 2020, 3:05pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/10 "2020-09-04T15:05:42Z")
Sure! As I said itā€™s a Glide only columnā€¦thatā€™s why itā€™s a issue I guessā€¦ ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 4, 2020, 3:06pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/11 "2020-09-04T15:06:48Z")
So that column doesnā€™t exist in your sheet? It doesnā€™t look like a user specific column or any of the other glide only column types. A non-user specific basic column created in glide will create the column in the sheet. ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [September 4, 2020, 3:08pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/12 "2020-09-04T15:08:59Z")
If you create a new basic column in the data editor - it will create one in your sheet. At the moment, you canā€™t delete google sheets columns from the data editor. However, you can delete Glide Computed columns in the data editor. The column you show there must be in your sheet - or if not thereā€™s something weird going on. ---
**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\ **Post date:** [September 4, 2020, 3:10pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/13 "2020-09-04T15:10:46Z")
Ok. Youā€™re rightā€¦ I found it in the Google sheet. Silly me! šŸ˜¬ ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [September 4, 2020, 3:12pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/14 "2020-09-04T15:12:24Z")
The order of columns in the data editor & google sheets is independent. Easy to miss when they have a different order! ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [September 4, 2020, 4:39pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/15 "2020-09-04T16:39:01Z")
> [@JackVaughan](#): > > The order of columns in the data editor & google sheets is independent Oh yes we know ā€¦ unfortunately šŸ™‚ ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [September 4, 2020, 5:25pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/16 "2020-09-04T17:25:20Z")
Yes @JackVaughan thanks for this ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 4, 2020, 10:34pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/17 "2020-09-04T22:34:41Z")
šŸ‘šŸ½ šŸ‘šŸ½ šŸ‘šŸ½ Hallelujah! Text \> Image column is going to be such a time saver! ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [September 7, 2020, 9:18am UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/18 "2020-09-07T09:18:58Z")
Yes! This will help a lot! šŸ‘šŸ¼ Thanks guys ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 7, 2020, 1:28pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/19 "2020-09-07T13:28:02Z")
I must have used this a dozen times just last night when attempting to relate numbers to strings to dates. ---
**Author:** ![S\_C](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/s_c/32/12766_2.png) [@S\_C](https://community.glideapps.com/u/S_C)\ **Post date:** [September 7, 2020, 1:44pm UTC](https://community.glideapps.com/t/change-type-of-basic-column/15272/20 "2020-09-07T13:44:33Z")
Thanks again for this feature. Just like @Robert_Petitto. Iā€™ve used it multiple times as well. Our mistakes are simply pardoned by Glideapps data editor in a single click now. Punishment of going to sheets and deleting the wrong kind of column and recreating the right kind of column is totally skipped šŸ˜ƒ [Next page](https://community.glideapps.com/t/change-type-of-basic-column/15272.md?page=2)