Highlighted
New Contributor

Dependent dropdown

I have one dimension "Employee" and want to assign two products A and B. Product A and Product B are two line items formatted as Product List. 

 

It is perfectly fine if employee is assigned the first product however, when the employee is assigned product B, then product A should not be visible in the dropdown as the employee has already been assigned. 

 

Employee   Product A      Product B

 

John           Screws          Nuts

 

When John is being assigned Nuts then Screws should not be visible in the drop down. 

 

Seems like a simple situation but I am struggling to make the logic.

chandigarhdude
6 REPLIES 6
Highlighted
New Contributor

Re: Dependent dropdown

Try using dynamic cell access approach. When a user selects a value from Product B, then, the Boolean (you could use this name for line item: "Activate Product A") will become false, else true. Now, for Product A line Item, set Read access driver and Write access driver to use "Activate Product A" value.

 

This should work. 🙂 

 

 

Highlighted
New Contributor

Re: Dependent dropdown

klon2001cr_0-1582062557157.png

Already implemented and it is working. Let me know if it works for you too. 

Highlighted
New Contributor

Re: Dependent dropdown

I guess, No. In your example, in the drop down for chosing Product A, against Chocolates, Nutzo bar should not be visible in the drop down ..
chandigarhdude
Highlighted
Contributor

Re: Dependent dropdown

Hi @CommunityMember113230 ,

 

You can create "Assign" action through which you can do that. Please see the below the screenshots. As you can see that Product A is assigned to John. When you will click again in "Assign Product to Customer " action. you will be able to assign Product B only. 

 

naushad786_0-1582095332373.png

naushad786_1-1582095371544.png

 

 

Hope, It will help you.

 

Thanks,

Naushad

 

Highlighted
Certified Master Anaplanner

Re: Dependent dropdown

I simple solution I've used in similar cases, or where you want inputs to be mutually exclusive (such as a series of Boolean inputs driving a calculation) is to use conditional formatting.

 

Line item: Error format

IF Product A = Product B then 10 else 0

 

That way you can flag it as red or some other color to indicate an input error. Not completely error proof, but quick and simple.

Highlighted
New Contributor

Re: Dependent dropdown

I was thinking on the same, usually I use the same. Thank you!