Jerry_Owens4329

Participating Frequently

Answered

If Greater than Multiple by

Forum|Forum|1 year ago
September 12, 2024
25 replies
2663 views

I am trying to create a pdf javaScript formula that calculates if a field is greater than 2 multiple that field's value by 25 but not to exceed $250

This topic has been closed for replies.

Correct answer PDF Automation Station

Use the following custom calculation script:

var fld=this.getField("theField").value;

if(fld>2)

{event.value=fld*25}

else

{event.value=""}

if(event.value>250)

{event.value=250}

PDF Automation Station

Community Expert

Correct answer

Community Expert

Use the following custom calculation script:

var fld=this.getField("theField").value;

if(fld>2)

{event.value=fld*25}

else

{event.value=""}

if(event.value>250)

{event.value=250}

Community Expert

Community Expert

Consider adding an 'else' condition to reset the field to blank or 0 if the value initially exceeds 2 but subsequently drops below 2.

PDF Automation Station

Community Expert

Community Expert

Good point. Answer edited.