make a selection in a drop down field based on the value of two other field numbers

Question

I have a drop down field (A or B) that needs to be selected based on the value of two other fields

if C > D Dropdown = A

If C < D Drowpdown = B

How can I write this?

I am definitely new to this and have googled quite a few other answers, but this one is hard to narrow down.

Thx in advance

try67 · Accepted Answer

Thanks to you both. I got the form updated and checked and it is working perfectly for what i need!

One last thing. Is there a way to make the words show up in a certain color? Green for Accept - Red for Reject?

Yes. Replace this line:

event.value = (numC >= numD) ? "Accept" : "Reject";

With:

if (numC >= numD) {
	event.value = "Accept";
	event.target.textColor = color.green;
} else { 
	event.value = "Reject";
	event.target.textColor = color.red;
}

Nesa Nurani · Answer

You could use a text field instead of dropdown if you only have two values "A" and "B", and use this as custom calculation script of that text field:var c = this.getField("C").valueAsString;var d = this.getField("D").valueAsString;if (c && d) { var numC = Number(c); var numD = Number(d); if (!isNaN(numC) && !isNaN(numD)) {  event.value = numC > numD ? "A" : numC < numD ? "B" : "";}} else { event.value = "";}

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