Stop allowing copy and paste into dependant dropdowns

Hi,

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

DeveloperCYT_0-1652797663314.png

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

DeveloperCYT_1-1652797726585.png

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

thanks

 

 

Answers

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

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

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