How to change a textfield to a dropdown

I have two fields a customer has asked us to change from a TextField Type to a DropDown Type. It is for alt_address_state, and primary_address_state - we've gone through already and made sure the values matched what exists in the current State Dropdown list in Sugar.

Ive tried out some solutions found below, but I was told by support that they were outdated for Sugar Cloud. Support told me that it is something that is in the backlog to be implemented, but it looks like it has been there for a while.

https://support.sugarcrm.com/Knowledge_Base/Studio_and_Module_Builder/Converting_a_DropDown_Field_to_a_TextField/

https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_11.0/Cookbook/Changing_Address_Country_Field_to_a_Dropdown/

If there's no solution, we may just create a custom field.

Thanks

Parents
  • Back in v6x, before the state dropdown even existed, we added two custom dropdown fields: state_c and province_c

    then added a dependency so that state_c shows if Country = US, and province_c if country = CA, both are hidden if the country is something else.

    You can use a formula field to copy state_c and province_c respectively to the original state field so it's available in one field for things like document templates and reports.

    A little convoluted, but perhaps this can work for you too.

    FrancescaS

Reply
  • Back in v6x, before the state dropdown even existed, we added two custom dropdown fields: state_c and province_c

    then added a dependency so that state_c shows if Country = US, and province_c if country = CA, both are hidden if the country is something else.

    You can use a formula field to copy state_c and province_c respectively to the original state field so it's available in one field for things like document templates and reports.

    A little convoluted, but perhaps this can work for you too.

    FrancescaS

Children
No Data