If your project is in Production and you would like to add options to a drop-down list, never change the assigned number labels that have been used in existing records. This will cause data to be lost. Below it demonstrates and explains the problem caused.
Demonstration of problem caused by changing multiple choice options:
I currently have the multiple choice question designed the following way:
Many entries have been made, however, I realize that I want to add "good" as an option. I would like to place it between "Okay" and "Great". Situations like this can lead to problems because it oftentimes causes someone to change the numbering on the options. If you look at the changes I made in the choices below, you can see that I added "Good" and assigned it to the existing option number 3 and reassigned "Great" to option 4 (highlighted in yellow below). This will cause all existing entries to change the answer "Great" to "Good".
Unaccepted changes made in the following image. They are circled in red:
- The two images below show an accepted way of adding "good" as an option. This is because the option "great" stays assigned to option number 3 (highlighted in yellow in red box below).
Accepted changes shown in images below:
