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.
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
I have this template to import back to my module By right it should match the module because the time format is the same as the module the only difference is that in the excel file there is a seperator. M-Y. Thus logically to me it should be But when i run the action using M-Y and match names both result in an import error…
Hi everyone, I was trying to Retrieve a Line Item (Boolean) using TIMESUM as formula to another module by using ANY. This Boolean LI has A,B,C as dimensions. My target module has only A as dimension. In order to use a reference module for mapping, does this reference module had to have A,B and C as dimension or just A…
