Multi-Select Text Locked

  • 0
  • 1
  • Question
  • Updated 1 year 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

PAUL

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

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 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

PAUL

  • 102 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. 

I
Photo of Michael Barrow

Michael Barrow

  • 2,206 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.