dependent dropdown multiple condition

Ana22
Ana22
in Modeling

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

 

Tagged:

Answers

  • M.Kierepka
    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
    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
    BahalR

    Hi,

     

    Were you able to find a solution for this?

  • sobaid
    sobaid
    I am also curious for creating a picklist based on multiple drivers
  • skjain
    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
    ramonito

    Trying skjain's solution worked for me :)

    Spread the love and humanity

Categories