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 Bustos
basenine
Philipp 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
