• State Suggested Answer
  • Replies 11 replies
  • Answers 1 answer
  • Subscribers 15 subscribers
  • Views 3849 views
  • Users 0 members are here
Related Discussions
Home » Discussions » New to Appian

Selectable grid

sid

Hi, I am trying build read only selectable grid.

a!localVariables(
local!businessModuleStatus: rule!CR_QE_getModuleStatusForBusiness(
cif_int: ri!cif_int,
moduleId_int: ri!moduleId_int
),
a!boxLayout(
label: index(
local!businessModuleStatus,
"workflowDesc_txt",
""
),
style: "ACCENT",
contents: {
a!gridLayout(
spacing: "DENSE",
headerCells: {
a!forEach(
items: cons!CR_MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS,
expression: a!gridLayoutHeaderCell(
label: fv!item,
align: "LEFT"
)
)
},
columnConfigs: {
a!gridLayoutColumnConfig(
width: "DISTRIBUTE",
weight: 2
),
a!gridLayoutColumnConfig(
width: "DISTRIBUTE",
weight: 2
),
a!gridLayoutColumnConfig(
width: "DISTRIBUTE",
weight: 2
),
a!gridLayoutColumnConfig(
width: "DISTRIBUTE",
weight: 2
),
a!gridLayoutColumnConfig(
width: "DISTRIBUTE",
weight: 2
),
a!gridLayoutColumnConfig(
width: "DISTRIBUTE",
weight: 2
)
},
rows: {
a!forEach(
items: local!businessModuleStatus,
expression: a!gridRowLayout(
id: fv!item.inputRequestId1_int,
contents: {
a!textField(
value: fv!item.workflowDesc_txt,
readOnly: true(),
align: "LEFT"
),
a!textField(
value: rule!APN_FN_getDisplayName(
userId: fv!item.initiatedBy_txt
),
readOnly: true(),
align: "LEFT"
),
a!textField(
value: rule!CR_FN_DateTimeFormat(
input: fv!item.initiatedOn_dt
),
readOnly: true(),
align: "LEFT"
),
a!textField(
value: fv!item.moduleStatus_txt,
readOnly: true(),
align: "LEFT"
),
a!textField(
value: rule!APN_FN_getDisplayName(
userId: fv!item.approvedBy_txt
),
readOnly: true(),
align: "LEFT"
),
a!textField(
value: rule!CR_FN_DateTimeFormat(
input: fv!item.approvedOn_dt
),
readOnly: true(),
align: "LEFT"
)
}
)
)
},
selectable: true(),
selectionStyle: "ROW_HIGHLIGHT",
selectionValue: ri!inputSelectedId_int,
selectionSaveInto: {
a!save(
ri!inputSelectedId_int,
tointeger(
index(
reverse(
save!value
),
1,
null
)
)
),
a!save(
ri!systemSelectedId_int,
index(
local!businessModuleStatus,
"systemRequestId_int",
""
),

)
},
selectionRequired: true()
)
}
)
)

On selection of row one variable will get updated due to Id of a row, then if i retrieve value for second variable from localvariable. It is not updating for second variable if I select a new row.

Can someone suggest on this?

  Discussion posts and replies are publicly visible

Parents Reply Children
  • 0 in reply to GopalK

    a!localVariables(
    local!businessModuleStatus: rule!CR_QE_getModuleStatusForBusiness(
    cif_int: ri!cif_int,
    moduleId_int: ri!moduleId_int
    ),
    local!selectedId_int,
    local!selectedValues,
    a!boxLayout(
    label: index(
    local!businessModuleStatus,
    "workflowDesc_txt",
    ""
    ),
    style: "ACCENT",
    contents: a!gridField(
    data: local!businessModuleStatus,
    columns: {
    a!gridColumn(
    label: cons!MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS[1],
    sortField: cons!CR_APP_MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS[1],
    value: fv!row.workflowDesc_txt
    ),
    a!gridColumn(
    label: cons!MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS[2],
    sortField: cons!CR_APP_MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS[2],
    value: rule!APN_FN_getDisplayName(
    userId: fv!row.initiatedBy_txt
    ),

    ),
    a!gridColumn(
    label: cons!CR_APP_MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS[3],
    sortField: cons!CR_APP_MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS[3],
    value: rule!CR_FN_nbfDateTimeFormat(
    input: fv!row.initiatedOn_dt
    ),

    ),
    a!gridColumn(
    label: cons!CR_APP_MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS[4],
    sortField: cons!CR_APP_MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS[4],
    value: fv!row.moduleStatus_txt
    ),
    a!gridColumn(
    label: cons!CR_APP_MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS[5],
    sortField: cons!CR_APP_MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS[5],
    value: rule!APN_FN_getDisplayName(
    userId: fv!row.approvedBy_txt
    )
    ),
    a!gridColumn(
    label: cons!CR_APP_MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS[6],
    sortField: cons!CR_APP_MODULE_STATUS_GRID_FIELDS_FOR_BUSINESS[6],
    value: rule!CR_FN_nbfDateTimeFormat(
    input: fv!row.approvedOn_dt
    ),

    ),

    },
    selectable: true,
    selectionStyle: "ROW_HIGHLIGHT",
    selectionValue: local!selectedId_int,
    selectionSaveInto: {
    local!selectedId_int,
    /*a!save(*/
    /*local!selectedId_int,*/
    /*tointeger(*/
    /*index(*/
    /*reverse(*/
    /*fv!selectedRows*/
    /*),*/
    /*1,*/
    /*null*/
    /*)*/
    /*)*/
    /*),*/
    a!save(
    local!selectedValues,
    append(
    local!selectedValues,
    fv!selectedRows
    )
    ),
    a!save(
    local!selectedValues,
    difference(
    local!selectedValues,
    fv!deselectedRows
    )
    ),
    a!save(
    ri!inputSelectedId_int,
    local!selectedValues.inputRequestId1_int
    ),
    a!save(
    ri!systemSelectedId_int,
    local!selectedValues.systemRequestId_int
    )
    }

    Now I am getting both values ,but it is selecting mutliple rows but my requirement is single row to be selected. Can you please help in this?

  • 0 in reply to GopalK

    But we need only one selection at a time. In fv!selected multiple rows will be selected

  • 0
    Certified Lead Developer
     in reply to sid

    you can restrict the row selection please refer this Limit Grid Selection to One Row

  • 0
    Certified Lead Developer
     in reply to maaaaj0001

    You can limit the selection . Please go through the link which viraty shared.

  • 0 in reply to GopalK

    how can i fetch a specific field from fv!selectedRows?

© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.