Validation on editable grid

sachink2402 over 1 year ago

i want to highlight these two duplicate values when a user enter a duplicate value.

Please suggest me validation code.

Discussion posts and replies are publicly visible

Parents

0 Stefan Helzle

Certified Lead Developer

over 1 year ago

a!localVariables(
  local!data: {
    a!map(key:1, value:"A"),
    a!map(key:2, value:"B"),
    a!map(key:3, value:"A"),
  },
  a!gridLayout(
    headerCells: {
      a!gridLayoutHeaderCell(label: "Header Cell")
    },
    rows: a!forEach(
      items: local!data,
      expression: a!gridRowLayout(
        id: fv!index,
        contents: {
          a!textField(
            value: fv!item.value,
            saveInto: fv!item.value,
            validations: if(
              contains(
                remove(local!data.value, fv!index),
                fv!item.value
              ),
              "Duplicate",
              null
            )
          )
        }
      )
    ),
  )
)

Reply

0 Stefan Helzle

Certified Lead Developer

over 1 year ago

a!localVariables(
  local!data: {
    a!map(key:1, value:"A"),
    a!map(key:2, value:"B"),
    a!map(key:3, value:"A"),
  },
  a!gridLayout(
    headerCells: {
      a!gridLayoutHeaderCell(label: "Header Cell")
    },
    rows: a!forEach(
      items: local!data,
      expression: a!gridRowLayout(
        id: fv!index,
        contents: {
          a!textField(
            value: fv!item.value,
            saveInto: fv!item.value,
            validations: if(
              contains(
                remove(local!data.value, fv!index),
                fv!item.value
              ),
              "Duplicate",
              null
            )
          )
        }
      )
    ),
  )
)

Children

No Data