Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Validation rules - filter on field changes
It would be useful if validation rules, like Record Change Triggers, could have an option to run only " when value changes in".

I have a particular case where I validate a date when a record is added. It may not fall before two years ago. However once the record has been added, users are allowed to edit all other fields. Now when a user goes back to edit that record and the two year limit has passed, albeit that he is not changing the date and is allowed to make the change to the other field, the update cannot proceed due to the date validation.

I can think of workarounds, but it would be nice to just extend this already existing functionality, to validations.
ID
1377
Category
Setup
Author

Philipp Matuschka (MMB)
Date Created
9/3/2020 4:21:31 AM
Date Updated
9/3/2020 5:37:18 AM
Status
New Idea
Score
30
Promoted By
Patricio BustosbaseninePhilipp Matuschka (MMB)
Comments
Slava Shinderov  Staff  9/3/2020 4:34:40 AM
@Phillip if you're looking just for particular case "when a record is added" then please consider adding RecordId()="0" condition to your validation rule.
Philipp Matuschka (MMB) 9/3/2020 5:37:18 AM
Hi Slava

Thanks for that suggestion, but maybe I stated the case too narrowly. The situation can arise in many other circumstances
Feedback
 
Back to Search Results