Question

How to have Text display based on multip drop-down selections

Forum|Forum|5 months ago
December 10, 2025
1 reply
143 views

I want to replicate a pass/fail metric in Adobe Forms as I have it in excel using drop downs to select each criteria as pass fail, with an overall pass/fail depending on how many of each.

In excel this is my formula: =IF(COUNTIF(Q8:Q24,"Fail")=0,"Overall Score: High",IF(COUNTIF(Q8:Q24,"Fail")=1,"Overall Score: Pass",IF(COUNTIF(Q8:Q24,"Fail")=2,"Overall Score: Low","Overall Score: Fail")))

Q fields are my dropdowns in excel. Is this something I can reproduce in adobe forms?

PDF Automation Station

Community Expert

Assuming your fields are named Q8 through Q24, enter the following custom calculation script in the text field:

var count=0;
for(var i=8; i<=24; i++)
{
if(this.getField("Q"+i).value=="Fail")
{count++}
}

if(count==0){event.value="Overall Score: High"}
else if(count==1){event.value="Overall Score: Pass"}
else if(count==2){event.value="Overall Scroe: Low"}
else{event.value="Overall Score: Fail}

W

WookiieAuthor

Thank you, this is the script AI gave me too but it required a few extra steps to get it to work.

If anyone else is interested in the future; each drop down required the script:

this.resetForm(["OverallScore"]);

PDF Automation Station

Community Expert

Where is that script (validation, calculation, etc.) and why would you need to reset the OverallScore field each time a dropdown changes it's value? The script runs the entire calculation every time any value changes. If you select "Commit selected value immediately" in the options tab of the dropdowns the calculation will run as soon as you make a selection.

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