function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
eduardofernandeseduardofernandes 

Active validation rule, one time.

Good morning.

I have a problem.

How to I create a validation rule, but it works once.

I have a validation rule That test date if the date of close field, equals is today. After i have closed and the opportunity won this validation is activate, but I want to perform this validation rule not more.

 

Thanks for replies.

eduardofernandeseduardofernandes
AND(
   ISPICKVAL( StageName, "Fechado e ganho"),
   IF(TODAY() < CloseDate || TODAY() > CloseDate ,true,false), 
   NOT(
      ISPICKVAL(PRIORVALUE( StageName), "Fechado e ganho" )
   )
)
It's work. But is it?
Andy BoettcherAndy Boettcher

Validation Rules by themselves are desiged to always be active - you have to create a field to "shut it off" via logic.

 

You're probably going to need another custom field (checkbox I would recommend) that would be updated to TRUE (via workflow) once the condition is met where you don't want to have the Validation Rule fire anymore.  You'd then add that new field into your "AND" logic.