Error in multidropdown field while using record in editable grid

Question

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
 )
)

Stefan Helzle · Accepted Answer

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, ";")
 )
 )
)

Naina Kumari · Answer

Hi , 
 The backend sent "A; B" as one string, so we have split it. Please refer to this code. a!localVariables(
 local!data: rule!TA_QRY_UserAccess(),
 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: 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']
 )
 )
 )
 },
 selectionSaveInto: {},
 validations: {},
 shadeAlternateRows: true
 )
)

Stefan Helzle · Answer

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.

Error in multidropdown field while using record in editable grid

Top Replies