Selective access list to generate a date when changed

Hi,

I have a slective access list for approving a transaction, where certain people can approve a process or reject, challenge it.

When they choose 'approval status'.approved', i would like to add the date to a line item.

Adding a date to a line item is easy enough, HOWEVER the date field cannot be open, or people who do not have selective easily type a date in it.

i did think about using IF 'project approval' = 'approval status'.approved THEN timemodule.currentdate ELSE BLANK

But this would change the approval date every day,as i can't do an IF only when the field is changed can I?

You see my dilemna, how can i only allow a line item to be generated by people who have selctive access to the list, or only be updated when another line item is changed?

Thanks in advance

Accepted answers

nathan_rudman

You say you have your module is by transactions, it's what you should apply selective access on. Then only people allowed on a specific transaction (by region or cost center) will be able to modify it

Also in my previous message I put a link toward DCA, which is what you can use to have different access rights on different line items

All comments

nathan_rudman

Hi,

I think your question is unclear. You're saying you have selective access enabled so normally only the users allowed to would be able to change the date field. Hence, my misunderstanding. You should just allow them to enter the date. You can also use Dynamic Cell Access (DCA) to lock the status line item when it is approved and only unlock the date line item when the line is approved (and also lock it once the date is entered)

Using the formula definitely cannot work, as formulas are permanently calculated.

DeveloperCYT

Hi Sorry it was not clear, I had not used selective access before.

I hav enow used Dynamic Cell Access instead and all is good.

thanks

nathan_rudman

Also in my previous message I put a link toward DCA, which is what you can use to have different access rights on different line items

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.