Help with Javascript!

Forum|Forum|1 year ago
February 28, 2024
2 replies
2181 views

I am trying to run a JavaScript code for the below;

I have 3x fields. Field 1 = C Field 2 = CMin Field 3 = COK

of the value in C is greater than CMin, I need field COK to have the word 'Yes' in green font. If the value in C is less than CMin, I need the field COK to have the word 'No' in red font.

any help would be much appreciated

[moderator edited the subject for clarity, was "Help"]

.

This topic has been closed for replies.

Correct answer Nesa Nurani

Try this as custom calculation script of "COK" field:

var c = this.getField("C").value;
var cm = this.getField("CMin").value;

if (c === "" || cm === "") {
  event.value = "";} 
else {
  var cNum = Number(c);
  var cmNum = Number(cm);
  event.value = cNum >= cmNum ? "Yes" : "No";
  event.target.textColor = cNum >= cmNum ? color.green : color.red;}

S

Scott357615382vwxAuthor

Participant

Hi. Thank you for your fast response. If they are the same then the word 'yes' in green font is required. Thank you I never thought of that aspect. Really appreciate it

Nesa Nurani

Correct answer

Community Expert

Try this as custom calculation script of "COK" field:

var c = this.getField("C").value;
var cm = this.getField("CMin").value;

if (c === "" || cm === "") {
  event.value = "";} 
else {
  var cNum = Number(c);
  var cmNum = Number(cm);
  event.value = cNum >= cmNum ? "Yes" : "No";
  event.target.textColor = cNum >= cmNum ? color.green : color.red;}

S

Scott357615382vwxAuthor

Participant

Good morning Nesa,

firstly thank you for replying. I used the code and it works once, but now fails to reload depending on any changes made. I copy and pasted the code in. Is there something I am missing to refresh each time?

thank you for your support

try67

Community Expert

What about if they are the same?

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