If, Else Statement Help

Question

I am working on an Adobe Form where I need a field to poulate a value based on the value in another field.

Here is the scenario:

Total_Score1	Performance_Rating1
22-24	EE
16-21	ME
10-15	NI
0-9	DNM

I tried using this on my Adobe Form to populate field "Performance_Rating1"

if ("TOTAL_SCORE1" > 21){ event.value = "EE";

} else if ("TOTAL_SCORE1" > 15){ event.value = "ME";

} else if ("TOTAL_SCORE1" > 9){ event.value = "NI";

} else event.value = "DNM";

The only result I am getting is "DNM" regardless of the value in TOTAL_SCORE1

DJ_Avalon · Accepted Answer

in the future, to find the best place to post your message, use the list here, https://community.adobe.com/

p.s. i don't think the adobe website, and forums in particular, are easy to navigate, so don't spend a lot of time searching that forum list. do your best and we'll move the post (like this one has already been moved) if it helps you get responses.

<"moved from using the community">

Thank you. I found the help I needed in another discussion... This is the formula that worked

if (getField("TOTAL_SCORE1").value > 21){ event.value = "EE"; }

else if (getField("TOTAL_SCORE1").value > 15){ event.value = "ME"; }

else if (getField("TOTAL_SCORE1").value > 9){ event.value = "NI"; }

else event.value = "DNM";

jane-e · Answer

I am working on an Adobe FormBy @DJ_Avalon Adobe is a company that make a lot of applications. Possibly you mean Acrobat? Let us know which Adobe app you are using and we will move your post for you. Jane

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