1 Reply Latest reply on Jan 21, 2013 8:11 AM by George_Johnson

    Creating custom validation script

    BellsyTO2

      Hi all,

       

      Looking for code for the following:

       

      Want to create a custom validation script that would complete a calculation only if multiple fields (in this case, an entire column) have been filled in. Otherwise, it would return "missing data".

       

      Only calculate if: all fields complete

      If not: return "missing data"

       

      Any help would be great.

       

      Thanks

        • 1. Re: Creating custom validation script
          George_Johnson MVP & Adobe Community Professional

          You probably should use a custom calculation script instead. You didn't say what the calculation you want to perform is, so I won't suggest specific code, but you can get the value of each of the input fields as strings using the valueAsString field property. If none is equal to an empty string, go ahead with the calculation and assign the value of the field to the result.