I have a bunch of existing values for picklist and now we want to make the picklist as restricted picklist. Some of the records may contain values which are not in the restricted picklist.
I initially thought that by making a picklist restricted it wouldnt allow save of the record if it had a bad value. But it did allow edit and save even if there value in picklist is bad.
What could be the best way to make sure the users change the value before they save the record again?
1, Validation Rule : Its ok if the picklist is small but if picklist is in hundreds then its gonna be big VR.
Any other way anyone can think of?