Add user picker to grid

Hi,

I have a requirement to add a group picker as a column to the record type grid. Currently, we are fetching data from DS and displaying it on UI as record type grid. Additionally, I want to add a user picker to these records as an extra column, and then upon selecting and submitting, this should get saved to the DS. Can someone pls let me know how this can be achieved?

Thanks,

Subramaniyan J P

  Discussion posts and replies are publicly visible

Parents
  • load(
    local!employees: {
    {
    id: 1,
    firstName: "John",
    lastName: "Smith"
    },
    {
    id: 2,
    firstName: "Michael",
    lastName: "Johnson"
    },
    {
    id: 3,
    firstName: "Mary",
    lastName: "Reed"
    },

    },
    local!groupList: a!forEach(
    items: local!employees,
    expression: null
    ),
    a!formLayout(
    label: "Example",
    contents: {
    a!gridLayout(
    totalCount: count(
    local!employees
    ),
    headerCells: {
    a!gridLayoutHeaderCell(
    label: "First Name"
    ),
    a!gridLayoutHeaderCell(
    label: "Last Name"
    ),
    a!gridLayoutHeaderCell(
    label: "Group",
    align: "RIGHT"
    )
    },
    columnConfigs: {
    a!gridLayoutColumnConfig(
    width: "DISTRIBUTE",
    weight: 3
    ),
    a!gridLayoutColumnConfig(
    width: "DISTRIBUTE",
    weight: 3
    ),
    a!gridLayoutColumnConfig(
    width: "DISTRIBUTE",
    weight: 3
    )
    },
    rows: a!forEach(
    items: local!employees,
    expression: a!gridRowLayout(
    contents: {
    a!textField(
    label: "first name " & fv!index,
    value: fv!item.firstName,
    saveInto: fv!item.firstName,
    readOnly: true()
    ),
    a!textField(
    label: "last name " & fv!index,
    value: fv!item.lastName,
    saveInto: fv!item.lastName,
    readOnly: true()
    ),
    a!pickerFieldUsersAndGroups(
    value: local!groupList[fv!index],
    saveInto: local!groupList[fv!index],
    maxSelections: 1
    )
    },
    id: fv!index
    )
    ),
    rowHeader: 1
    )
    },
    buttons: a!buttonLayout(
    primaryButtons: a!buttonWidget(
    label: "Submit",
    submit: true
    )
    )
    )
    )

    When  submitting  the form save local value to your cdt like 

    a!forEach(
    items: local!groupList,
    expression: a!save(
    ri!cdt[fv!index].group,
    fv!item
    )
    )

Reply
  • load(
    local!employees: {
    {
    id: 1,
    firstName: "John",
    lastName: "Smith"
    },
    {
    id: 2,
    firstName: "Michael",
    lastName: "Johnson"
    },
    {
    id: 3,
    firstName: "Mary",
    lastName: "Reed"
    },

    },
    local!groupList: a!forEach(
    items: local!employees,
    expression: null
    ),
    a!formLayout(
    label: "Example",
    contents: {
    a!gridLayout(
    totalCount: count(
    local!employees
    ),
    headerCells: {
    a!gridLayoutHeaderCell(
    label: "First Name"
    ),
    a!gridLayoutHeaderCell(
    label: "Last Name"
    ),
    a!gridLayoutHeaderCell(
    label: "Group",
    align: "RIGHT"
    )
    },
    columnConfigs: {
    a!gridLayoutColumnConfig(
    width: "DISTRIBUTE",
    weight: 3
    ),
    a!gridLayoutColumnConfig(
    width: "DISTRIBUTE",
    weight: 3
    ),
    a!gridLayoutColumnConfig(
    width: "DISTRIBUTE",
    weight: 3
    )
    },
    rows: a!forEach(
    items: local!employees,
    expression: a!gridRowLayout(
    contents: {
    a!textField(
    label: "first name " & fv!index,
    value: fv!item.firstName,
    saveInto: fv!item.firstName,
    readOnly: true()
    ),
    a!textField(
    label: "last name " & fv!index,
    value: fv!item.lastName,
    saveInto: fv!item.lastName,
    readOnly: true()
    ),
    a!pickerFieldUsersAndGroups(
    value: local!groupList[fv!index],
    saveInto: local!groupList[fv!index],
    maxSelections: 1
    )
    },
    id: fv!index
    )
    ),
    rowHeader: 1
    )
    },
    buttons: a!buttonLayout(
    primaryButtons: a!buttonWidget(
    label: "Submit",
    submit: true
    )
    )
    )
    )

    When  submitting  the form save local value to your cdt like 

    a!forEach(
    items: local!groupList,
    expression: a!save(
    ri!cdt[fv!index].group,
    fv!item
    )
    )

Children