Skip to main content
saitoy6477
August 29, 2024
Question

Show data from record type in editable grid

  • August 29, 2024
  • 7 replies
  • 0 views

Hi all,

I'm a beginner of Appian, and I am required to show data in a record type by using editable grid in an interface.

May I know how to do it?

If I use "read-only" grid, it is easy to show the data from record type, but I cannot do it by using an editable grid..

I've tried to look for a document in https://docs.appian.com/suite/help/24.2/Editable_Grid_Component.html#related-patterns, but I could not find it.

I need your help!

Thank you in advance,

Yuki

7 replies

karumurua531442
August 29, 2024

hi [mention:00e6688d68c542b99c8c455359d12cd4:e9ed411860ed4f2ba0265705b8793d05] May I know why you would like to show your data in editable, are you going to edit your data?

For showing data in an editable grid. You can initially query your data in a local variable. then use  that local variable in your gird

{
  a!localVariables(
    local!data: /*your record type query*/,

    a!gridLayout(
      label: "Editable Grid",
      labelPosition: "ABOVE",
      headerCells: {
        a!gridLayoutHeaderCell(label: "Id"),
        a!gridLayoutHeaderCell(label: "Name"),
        a!gridLayoutHeaderCell(label: "")
      },
      columnConfigs: {
        a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
        a!gridLayoutColumnConfig(width: "DISTRIBUTE"),
        a!gridLayoutColumnConfig(width: "DISTRIBUTE")
      },
      rows: a!forEach(
        items: local!data,
        expression: a!gridRowLayout(
          contents: {
            a!textField(
              value: index your record type field           
              saveInto:  index your record type field 
            ),
          }
        )
      ),
      selectionSaveInto: {},
      validations: {},
      shadeAlternateRows: true
    )
  )
}
 

saitoy6477
August 29, 2024

Hi Abhishek,

Thank you for your help. I will try.

I would like to show "checkbox" in grid. In read-only grid, I could not show the "checkbox". Do you know it is possible to show "checkbox" in read-only grid?


A checkbox is like the following in https://docs.appian.com/suite/help/24.2/Editable_Grid_Component.html#related-patterns

karumurua531442
August 29, 2024

you can still have the check box in the editable grid also,  by enabling selected value parameter as true