Multiple Drivers for Dependent Dropdown

Highlighted
Contributor

Multiple Drivers for Dependent Dropdown

Hi All, 

 

I am maintaining a list formatted line item dependent on its parent to provide the end-user a "picklist" using which they can select list items basis their selected parent.

However, I want to show only some items on the picklist instead of all based on a list property(say Active?). 

 

The only solution I can think of is to create a new list of Parent&Active? and use that to drive the dependent picklist.

 

Is there a better way to do this?

 

3 REPLIES 3
Highlighted
Certified Master Anaplanner

Re: Multiple Drivers for Dependent Dropdown

Hi @ankit_cheeni ,

 

Create a subset for the list and use the same in the list formatted line item.

 

Hope this works.

Highlighted
Contributor

Re: Multiple Drivers for Dependent Dropdown

HI @Niranth ,

 

Your solution makes sense and is a much better way!

Thank you 🙂 

Highlighted
Master Anaplanner/Community Boss

Re: Multiple Drivers for Dependent Dropdown

@ankit_cheeni 

If you want to get really clever and have the list dynamic based on other data, you can, but can get a little tricky.

It's really powerful though, so worth playing with

 

For example, only being able to allocate to projects that have spaces available, or only allocate employees to specific types of projects based on role, experience etc.

 

this is a good article to follow through

https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Dropdowns/One-to-many_Filtered_Pic...

 

David