Having a editable and non-editable grid

We have this list which has a Questions as a property

This is the module where changes have to be made using DCA. First line item (Questions to ask) should pull the questions from the list

DCA has been applied according to which first five cells have the read access and the next four have write access

I want to have the first 5 questions as hardcoded (pulled from the list) and the next 4 questions as editable

How to achieve this?

Tags

Accepted answers

Hello @yugam.bansal ,

2 quick options to achieve it:

Change code to numbers (i.e., 1, 2,3 ...) or make an intermediate stage with right(code,1) and the convert it into numbers using value().
Create boolean that is true when the number above is <=5
Apply as DCA

I hope that is suitable. Please let me know if you have any other issues!

Hi @yugam.bansal,

If both the grids have same dimension, then in the second grid, you can create a DCA line item for Read & Write seperately.

By the looks of it, you can input:

WRITE: If ISBLANK(Questions) THEN TRUE ELSE FALSE

READ: If ISNOTBLANK(Questions) THEN TRUE ELSE FALSE.

However, the line item which you apply DCA should be a new line item.

Here Editable Que Li & Final Que are new Line items. Read access can be applied to Questions to ask and Write access will be applied to "Editable Que Li" ad Final Que is referenced from both the line items based on the entries from the user.

Please let me know if this serves the purpose.

Thanks,

Puneeth HP

All comments

Hello @yugam.bansal ,

2 quick options to achieve it:

Change code to numbers (i.e., 1, 2,3 ...) or make an intermediate stage with right(code,1) and the convert it into numbers using value().
Create boolean that is true when the number above is <=5
Apply as DCA

I hope that is suitable. Please let me know if you have any other issues!

Hi @yugam.bansal,

If both the grids have same dimension, then in the second grid, you can create a DCA line item for Read & Write seperately.

By the looks of it, you can input:

WRITE: If ISBLANK(Questions) THEN TRUE ELSE FALSE

READ: If ISNOTBLANK(Questions) THEN TRUE ELSE FALSE.

However, the line item which you apply DCA should be a new line item.

Here Editable Que Li & Final Que are new Line items. Read access can be applied to Questions to ask and Write access will be applied to "Editable Que Li" ad Final Que is referenced from both the line items based on the entries from the user.

Please let me know if this serves the purpose.

Thanks,

Puneeth HP

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…