Apex Code Development You need to sign in to do that
Don't have an account?
salaunce Validation Confusion
I am having difficulty developing a validation. We have a formula field that calculated contract value. The problem is you can not track history/changes to formula fields. As a work around, I was asked to create a field "Verify Contract Value" that will require users to verify the amount of the contract value by entering it in this newly created custom currency field...which I can track the changes.
I am attempting to right a validation formula that says Verify Contract Value must = contract value and if it doesn't then he user should not be allowed to save the record. Please help...I'm really new to validations. I sincerely appreciate it.
Kind regards,
Simone Smtih
Validations are a formulas that need to equal TRUE for the validation error to show
Your formula should read
Verify_Contract_Value <> Contract_Value
This means if the verify value does not equal the Contract value, then show the error.
If you put
Verify_Contract_Value=Contract_Value
then this means if they do equal each other, then show the error.
I hope this helps.
All Answers
Validations are a formulas that need to equal TRUE for the validation error to show
Your formula should read
Verify_Contract_Value <> Contract_Value
This means if the verify value does not equal the Contract value, then show the error.
If you put
Verify_Contract_Value=Contract_Value
then this means if they do equal each other, then show the error.
I hope this helps.
Many thanks for all your help. I ended up going with a field update thru workflow rules. I found out you can not track the history on formula fields.
Kind regards and thanks