Skip to main content
Topics#Data ManagementSteve Andruszka's Question
Steve Andruszka asked in #Data Management
Oct 31, 2013, 1:24 AM

Data Validation 'Starts With'

Hi Gang,

 

Is there a way to force a required field to conform to a 'mask'?  For example, I would like every Opportunity Name to begin with "Opp -".

 

Can I force this?  Thanks!
2 answers
  1. Anshul Jain (ABSYZ)
    Oct 31, 2013, 1:40 AM
    Hi Steve,

     

    Create a Validation rule on Opportunities : NOT(BEGINS(Name, "Opp"))

     

    This should solve your problem.

     

    Regards,

     

    Anshul
Write an answer...
0/9000