Dropdown Selection - Deletion & Deletion of Data

Anaplanners

Is there a way we can restrict the end user from deleting the data.

For example a line item A is list formatted and has 3 options, currently Anaplan enables the user to click delete and remove all values, can this be restricted where users are forced to choose from the 3 available options all the time ?

Thanks

Accepted answers

All comments

shubhamrawat

Hi @Sachinsourav02

Can you explain more on how the user clicks to delete and remove all the values? if its a dropdown in a list formatted line item it is not possible to delete list item(s).

Sachinsourav02

Hello @shubhamrawat

You can delete, a list formatted line item, users with edit access can delete the data, simply by clicking "delete". Please do let me know if you require any further information

Thanks

PulkitChawla

@Sachinsourav02 - Not getting the point when you say users are able to delete item from the list?

But to answer your problem to ask the Users to mandatory select from the 3 given options, you can create a conditional formatting on that if there is no value for the list item then simply red highlight it and treat is as an invalid entry.

You can create a logic and write something like if your entry is valid then only the data should be flowing further otherwise it should not be flowing further.

Sachinsourav02

@PulkitChawla

let me try and give you an example:

So we have a custom-built filter to show investments that are critical, non-critical & parked.

Investment status is an attribute as well, where users can select the criticality against investments using a list drop down.

Now one of the investments went missing because user accidentally deleted or removed the criticality status and because of which the custom-built filter set up, users were unable to see the investment.

There are options like conditional formatting (again does not work for field type line item). Options to display blank in the filter (separate logic has to be written for it), however wanted to see if there is a way to restrict the users from deleting from the data from first place.

Thank You

seymatas1

@Sachinsourav02

There is no built-in Anaplan functionality that restricts deletion of a list item while letting the users select a list item.

As you and @PulkitChawla mentioned, there are a few alternative approaches:

1. Build conditional formatting to show items that should not be deleted.

2. Place a text card to warn users not to delete data.

3. Throw an error message when the cell is blank.

4. Create a staging module where users can make changes. Setup an action to update the main module from the staging module. Create a driver line item that lets users run the action only if all investment status are selected.

Users will able to run the action if all values are selected.

5. Consider submitting this functionality as a feature request.

Sachinsourav02

@seymatas1

Thank you for your detailed response !

And i agree there are plenty of options, however some associated challenges, like the current UX is set up with field cards which do not have conditional formatting features. We also have the action button to record the data from a staging module to the actual module. And here we have checks and balances in place to ensure data completion. However challenge is when we have provided end user a cockpit view where they can edit/modify the data (where they can also delete). We have implemented a table that tells user which attribute is missing.

However will submit in the idea exchange

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…