Multiple Dependent Dropdowns

Question

Hello! I am fairly new to the whole javascript thing. I have edited a form for work to make it easier for people to make selections. I created a dependent drop down that based on the job that you pick, it gives you locations to select that you can go to. The field has asked for an additional dependency that would change only one job's locations, depending on if you have 3 years of experience or if you had less than 3 years (which already has a drop down).

Is there a way to link this together?

meaning:

Job A can go to x, y, or z.

Job B can go to x, y, or z if they have 1 to 3 years or a, b or c if the dropdown is set to 3+ years

Nesa Nurani · Accepted Answer

Use like this, but instead in 'Validate' tab use it in 'Calculate' tab as custom calculation script of the field where you select Job:

if (event.source && (event.source.name=="Experience" || event.source.name==event.target.name)) {
var location = this.getField("Location");
var exp = Number(this.getField("Experience").valueAsString);
if(event.value == "Job A")
 location.setItems(["x","y","z"]);
else if(event.value == "Job B"){
 if(exp >= 1 && exp <=3)
  location.setItems(["x","y","z"]);
 else if(exp > 3)
  location.setItems(["a","b","c"]);}}

Nesa Nurani · Answer

Use two condition within condition for Job B, something like this:

var location = this.getField("Location");
var exp = Number(this.getField("Experience").valueAsString);
if(event.value == "Job A")
 location.setItems(["x","y","z"]);
else if(event.value == "Job B"){
 if(exp >= 1 && exp <=3)
  location.setItems(["x","y","z"]);
 else if(exp > 3)
  location.setItems(["a","b","c"]);}

This is just an example script to demonstrate the functionality.

How you implement it will depend on how you select the "Experience" years. If "Experience" is a separate dropdown (like in my example), and you use a validate script to populate another dropdown, you need to ensure that the user selects the experience first. Otherwise, the logic might not execute as intended.

Alternatively, you can use a calculation script, where you'll need to reference the dropdown field using event.source to dynamically update the dependent dropdown. This approach avoids relying on selection order but requires a slightly different setup.

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