If a user clicks an action button, I want to lockdown the data in table that's available to that user so that he cannot change or modify it later. Once done, it should be frozen! Any approach to achieve this functionality is highly appreciated.
@mohitlamba0101
You can achieve the functionality by using a simple concept of Dynamic Cell access. Follow the below steps
Step 1) Create a DCA module with three line items, two boolean formatted and one 'No Data' formatted. Dimension the module by user list.
Step 2)
Use the above module as a read/write access driver for the data module, where you want to lock the data for user entry.
Step 3)
Create an action which will copy the 'No Data' field into 'Write' line item of your DCA module. This will act as the action to 'Lock' the data module.
After entering the desired input the user have to run this action to lock the fields. To unlock, simply check the 'Write' boolean.
I hope it helps
~Anand
Hi Anand,
I tried this but can you please elaborate the third step because no action is generated to create the button when I perform the instructions.
When you import the 'Lock' line item into the 'Write' line item, an import action will be created for sure. You can publish that particular action on the dashboard. To elaborate
Step 1) Create a saved view keeping only the 'Lock' line item field.
Step 2) Now import it into the main view of the module by mapping the Write line item to the Lock line item.
An import action gets created in the Imports section of the Actions.
Let me know if things are still not clear.
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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.…