dependent dropdown multiple condition

Ana22

Hi,

 

Is there a way to make a line item( dropdown list format) to have multiple conditions? example :

 

I want my GL account dropdown to be filtered based on the account type selected (parent of the GL account) and based on the cost center selected? 

 

GL account is dependent on both the cost center selected and the account type selected.

 

Thanks,
Ana

 

M.Kierepka

Hi @Ana22,

Yes, it's possible, but exact solution is dependent on other parts, like if every user needs to have different selection, if you already have joined hierarchies etc.
You will probably need to do many-to-many mapping list (join table), more info can be found here: https://help.anaplan.com/4969bb8c-edae-47be-8241-9dd3942671bd-Create-many-to-many-filtered-picklists

 

Ana22

Thanks! tried that but it is just working for 1 driver. What I need is 2 drivers for one filter

Drivers are account type and cost center, and the list to be filtered is GL account.

Thanks,
Ana

BahalR

Hi,

 

Were you able to find a solution for this?

sobaid

I am also curious for creating a picklist based on multiple drivers

skjain

You could try creating a list which is a concatenation of the 2 lists and use it as a property to create a dependent dropdown. The concatenated list can refresh automatically whenever the 2 lists are updated.

ramonito

Trying skjain's solution worked for me :)

nickchavez9

Has anyone come up with any other solutions besides creating a concatenated list? This is the solution I use as well but it creates more lists to maintain as more combinations are created. Hoping there is an alternative out there. Thanks!

sobaid

@nickchavez9 Theres no update on the dependent dropdown concept so far, so we have to go with concatenation until then.