Multi-Select Text Locked

  • 1
  • 2
  • Question
  • Updated 5 months ago
  • Acknowledged
  • (Edited)
Why is Multi-Select Text unable to be changed to a different type? I inadvertantly changed the a field from Text to Multi-Select Text and want to revert it back to Text. 
This field is linked to numerous reports in my application and I dont want to have to build a new Text field just to reconnect all of my linked reports. 
Photo of PAUL


  • 112 Points 100 badge 2x thumb
  • Helpless and Frustrated

Posted 2 years ago

  • 1
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,758 Points 20k badge 2x thumb
I'm not 100% sure why they wont let you change it back, but I believe it has to do with legacy data conversions.  

As for now you will have to create a new field on that particular table, but all the lookup fields that you had mapped to it, will just need mapped to the new field.  No need to make all new lookup fields and fix all the reports on other tables.

You can also do a data migration from the old field to the new one so you keep your data.

Not ideal, but that is how you will need to correct the mistake.
Photo of PAUL


  • 112 Points 100 badge 2x thumb
Is there anyway to have a ticket made or something in order to change this for future users. It seems like a really bad design flaw. 

Photo of Michael Barrow

Michael Barrow

  • 2,216 Points 2k badge 2x thumb
Yeah, that's a major annoying bummer! They should have some sort of additional prompt warning when you are about to change to multi-select text to let you know that it's a one-way street.
Photo of John Van Horn

John Van Horn

  • 192 Points 100 badge 2x thumb
This is still the case and it got me just today. This needs to be addressed.