Custom calculation

Question

Hi,I have a script running but I am running into an issue between using the text fields and checkbox.Text1 has a default value of 15, this is multiplied by Text2 which the user can set (say for this example 6) + the value set to the checkbox (say 50). When the Text2 and the checkbox are empty the Total field is displaying "0Off" and if I fill in Text2 with 6 (15*6=90) it will show 90Off and with the checkbox finally checked it then displays the total of 140or if I change the Total field format to "number" I get an error message whenever one of the fields changes "The value entered does not match the format of the field [ Total ]" and does not 0 back out when the Text2 or checkbox are emptied again.Here is the code I am putting into the Total field for reference. event.value = ( this.getField("Text1").value * this.getField("Text2").value ) + this.getField("checkbox").value;

try67 · Accepted Answer

In addition to Bernd's correct remark, you also need to convert the values of the fields to numbers.

Try this code:

var v1 = Number(this.getField("Text1").valueAsString)
var v2 = Number(this.getField("Text2").valueAsString)
var v3 = (this.getField("checkbox").valueAsString=="Off") ? 0 : Number(this.getField("checkbox").valueAsString);
event.value = ( v1 * v2 ) + v3;

Bernd Alheit · Answer

The value of a unchecked checkbox is "Off".

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.