+ Start a Discussion
Ravi_SFDCRavi_SFDC 

I shouldn't be able to repeat the priority

I am prioritizing the account priorities as below. If i try to enter the same priority it shouldn't allow anyone to repeat the same, else give the alert msg. Can any one please suggest. Your help is appreciated. 
User-added image

Thanks 
Venkat
Best Answer chosen by Ravi_SFDC
@Karanraj@Karanraj
Set the priority number field as Unique type, so if the user enters duplicate values it will throw an error message.

All Answers

@Karanraj@Karanraj
Set the priority number field as Unique type, so if the user enters duplicate values it will throw an error message.
This was selected as the best answer
Ravi_SFDCRavi_SFDC

Hi Karanraj,

Thank you for the solution. But the current data type of the field is Number and data is available in production. Should i clear the existing data and then set the field as unique type and re-enter the values. Please suggest.