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.

Accepted answers

JoeAnderson

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.

All comments

klon2001cr

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. 🙂

klon2001cr

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

AvnishGoel

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 ..

naushad786

Hi @AvnishGoel ,

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.

Hope, It will help you.

Thanks,

Naushad

JoeAnderson

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.

klon2001cr

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

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…