I would like to be able to easily convert a multiple choice field to a connection so that I can add more details to the selection.
Sometimes its necesarry to make rules or calculations in an object depending on a detail of something chosen in a multiple choice field.
In my case, i had made a multiple choice field where the user could choose which product they were producing.
A multiple choice field was sufficient untill a year later I needed to make calculations depending on the individual product’s density.
I was hoping to just make a new object with the same names of the products and changing the the multiple choice field to a connection to the new “products” object. That didnt work, so i had to make the object manually, manually update all records with the new connection and then scour my system to see where i might have used the data from the multiple choice field.
Ideally, there could be a function that upgraded multiple choice field to an object, and then changed the field to a connection to said object in one click. No one wants too many objects cluttering the setup, so multiple choice fields are great untill you want more details, then you have to start the tedious task of converting it to an actual object.