Validate only calculate if any of these fields have data

Question

Long time user and forum follower. I've gotten help off here several times, but first time posting. We have a form in the Army to write up faults. I changed it to auto calculate money, manhours, etc. I've created it with 3 pages in case we have to write more stuff up. I have each totals calculating total from page 1 + total page 2 etc. Is there any way to validate the next page will only calculate if data is put in any of the fields on page 2? In other words no total will auto calculate on page 2 and page 3 unless a field is filled on page 2. Like if data is in "field1" or "field2" or "field3" etc then it'll begin calculating that page. Have attached screenshots of 2 of the pages.

Thom Parker · Answer

Yes. The script in the calculations that need to be blocked can be setup to test for valid values in other fields before proceeding.

For example, if the field that needs to be checked is named "Data1", then the calculation script that needs to be validated would look like this:

This code proceeds with the calculation only if the value in the Data1 fields is not empty and a number value.

var strChkValue = this.getField("Data1").valueAsString;
if((strChkValue != "") && !isNaN(strChkValue)) 
{
   ... Do calculation.. 
   event.value = ...something...;
}

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded