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
Discussion posts and replies are publicly visible
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....
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