Forum Discussion

MichaelRose's avatar
MichaelRose
Qrew Cadet
2 years ago

Unable to change field type from Text - Multi-line to Text - Multiple Choice

I have a strange one. I have a table with over 8,000 records. There is a field which is functioning as a multiple choice (drop down). When viewing the Fields list, the field shows type Text - Miult...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

Maybe the field got corrupted. 
I suggest making a new field of type formula text. The formula is just the other field. 

Then change the replacement field's field type to multiple choice. 

it should be populated and be a proper multiple choice field. 



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
MichaelRose's avatar
MichaelRose
Qrew Cadet
2 years ago

Thank you Mark. That solution worked well enough. Had to modify some reports and code pages, obviously, but all good otherwise.

Strange little bug, that one. Thanks for the help.



------------------------------
Michael Rose
------------------------------