Skip to main content
Topics#Formulaspooja biswas の質問
pooja biswas が「#Formulas」で質問
2017年1月30日 3:55

validation rule to fire only during edit

Hi

I need to have a validation rule fire only when Lead object Email field is edited and not when inserted.

I did something like this on Lead object.

NOT(REGEX( Email  ,'([a-zA-Z0-9_\\-\\.]+)@((\\[a-z]{1,3}\\.[a-z]{1,3}\\.[a-z]{1,3}\\.)|(([a-zA-Z0-9\\-]+\\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})'))

so this works when a new Lead is inserted or edit  and email not proeprly specified.

Now I did like this

NOT(REGEX( Email  ,'([a-zA-Z0-9_\\-\\.]+)@((\\[a-z]{1,3}\\.[a-z]{1,3}\\.[a-z]{1,3}\\.)|(([a-zA-Z0-9\\-]+\\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})')) && NOT(ISNEW())

but its not working.

Need help on this.

thanks

pooja

 
5 件の回答
  1. Roshni Rahul (Logicline)
    2017年1月30日 6:52
    Hi pooja,

    AND(ISCHANGED(Email), NOT(ISNEW())) is working for me.

    Actually you dont have to check the NOT(REGEX( Email  ,'([a-zA-Z0-9_\\-\\.]+)@((\\[a-z]{1,3}\\.[a-z]{1,3}\\.[a-z]{1,3}\\.)|(([a-zA-Z0-9\\-]+\\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})'))  because email field throws that error if email is not in proper syntax. Standard validation is performed on it. Its working perfectly for me. If any problem, you can ask me. If working, please mark this as best answer
回答を記入...
0/9000