Problem: I have several dropdown lists with simple pick option as digits from 1 to 4. In the object layout the lists are not shown with digits, but with texts (instead of "1" one sees "great", instead of "2" one sees "good", instead of "3" one sees "not good" and instead of "4" one sees "bad"). Where do I find this relation in order to edit?
Thanks!
5 answers
Ruslan,
It looks to me like your picklist field was at one time four or five different Text values, and then someone changed both the Label and API Name on each one to a number. When you try to delete a value, Salesforce asks what you want to replace the existing values with, and when you just rename it, then it updates those values in the existing records where that field contains a picklist value (other than --None--).
That's really strange that your old values are still there in the records for the Object - unless there are two different picklist fields named Erster Kontakt that are using two different API Names - did you check for that in the Fields list ? When you Edit a record that contains one of the old values in that field, are the old picklist values still available to choose when you click on the drop-down or only the new ones ?
If there aren't two different fields with the same name (one of which is on the layout and the other isn't), and you can't find any documentation on it from the previous Admin, then I'm afraid the only way you will be able to differentiate them is to run a report and examine the records to try to follow some sort of business logic.
That's why every field has a Description text box...so we can make notes in case someone new starts administering the Salesforce instance, and to document for ourselves and others why we made any changes...it is a best practice, but as you can see, not every one does it.
