Skip to main content
L
laxmipavanik0001
August 10, 2024
Question

If I selected one row in editable grid then it should deselect all other rows except selected row

  • August 10, 2024
  • 4 replies
  • 0 views

Expected behaviour: If i selected one row in editable grid then it should deselect all other rows except selected row , 

Actual behaviour: It is deselecting all remaining row whenever Iam selecting any row in editable grid,

a!localVariables(
  local!selectionIndex:tointeger({}),
  local!data:{
    {id:1,name:"Pavani"},
  {id:2,name:"Sravani"},
  {id:3,name:"Srani"},
    {id:4,name:"Sri"},
  },
  a!gridLayout(
    headerCells: {
      a!gridLayoutHeaderCell(
        label: "Id"
      )
    },
    rows:a!forEach(
      items: local!data,
      expression: {
        a!gridRowLayout(
          id: fv!index,
          selectionDisabled: if(a!isNullOrEmpty(local!selectionIndex),{},
          if(count(local!selectionIndex)=fv!itemCount,false(),true())),
          contents:a!integerField(
            label: "Id",
            value: fv!item.id,
            saveInto: fv!item.id
            
           
          ),
           ),
       
      }
    ),
    selectable: true(),
    rowHeader: 1,
    
    selectionValue: local!selectionIndex,
    selectionSaveInto: a!save(
      local!selectionIndex,
     save!value
    )
   
  )
)

    4 replies

    stefanhelzle0001
    stefanhelzle0001
    August 10, 2024

    https://docs.appian.com/suite/help/24.2/recipe-limit-the-number-of-rows-in-a-grid-that-can-be-selected.html

    L
    laxmipavanik0001Author
    August 10, 2024

    Hi [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] ,
    You previously provided a link about limiting the number of rows in a grid field. However, my requirement is different: I have a large amount of data in an editable grid, but I want the grid to behave so that when one row is selected, all other rows are automatically deselected.

    stefanhelzle0001
    stefanhelzle0001
    August 10, 2024

    a!localVariables(
  local!items: {
    {item: "Item 1", qty: 1, unitPrice: 10},
    {item: "Item 2", qty: 2, unitPrice: 20}
  },
  local!selected: tointeger({}),
  a!gridLayout(
    label: "Products",
    instructions: "Selected: " & local!selected,
    headerCells: {
      a!gridLayoutHeaderCell(label: "Item"),
      a!gridLayoutHeaderCell(label: "Qty"),
      a!gridLayoutHeaderCell(label: "Unit Price"),
      a!gridLayoutHeaderCell(label: "Total", align: "RIGHT")
    },
    rows: a!forEach(
      items: local!items,
      expression: a!gridRowLayout(
        id: fv!index,
        contents: {
          a!textField(
            value: fv!item.item,
            saveInto: fv!item.item
          ),
          a!integerField(
            value: fv!item.qty,
            saveInto: fv!item.qty
          ),
          a!floatingPointField(
            value: fv!item.unitPrice,
            saveInto: fv!item.unitPrice
          ),
          a!textField(
            value: a!currency(
              isoCode: "USD",
              value: tointeger(fv!item.qty) * todecimal(fv!item.unitPrice)
            ),
            readOnly: true,
            align: "RIGHT"
          )
        }
      )  
    ),
    selectable: true,
    selectionValue: local!selected,
    /* Flatten the selected values so the result is easier to work with */
    /* when the select/deselect all option is used in an editable grid  */
    selectionSaveInto: {
      a!save(
        target: local!selected,
        value: a!flatten(save!value)
      ),
      a!save(
        target: local!selected,
        value: index(local!selected, count(local!selected), null)
      ),
    },
    rowHeader: 1
  )
)

      Y
      yogip3177
      August 12, 2024

       [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05]  already provided a solution for the Editable grid.

      However, If you are not doing inline editing in the grid, go with the Read-Only Grid. It has a configuration parameter to control max selection (maxSelections).

          selectable: true,
    maxSelections: 1,
    selectionValue: local!selection,
    selectionSaveInto: local!selection
      Terms & ConditionsAccessibility statement