1 Reply Latest reply on Jul 22, 2011 2:01 PM by philmodjunk

    Using validation on a calculation field?



      Using validation on a calculation field?



      I am currently trying to set-up an inventory that will not allow you to complete a sale if you're going to put your invnetory in the negative.  You would think a simple validation could solve this but since a calculation field can not use validations my work around attempts have all failed.

      Help! thank you :)

        • 1. Re: Using validation on a calculation field?

          Data fields with auto-entered calculations can be validated--so that is one approach that may work for you.

          You can also use a script trigger to run a script that kicks in and checks for errors like this when the field being edited is exited or saved. Unlike a validation rule, this is limited to the specific layout where you add the trigger, but can also provide a more user friendly way to handle errors than the validation error messages.