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?
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!1
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.