Conditional Import

Sachinsourav02
Contributor

Conditional Import

I have two columns, Column A and Column B. 

 

Column A is a manual input and column B is populated by an import action of the data of Column A. I have created a sperate module with Boolean checks to make the data of Column B not editable using write access driver. However when I run the action to populate column B new list members the data that's not editable in column still gets also gets updated. Is there a workaround for this issue, would like to know where I am going wrong. 

4 REPLIES 4
ChrisAHeathcote
Community Boss

Re: Conditional Import

@Sachinsourav02 

You need to create a saved view which only contains the items in column A that should be copied into column B. Use a filter to do this based on the DCA settings which control the Write access. 

Then use this filtered saved view in your import action.

 

Chris
HeathcoteAndHerran.com
Sachinsourav02
Contributor

Re: Conditional Import

Hey thanks for that and I was able to achieve it. Just wanted to check for my better understanding, is there a simpler way than this ? Can I avoid an import action ? And simply get the values from Column A to column B with a formula wherein changes made to values in column A does not impact column B
ChrisAHeathcote
Community Boss

Re: Conditional Import

@Sachinsourav02 

Yes, create a module dimensioned by the list. Add a boolean line item and check those items which are allowed to be copied over. 

In the column B line item use =IF ListModule.Boolean THEN Column A ELSE 0

Only values that correspond to the checked items in the first module will be visible in column B.

Chris
HeathcoteAndHerran.com
alexpavel
Certified Master Anaplanner

Re: Conditional Import

@Sachinsourav02  It depends who launches the import action to update the Column B ( a workspace admin user or a normal user)

 

If the import action is launched by a "NON-workspace admin" user, the values from the Column B will not be updated if the user has read-only access for those cells. In the action will appear the message of the cells "ignored" and the values will be preserved. 

 

If the import action is launched by a workspace admin user, those cells will always be updated, even in the module, the cells are shown as "read-only" also for the workspace admins. 

 

Currently, the workspace admins bypass the security on the cells that have read-only access and they can update the read-only cells. 

 

You can kudo this idea exchange if you would like that this behavior to be changed:

 

https://community.anaplan.com/t5/Idea-Exchange/Import-action-should-not-ignore-Selective-Access-for-...