Apex Code Development You need to sign in to do that
Don't have an account?
David Ovella How to create a validation rule that only allow a custom number field go in consecutive numbers?
Hello, I want to know if it's possible to create a validation rule to let a number field be created only in a consecutive order
Example: (001 to 100)
PreImpreso 001
PreImpreso 002
If I try to enter 004 and 003 it was not entered yet, I get the error "number isn't going in consecutive order"
Example: (001 to 100)
PreImpreso 001
PreImpreso 002
If I try to enter 004 and 003 it was not entered yet, I get the error "number isn't going in consecutive order"
This task can't be completed by validation rule. Because validation rule fire on current record and don't know the last record value.
You need to write a trigger for this to validate the data.
-Thanks
Ashlekh Gera