Show data from record type in editable grid

hi saitoy6477 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
    )
  )
}

hi saitoy6477 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
    )
  )
}

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

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

Hello saitoy6477 

saitoy6477 said:

I would like to show "checkbox" in grid. In read-only grid, I could not show the "checkbox".

Are you trying to select the complete row or is it going to be some kind of input field? 

Hi Konduru,

Thank you for your help.

I am required to select a complete row...I tried doing it by read-only -grid, but I could not....

Hi Abhishek,

I tried using your sample code, but I could not ...

The following error is shown...

Expression evaluation error: Syntax error. Details: Expression evaluation error at function a!textField parameter 2 [line 24]: The Target is missing

Line24 is the area I specified the record type... May I have your advice, please?

saitoy6477 Depending on your type of grid these patterns should help and resolve your issue.

docs.appian.com/.../grid-with-selection-pattern.html - Read Only

https://docs.appian.com/suite/help/24.3/recipe-use-selection-for-bulk-actions-in-an-inline-editable-grid.html - Editable Grid