I have a text field called Region. This field is receiving data from several APEX classes and a few flows as well, so I shouldn't change the field type. The purpose of that field is to store a city name for a record (we have about 20 city names).
Then I have a picklist field called Entity Code. What we need now is to make the Entity Code dependant of the Region field (for example, if Region = Shanghai, then Entity Code picklist should only show the values related to Shanghai). However, because Region is not a picklist, I cannot create a dependency between the two fields.
I was thinking to create an additional picklist called RegionClone containing the 20 city names as values and then have workflows rules to update RegionClone based on the Region text field value. But that means having many workflow rules in place, which I think it's not optimal.
Is there any other way I could achieve a dependency between text field and picklist?