What happens to existing record values if I delete or change an option in the settings of an option field?
If you delete an option in the settings of an option field, any existing values in records will remain as they were before the option was deleted.
If you change the name of an option in the settings of an option field, existing values in records will be replaced with the updated name.
The following fields are classified as option fields.
- Radio Button
- Drop-down
- Check box
- Multi-choice
Example of deleting an option from an option field
Suppose you select the option "sample 1" from a Drop-down field when you add a record. If you delete the option "sample 1" from the Drop-down field's settings later on, the value in the record will remain as "sample 1".
However, if you change the existing value in the record to a value other than the deleted option and save it, the deleted option will no longer be displayed in the Drop-down field the next time you open the Edit record screen. Also, the deleted option will not be displayed in the Drop-down field on the New record screen.
Example of changing the name of an option in an option field
Suppose you select the option "sample 1" from a Drop-down field when you add a record. If you change the option from "sample 1" to "sample A" in the Drop-down field's settings later on, the value "sample 1" in the record will be replaced with "sample A".
