Stop allowing copy and paste into dependant dropdowns

DeveloperCYT

Hi,

We have a field that is dependant and i have unticked 'Allow access to unfiltered items'

However if you copy and paste a valid (non dependant) value into the field it allows it

I have made it go red as a warning, but can it be stopped so you cannot paste into dependant dropdowns?

thanks

Accepted answers

All comments

ryan_kohn

I don't know of any workarounds for this, but I would suggest sending this over to Anaplan Support as this doesn't seem like it should be allowed.

Neeharika

Hi @DeveloperCYT,
There is no way around this, on the New UX dashboard there is a popup "Invalid Selection". but the user has to change the value manually, we can't stop the system for copy and pasting, because copying means copying something to the clipboard, it is the place where you can temporarily store data, and pasting it to another placeholder, so it can only be conditionally formatted, there is no provision to stop this.

carlossyquia

Hello,

Were you able to resolve this issue? What was the solution / workaround? Recently discovered this limitation and wondering if there's a way to prevent users from pasting invalid data based on the dependent dropdown set up for the line item. Conditional Formatting is only a visual warning but will still allow users to make the input.

Dikshant

Copying and pasting over dependent dropdowns is a known issue/behavior. Our solution is to show an Error Message line item to inform users of an invalid combination, accompanied by conditional formatting to highlight the column as red.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385