Error in multidropdown field while using record in editable grid

Certified Senior Developer

Hi all,
I am trying to show data in an editable grid where they can edit data and save it to back to database. While trying to display, I am getting the following error

This is how the data is present in database

I tried using split function but it didnt resolve the issue. Can someone tell what I am missing here . I have attached the code

a!localVariables(
  local!data: /*Query*/,
  local!dropdown: { "A", "B", "C", "D"},
  a!gridLayout(
    label: "Editable Grid",
    labelPosition: "ABOVE",
    headerCells: {
      a!gridLayoutHeaderCell(label: "Platform")
    },
    columnConfigs: {},
    rows: {
      a!forEach(
        items: local!data,
        expression: a!gridRowLayout(
          contents: a!multipleDropdownField(
            label: "Platform",
            choiceLabels: local!dropdown,
            choiceValues: local!dropdown,
            value: fv!item['recordType!{a3bb3bf8-8475-4d37-8cdd-f8db72114a55}record.fields.{a4be7f3b-9f4c-4101-8518-99a99631768e}platform'],
            saveinto:fv!item['recordType!{a3bb3bf8-8475-4d37-8cdd-f8db72114a55}record.fields.{a4be7f3b-9f4c-4101-8518-99a99631768e}platform']
          )
        )
      )
    },
    selectionSaveInto: {},
    validations: {},
    shadeAlternateRows: true
  )
)

  Discussion posts and replies are publicly visible

Parents
  • +1
    Certified Lead Developer

    How did you use the split() function?

    A small working example:

    a!localVariables(
      local!value,
      a!multipleDropdownField(
        choiceLabels: {"A", "B", "C"},
        choiceValues: {"A", "B", "C"},
        value: if(
          a!isNullOrEmpty(local!value),
          null,
          split(local!value, ";")
        ),
        saveInto: a!save(
          target: local!value,
          value: joinarray(save!value, ";")
        )
      )
    )

  • 0
    Certified Senior Developer
    in reply to Stefan Helzle

    Just an update. I tried the split function with ";" and followed it with a trim function. It solved the issue. The extra spacing hinted by   which comes after the semicolon separator has caused this issue.

    a!multipleDropdownField(
                label: "Platform",
                choiceLabels: local!dropdown,
                choiceValues: local!dropdown,
                value: trim(split(fv!item['recordType!{a3bb3bf8-8475-4d37-8cdd-f8db72114a55}TA Users Access.fields.{a4be7f3b-9f4c-4101-8518-99a99631768e}platform'],";")),
                saveinto:fv!item['recordType!{a3bb3bf8-8475-4d37-8cdd-f8db72114a55}TA Users Access.fields.{a4be7f3b-9f4c-4101-8518-99a99631768e}platform']
              )

  • +1
    Certified Lead Developer
    in reply to Sarathkumar R

    When I store multiple values to a single field, I want to have exact control on what is going on. By default, Appian concatenates values with a "; " separator. My code snippet changes that to just ";".

    And then, you don't need trim() to fix a problem, that you could avoid in the first place.

Reply Children