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

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
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.…