Configuring Write Access Driver by Drop-down

Hello,

I am trying to configure the write access driver of an item to build something as follows:

If drop-down item is selected, then the write access to a column is revoked. Else, you have write access.

Can a write-access driver be configured to dynamically change once a drop-down item is selected? All the examples that I have seen have only have used booleans.

Accepted answers

anand.shekhawat

@z77v303

Here you can write the conditions in both Read/Write access driver booleans. It would look something like below

IF 'INP00 - Checklist'.Type = A THEN TRUE ELSE IF 'INP00 - Checklist'.Type = B Then False ELSE IF 'INP00 - Checklist'.Type = C THEN FALSE ELSE FALSE

The above read/write access drivers will then drive your module/line item accordingly.

~Anand

All comments

anand.shekhawat

@z77v303

You can only set a boolean formatted line item as a Read/Write access driver for a line item (or for the module). Here what you could do is make the Read/Write access driver line items dynamic. To do this apply a suitable conditional formula on the access driver booleans to make it dynamic as per your selections in the drop down.

~Anand

z77v303

@anand.shekhawat

Regarding your point - let's say we have a drop-down column called TYPE consisting of:

Why can't I just make a formula that looks like this?

TRUE IF 'INP00 - Checklist'.Type = A ELSE FALSE

what would be the correct way to write this?

anand.shekhawat

@z77v303

Here you can write the conditions in both Read/Write access driver booleans. It would look something like below

IF 'INP00 - Checklist'.Type = A THEN TRUE ELSE IF 'INP00 - Checklist'.Type = B Then False ELSE IF 'INP00 - Checklist'.Type = C THEN FALSE ELSE FALSE

The above read/write access drivers will then drive your module/line item accordingly.

~Anand

rob_marshall

@anand.shekhawat

I would not do it this way as it is a) hardcoding, b) not scalable for the future, and c) it will not perform well as this lengthy IF THEN ELSE statement is sequential. Try using lookups to SYS modules instead and/or review this document https://community.anaplan.com/t5/Best-Practices/Decreasing-the-Length-of-Your-Formulas/ta-p/88467.

Now, using LISS as I did in the document, that only works with numbers, but that can be worked around by using booleans and 1 and 0's.

anand.shekhawat

@rob_marshall

After posting the comment, I also felt the same Rob. Thank you for the advice.

Lot to learn

Regards,

Anand

rob_marshall

@anand.shekhawat

All good, that is what this community is for, to learn!

Rob

z77v303

@anand.shekhawat @rob_marshall First of all, thank you for the assistance 🙂

I should note that the thing it is checking for is text. So if I do this
IF 'INP00 - Checklist'.Type = "A" THEN TRUE ELSE FALSE

I get this error:

Datatypes do not match for '=' function: LIST:Resource Type, TEXT

If I remove the quotation marks:

A is not a recognized line item or list member

rob_marshall

@z77v303

Let's start over or from the top.

What is the column you are wanting to have read only or write? Is it a line item or list member?

do you have a screenshot of what you are attempting to do?

Rob

z77v303

Sorry - this was a separate issue the dealt with the intricacies of my model. As for the question posed originally, your solution is correct.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…