Is it possible to make just one column in the worksheet grid view non-editable

Hello Community,

I am working on a user request where I have used Worksheets to create a page. The page has a grid that will be used to record input from user.

I see that there is an option to make entire grid editable or not. Is it possible to do the same for each individual columns? My columns are coming from a list which has 3 members. I want to get input for 2 members but not the third member?

Accepted answers

JohnP

Hi @sagarkpr, you can also use dynamic cell access to restrict write access to certain columns.

You will need to create a separate module with the list you are using for the columns and a boolean-formatted line item to mark which columns should be editable, example below:

You then apply this as the Write Access Driver to the line item in the data entry module:

And this prevents data entry in the column for Item 1:

You can also use this on modules with a list on each dimension, as below:

Hope this helps!

Best,

John

Tiffany.Rice

You can create a write access driver Boolean line item that is dimensioned by the plans list and then select the 2 plans that are editable. This can be used to apply the same access across all users.

I've mocked up a simple example - this can be expanded based on your needs as DCA is very versatile.

Create a SYS module to manage the access driver:

Then apply the drivers to the input line:

Users are then able to input only for list items indicated within SYS module:

All comments

JohnP

Hi @sagarkpr ,

Have you looked into using Dynamic Cell Access or Selective Access to control user write access to the columns in this grid?

Both can be used to control whether a user has read and write access; Dynamic Cell Access is best if the columns are line items, Selective Access if the columns are items from a list.

Best,

John

sagarkpr

Thanks, I indeed using Selective access currently to achieve this. Wanted to know if there is other ways to do this as well.

I am not a big fan of selective access for that fact that I have to select users manually for read/write access. If I expand and add more users, I have to go back to do it again.

Tiffany.Rice

Dynamic cell access will give you more flexibility to apply the same read/write logic across all users. You will need to create a Boolean line item that houses the logic and then apply that driver to the line item you are trying to restrict.

sagarkpr

@Tiffany.Rice My columns are not list items but actually they are members from a list. I have created 3 plans but want user to only edit 2 plans and not the third one.

Selective access is what I am currently using but want to make sure that is the best option since I have to manage that everytime I create new users.

JohnP

Hi @sagarkpr, you can also use dynamic cell access to restrict write access to certain columns.

You will need to create a separate module with the list you are using for the columns and a boolean-formatted line item to mark which columns should be editable, example below:

You then apply this as the Write Access Driver to the line item in the data entry module:

And this prevents data entry in the column for Item 1:

You can also use this on modules with a list on each dimension, as below:

Hope this helps!

Best,

John

Tiffany.Rice

You can create a write access driver Boolean line item that is dimensioned by the plans list and then select the 2 plans that are editable. This can be used to apply the same access across all users.

I've mocked up a simple example - this can be expanded based on your needs as DCA is very versatile.

Create a SYS module to manage the access driver:

Then apply the drivers to the input line:

Users are then able to input only for list items indicated within SYS module:

sagarkpr

Thanks for detailed explanation @JohnP . New to Anaplan and have not tried the Dynamic cell access yet but will definitely give it a try.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…