dependent dropdown multiple condition

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

Accepted answers

All comments

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.

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…