Script to expand dropdown

Forum|Forum|1 year ago
February 7, 2025
1 reply
682 views

Hi. I'm looking for help with a script to expand a dropdrown to show all options when the value of another cell is greater than 0. Can someone help with this? Thanks

var comp = this.getField("text").value;
var ins = this.getField("dropdown").value;

if(comp > 0 && ins == "--"){
  event.target.fillColor = color.red;
  // enter code to expand dropdown here
}
else{
  event.target.fillColor = color.transparent;
}

dropdown.pdf

Correct answer PDF Automation Station

Change your Dropdown calculation script to this:

var comp = this.getField("text").value;
var ins = event.value;

if(comp > 0 && ins == "--"){
event.target.fillColor = color.red;
// enter code to expand dropdown here
}
else{
event.target.fillColor = color.transparent;
}

PDF Automation Station

Community Expert

A dropdown can only be expanded by clicking the arrow with the mouse. You could pop up an alert showing all the options. If you want to show all options probably use a list box.

D

defaultarwakfbkwks7Author

Inspiring

Okay.

Is there a way to change the style of the box to highlight it to bring it to the user's attention? I have the fillColor as red, but it doesn't show unless the user clicks on it.

PDF Automation Station

Correct answer

Community Expert

Change your Dropdown calculation script to this:

var comp = this.getField("text").value;
var ins = event.value;

if(comp > 0 && ins == "--"){
event.target.fillColor = color.red;
// enter code to expand dropdown here
}
else{
event.target.fillColor = color.transparent;
}

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