How to clear dependent drop down list line item value

Suman Reddy
Frequent Contributor

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 -StateRack Market - City
AlabamaBirmingham, AL
AlabamaBirmingham, 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 -StateRack Market - City
California Birmingham, AL
AlabamaBirmingham, 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.

1 ACCEPTED SOLUTION

Accepted Solutions
nathan_rudman
Master Anaplanner/Community Boss

Re: How to clear dependent drop down list line item value

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


Nathan Rudman, Anaplan Model Builder

View solution in original post

3 REPLIES 3
nathan_rudman
Master Anaplanner/Community Boss

Re: How to clear dependent drop down list line item value

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


Nathan Rudman, Anaplan Model Builder

View solution in original post

Suman Reddy
Frequent Contributor

Re: How to clear dependent drop down list line item value

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
Master Anaplanner/Community Boss

Re: How to clear dependent drop down list line item value

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

Nathan Rudman, Anaplan Model Builder