JavaScript For calculation or any other formula

Question

Hii need help i applied the formula in PDF Form for subtraction which is column3-column2+1 for calculation, now if some fields are left empty it shows in total column the value is 1, (if the column3 and column2 are left empty in total column4), help me. Also tell me if i can get my desired result of calculation with a single button, but same result as i asked.

ls_rbls · Answer

This may be done in different ways.

But in my example below, I am executing the calculation from the total field "column4" as a custom calculation script instead of employing a button with an event action:

// declare your variables

var colum3 = this.getField("column3").value;
var column2 = this.getField("column2").value;

var total = (column3 - column2) + 1;


// establish a condition; if column3 or column2 have empty values column4 should remain empty

if (column3=="" || column2 ==""){

event.value ="";

// if the condition above is not met then execute calculation in target field column4

} else {

event.value = total;

}

See if the example above works for you.

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