Conditional formatting form field based on another field

[thall-CCR]

Hi Community,

I would like to highlight red the 'Dew Point' field when the value is 3 or more below the 'Steel Surface Temp' field. (ie Steel Surface = 40, Dew = 37, field = red).

Have managed to highlight red another field based on a value range, but am having trouble highlighting based of other fields.

Feel free to throw in any tips to help my understanding 🙂

Cheers!

[JR Boulay]

Use this as a Calculation script in the Dew Point field:

if (this.getField("Steel Surface Temp").value >= 3) {event.target.fillColor = color.red;}
else {event.target.fillColor = color.transparent;}

[thall-CCR]

Thanks JR!

[Thom Parker · Accepted solution]

Hi JR, I think he's looking for the difference between the two values. Here's a modification of the scirpt

if ((this.getField("Steel Surface Temp").value-event.value) >= 3) {event.target.fillColor = color.red;}
else {event.target.fillColor = color.transparent;}

[thall-CCR]

Works like a charm, thanks Thom.

[thall-CCR]

Thom, how do I adjust the script to fillcolor red if 3 above OR below the "Steel Surface Temp"

Thank you!

[Thom Parker]

Use the Absolute value of the difference for the comparison.

if (Math.abs(this.getField("Steel Surface Temp").value - event.value) >= 3)

{event.target.fillColor = color.red;}
else {event.target.fillColor = color.transparent;}

[thall-CCR]

thanks again Thom

[JR Boulay]

I still need to improve my understanding of English

😉

[Thom Parker]

You are doing great!!

[thall-CCR]

Thom, just have to say your tutorials on pdf scripting dot com have been a great help to my current form projects. 

[JR Boulay]

Thom's tools and tutorials are in first place in my list of PDF & JavaScript resources, even for French speakers.

See : https://www.abracadabrapdf.net/ressources-et-tutos/js-et-formulaires-ressources/ressources-pdf-javas...

🙂