Dropdown Lists - Filtering Second List

[ChrisPre]

I want to create a PDF with multiple rows that have two Dropdown Lists per row.  The first column Dropdown List will be called Org1, Org2, Org3, etc.  The second column Dropdown lists will be called FundCatagory1, FundCatagory2, FundCatagory3, etc.

What I want is for FundCatagoryX field list to be filtered base on the value/selection in OrgX field.  I'm new to this an don't know coding very well.  What is the simplest way to achive this desire?

Thanks

[Meenakshi Negi · Accepted solution]

Hi ChrisPre,

Thank you for reaching out

As you wish to create a dropdown list that will depend on the another dropdown list selection, please refer to the suggestion provided in the following community discussions on the similar topic:

-  https://community.adobe.com/t5/acrobat-discussions/how-to-populate-different-dropdown-list-based-on... 

-  https://community.adobe.com/t5/acrobat-sdk-discussions/populate-dropdown-list-with-results-from-mult.... 

- https://answers.acrobatusers.com/Conditional-Drop-Down-Help-q287268.aspx 

Check if that helps.

Thanks,

Meenakshi

[ChrisPre]

This worked perfectly.  Field1 is set to populate Category1, Field2 is set to populate Category2, etc.

[Nesa Nurani]

If all fields  share same items simpliest way would be to use 'for loop' script to set items or you can use validation script of "Org" fields to set items something like this:

if(event.value == "Item1")
this.getField("FundCatagory1").setItems(["One", "Two", "Three"]);

else if(event.value == "Item2")
this.getField("FundCatagory1").setItems(["Four", "Five", "Six"]);

[try67]

This only works well if Field A is filtering Field B, or the other way around, but not when they both filter each other.

In that scenario I would recommend not actually filtering the options but using a validation script to reject the selected option if it's already selected in the other field.