How to clear dependent drop down list line item value

Hi,

I have created dependent drop down list line item. . See below example data entered by user. Rack Market City is based on Rack market State.

Market -State	Rack Market - City
Alabama	Birmingham, AL
Alabama	Birmingham, AL

Later user changed state value to California and forgot to change the related city. But city is still having value based on previous state Alabama.

Market -State	Rack Market - City
California	Birmingham, AL
Alabama	Birmingham, AL

Is there any way City can be cleared to blank value automatically based on State selection when the city is not the selected state dependent list item?.

Thanks,

Suman.

Accepted answers

nathan_rudman

not "automatically", you have two options, and you can use both at the same time:

- create an alert line item to check the parent of city matches the state, so you can warn the user of the issue, color it, add a text warning etc. You can even make the following calcs ignore the values if wrong

- you can run an action (import) that will clear the city when it doesn't match the state parent. Given your setup you can automate that periodically (once per day or more). However I reommend the least actions possible as they are very disturbing for users on the model

All comments

nathan_rudman

not "automatically", you have two options, and you can use both at the same time:

Suman Reddy

Thank you @nathan_rudman for your suggestions.

Can i automate the action from one module to another module to clear the value within Anaplan app or do i need to take integration team help?. Thanks!.

Suman.

nathan_rudman

currently you cannot do an automation from Anaplan itself, so you'll need your integration team

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
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.…