Having a editable and non-editable grid

yugam.bansal
yugam.bansal
in Modeling

We have this list which has a Questions as a property

image.png


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

image.png

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?

Best Answers

  • BrunoRodriguez
    BrunoRodriguez
    Answer ✓

    Hello @yugam.bansal ,

    2 quick options to achieve it:

    1. 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().
    2. Create boolean that is true when the number above is <=5
    3. Apply as DCA

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

    Kind regards,

    Bruno Rodriguez

  • Puneeth H P
    Puneeth H P
    Answer ✓

    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.

    image.png

    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

    Success is the Intersection of Dreams and Hardwork!

Categories