Children under only one parent to be editable

ShekharGite · 2023-08-22T08:22:02+00:00

There was an error rendering this rich post.

Hi, I have a module with Boolean line item and a list L2 applied as dimension. L1 is the parent of L2 and I want the users to check the bollean in only L2 of same L1 and not of multiple L1s. To be more clear I want the users to edit the child of single parent and not multiple parents. Any thoughts? Thanks!

Accepted answers

All comments

ramonito

I have questions for this, is L2 a numbered list?

Also, is your requirement similar to this?

ShekharGite

Hi @ramonito C3 is not a numbered list but can made. So the requirement is when nothing is checked in Submit? All the Items should be editable as in image 1. But as soon as I check the Submit? for item 1 under Parent A. The items under all the other Parents - B,C,D…. should be locked and not editable but the items under A still should be editable. and to unlock items under B or any other parent user should unlock all the child items under A first. So basically, children under only one parent should be editable at a time.

ramonito

Oh, OK, you mean something like this?

No Selection:

2. Select any from A:

3. Select Any from C:

ShekharGite

@romonito Yes That's correct

ramonito

Here is what we did:

Create line item number that will assign number 1 if true and 0 if false (Line item 1)
Create a line item number that will show the sum of all Line Item 1 (Line item 2)
Create a line item boolean with Submit? as value but has the summary of Any (Line item 3)
Create a line item boolean to LOOKUP the value (Line Item 3) of the parent and spread it to the children (Line Item 4)
Create a line item for you DCA Write using the created line items above (Line Item 5):

If Line Item2 is zero and Line Item 4 is false then TRUE

If Line Item 2 is not zero and Line Item 4 is false then FALSE

Everything Else is True

6. Use Line item 5 for your DCA

Blueprint:

ShekharGite

@ramonito Thank you! It worked

Quick Links

Can you help?

Unanswered questions

Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
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…