Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount! Get 20% off now with code SPOOKY-2024!

change field type from text to select

  • Richardkl
  • Richardkl
  • OFFLINE
  • Posts: 6
  • Thanks: 0
  • Karma: 0
13 years 7 months ago #156366 by Richardkl
change field type from text to select was created by Richardkl
I would like to change the field type from text to select . this is for state as I have found the people abbreviate states differently. With out losing the data the in in the records. I will fix all the wrong abbreviations before the change.

Please Log in or Create an account to join the conversation.

  • heyai
  • heyai
  • OFFLINE
  • Posts: 324
  • Thanks: 79
  • Karma: 24
13 years 7 months ago #156379 by heyai
Replied by heyai on topic Re: change field type from text to select
Unfortunately, changing field types is not possible. You need to create the new field (I suggest a dropdown menu) and carry over the data to the new field. This is quite possible using a SQL query in your database.

hey-ai - the community for asian guys and non-asian girls

The search bar is your friend, not just decoration!

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum