Editable grid

Question

I am having a editable grid in that I am adding a rows and in sometime I deleted some of the rows then the values depending upon it needs to be updated 
 For eg. I am having a field in editable grid called marks and total. If I deleted a one row(marks) Then the total needs to be updated after deleting

Harshit Bumb (Appyzie) · Answer

You already have a duplicate thread for this conversation - community.appian.com/.../interface

ujjwalr0002 · Answer

This is same code used in the thread harshit mentioned I have just added a delete button it is handling the scenario. 
 a!localVariables(
 local!gridData: {
 a!map(
 col1: "",
 col2: "",
 col3: "",
 col4: "",
 col5: "",
 col6: ""
 )
 },
 a!gridLayout(
 headerCells: {
 a!gridLayoutHeaderCell(label: "Col1"),
 a!gridLayoutHeaderCell(label: "Col2"),
 a!gridLayoutHeaderCell(label: "Col3"),
 a!gridLayoutHeaderCell(label: "Col4"),
 a!gridLayoutHeaderCell(label: "Col5"),
 a!gridLayoutHeaderCell(label: "Col6"),
 a!gridLayoutHeaderCell(label: "")
 },
 addRowLink: a!dynamicLink(
 label: "Add",
 saveInto: a!save(
 local!gridData,
 append(
 local!gridData,
 a!map(
 col1: "",
 col2: "",
 col3: "",
 col4: "",
 col5: "",
 col6: ""
 )
 )
 )
 ),
 rows: a!forEach(
 items: local!gridData,
 expression: if(
 fv!index = count(local!gridData),
 a!gridRowLayout(
 contents: {
 a!textField(readOnly: true()),
 a!textField(readOnly: true()),
 a!textField(readOnly: true(), value: "Total"),
 a!textField(
 readOnly: true(),
 value: sum(index(local!gridData, "col4", {}))
 ),
 a!textField(
 readOnly: true(),
 value: sum(index(local!gridData, "col5", {}))
 ),
 a!textField(
 readOnly: true(),
 value: sum(index(local!gridData, "col6", {}))
 ),
 a!textField(readOnly: 1)
 }
 ),
 a!gridRowLayout(
 contents: {
 a!textField(
 value: fv!item.col1,
 saveInto: fv!item.col1
 ),
 a!textField(
 value: fv!item.col2,
 saveInto: fv!item.col2
 ),
 a!textField(
 value: fv!item.col3,
 saveInto: fv!item.col3
 ),
 a!textField(
 value: fv!item.col4,
 saveInto: fv!item.col4
 ),
 a!textField(
 value: fv!item.col5,
 saveInto: fv!item.col5
 ),
 a!textField(
 value: fv!item.col6,
 saveInto: fv!item.col6
 ),
 a!richTextDisplayField(
 value: a!richTextIcon(
 icon: "times",
 link: a!dynamicLink(
 saveInto: a!save(
 local!gridData,
 remove(local!gridData, fv!index)
 )
 )
 )
 )
 }
 )
 )
 )
 )
)