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.
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.