Grid field to have a change in variable.

Please post your code, at least the saveInto.

a!gridImageColumn(
                  label: "Active?",
                  field: "active",
                  data: {
                    a!forEach(
                      items: index(
                        local!data,
                        "active",
                        {}
                      ),
                      expression: if(
                        fv!item = 1,
                        a!documentImage(
                          document: a!iconIndicator(
                            icon: "STATUS_OK"
                          ),
                          caption: "Yes",
                          link: a!dynamicLink(
                            label: "change",
                            value: if(
                              fv!item = 1,
                              false,
                              true
                            ),
                            saveInto: a!save(
                              ri!change,
                              if(
                                fv!item = 1,
                                false,
                                true
                              )
                            )
                          )
                        ),
                        a!documentImage(
                          document: a!iconIndicator(
                            icon: "STATUS_NOTDONE"
                          ),
                          caption: "No",
                          link: a!dynamicLink(
                            label: "change",
                            value: if(
                              fv!item = 1,
                              false,
                              true
                            ),
                            saveInto: a!save(
                              ri!change,
                              if(
                                fv!item = 1,
                                false,
                                true
                              )
                            )
                          )
                        )
                      )
                    )
                  }/*index(local!data,"active",{})*/
                  
                )

ri!change is a boolean variable I used for checking purpose. It was supposed to replace the value in local!data .

Regards,

Kavya

I assume ri!change is a multiple. Then you need to address that specific value in that list. Use the square bracket notation. And there is no need to compare a boolean to "1".

It might be necessary to pre-populate ri!change with as many items as you have in your grid.

value: not(ri!change[fv!index]),
saveInto: ri!change[fv!index],

It was throwing error.

This is why I wrote "It might be necessary to pre-populate ri!change with as many items as you have in your grid."

Now it is saving the changed boolean values in ri!change. I have to save this ri!change to the local!data value ryt?

Also the values getting change in ri!change but not the icons. 

Also the values getting change in ri!change but not the icons. 

Yes.

You might need to change the logic for the dynamic image a bit to work with the correct value.

there are several issue not quite fine:

• dynamiklink with value and saveInto which contains only an a!save
• the if clauses with fv!item=1,
• checking index(local!data,"active",{}),  but storing the date in a rule input
  

  a!gridImageColumn(
    label: "Active?",
    field: "active",
    data: {
      a!forEach(
        items: index(
          local!data,
          "active",
          {}
        ),
        expression: {
          a!documentImage(
            document: a!iconIndicator(
              icon: "STATUS_OK"
            ),
            caption: "Yes",
            link: a!dynamicLink(
              label: "change",
              saveInto: {
                a!save(
                  target:local!data[fv!index].active,
                  value: true
                ),
                /*bot sure if necerssary, depends on your construct*/
                a!save(
                  target:ri!change[fv!index],
                  value: true
                )
              }
            ),
            showWhen: toboolean(fv!item)=true
          ),
          a!documentImage(
            document: a!iconIndicator(
              icon: "STATUS_NOTDONE"
            ),
            caption: "No",
            link: a!dynamicLink(
              label: "change",
              saveInto: {
                a!save(
                  target:local!data[fv!index].active,
                  value: false
                ),
                /*bot sure if necerssary, depends on your construct*/
                a!save(
                  target:ri!change[fv!index],
                  value: false
                )
              }
            ),
            showWhen: toboolean(fv!item)=false
          )
        }
      )
    }
  )

  
  try this
  
  edit: sorry wrong person i replied to 

Hi Richard,

I am facing this error.

Regards,

Kavya

The issue was to add pagination in editable grid. Since it is quite tricky and have disadvantages, we split the table to two. A grid field where the read only data from db is there and a editable grid below to add new data. So when the new user gets added it should check whether the user is active or not in the first table and also within the editable grid. If count of active user is greater than 1 it will throw error and ask user to change any one of the active so in grid field we need a option to change the active status. I have'nt coded for validation also. It is working within editable grid but not between 2 tables.