Error in Multiple Dropdown

Question

I have used an multiple dropdown box here and whenever i try to select more than 1 option from the multiple dropdown list it is showing this error. Can anyone please guide me through this issue kindly.

Thanks and Regards.

Shubham Aware · Accepted Answer

Try this code.. a!wizardLayout(
 titleBar: a!headerTemplateSimple(
 title: if(
 ri!isUpdate,
 "Update Post Job",
 "Add New Job"
 ),
 secondaryText: if(
 ri!isUpdate,
 "Update details for the post job",
 "Enter details of the job posting"
 ),
 titleColor: "STANDARD",
 stampIcon: ""
 ),
 isTitleBarFixed: true,
 backgroundColor: "#fbfbfb",
 steps: {
 a!wizardStep(
 label: "Details",
 contents: {
 a!cardLayout(
 contents: {
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!textField(
 label: "Company Name",
 labelPosition: "ABOVE",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{c08fdd20-8d7d-4d7b-87b9-5b77cddf1ae0}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{c08fdd20-8d7d-4d7b-87b9-5b77cddf1ae0}'],
 characterLimit: 255,
 showCharacterCount: false,
 required: true
 )
 }
 ),
 a!columnLayout(
 contents: {
 a!textField(
 label: "Skills Needed",
 labelPosition: "ABOVE",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{2a4a6efb-1880-4885-9769-657d9a0d3d7a}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{2a4a6efb-1880-4885-9769-657d9a0d3d7a}'],
 characterLimit: 255,
 showCharacterCount: false,
 required: true,
 marginAbove: "LESS"
 )
 }
 )
 }
 ),
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!dropdownField(
 choiceLabels: {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12},
 choiceValues: {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12},
 label: "Min. Experience (Yrs)",
 labelPosition: "ABOVE",
 placeholder: "--- Select Experience ---",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{3233cbf5-b9ea-425b-89de-87ca9f43de61}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{3233cbf5-b9ea-425b-89de-87ca9f43de61}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 ),
 a!columnLayout(
 contents: {
 a!dropdownField(
 choiceLabels: {"Full-TIme", "Part-Time", "Contract", "Internship"},
 choiceValues: {"Full-TIme", "Part-Time", "Contract", "Internship"},
 label: "Job Type",
 labelPosition: "ABOVE",
 placeholder: "--- Select Job Type ---",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{25d8c2b9-a722-4827-9a7d-576007cf1ec8}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{25d8c2b9-a722-4827-9a7d-576007cf1ec8}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 )
 }
 ),
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!dropdownField(
 choiceLabels: {"On-Site", "Remote", "Hybrid"},
 choiceValues: {"On-Site", "Remote", "Hybrid"},
 label: "Remote",
 labelPosition: "ABOVE",
 placeholder: "--- Select Remote ---",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{a5c53423-da0f-45a2-9bd2-2632c0d6fd2d}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{a5c53423-da0f-45a2-9bd2-2632c0d6fd2d}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 ),
 a!columnLayout(
 contents: {
 a!dropdownField(
 choiceLabels: {"IT Services and IT Consulting", "Professional Services"},
 choiceValues: {"IT Services and IT Consulting", "Professional Services"},
 label: "Industry",
 labelPosition: "ABOVE",
 placeholder: "--- Select Industry ---",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{209d8ba4-7627-472e-84a3-92a0e38177c0}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{209d8ba4-7627-472e-84a3-92a0e38177c0}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 )
 }
 ),
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!dropdownField(
 choiceLabels: {"Information Technology", "Management", "Manufacturing", "Engineering", "Other"},
 choiceValues: {"Information Technology", "Management", "Manufacturing", "Engineering", "Other"},
 label: "Job Function",
 labelPosition: "ABOVE",
 placeholder: "--- Select Job Function ---",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{deb3b8e4-e17f-4a87-b5eb-3dc96637c3fa}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{deb3b8e4-e17f-4a87-b5eb-3dc96637c3fa}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 ),
 a!columnLayout(
 contents: {
 a!dropdownField(
 choiceLabels: {"Software Engineer", "Development Specialist", "Technical Specialist", "Operational Specialist", "Lead Technician", "Lead Associate", "Automation Specialist", "Technical Architect"},
 choiceValues: {"Software Engineer", "Development Specialist", "Technical Specialist", "Operational Specialist", "Lead Technician", "Lead Associate", "Automation Specialist", "Technical Architect"},
 label: "Title",
 labelPosition: "ABOVE",
 placeholder: "--- Select Title ---",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{c9d3f040-1296-443d-9ba0-f85ab5bdf9d0}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{c9d3f040-1296-443d-9ba0-f85ab5bdf9d0}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 )
 }
 ),
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!multipleDropdownField(
 choiceLabels: {
 "Medical Insurance",
 "Vision Insurance",
 "Dental Insurance",
 "Pension Plan",
 "Paid Maternity Leave",
 "Paid Paternity Leave",
 "Commuter Benifits",
 "Disability Insurance"
 },
 choiceValues: {
 "Medical Insurance",
 "Vision Insurance",
 "Dental Insurance",
 "Pension Plan",
 "Paid Maternity Leave",
 "Paid Paternity Leave",
 "Commuter Benifits",
 "Disability Insurance"
 },
 label: "Benifits",
 labelPosition: "ABOVE",
 placeholder: "--- Select Benefits ---",
 value: if(
 a!isNullOrEmpty(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}']
 ),
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}'],
 split(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}'],
 "; "
 )
 ),
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 ),
 a!columnLayout(
 contents: {
 a!multipleDropdownField(
 choiceLabels: {"Career Growth and Learning", "Work-Life Balance", "Environment Sustainability"},
 choiceValues: {"Career Growth and Learning", "Work-Life Balance", "Environment Sustainability"},
 label: "Commitment",
 labelPosition: "ABOVE",
 placeholder: "--- Select Commitments ---",
 value: if(
 a!isNullOrEmpty(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{f56371d2-87b6-4f6e-a0fe-b4eabcaeaa51}']
 ),
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{f56371d2-87b6-4f6e-a0fe-b4eabcaeaa51}'],
 split(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{f56371d2-87b6-4f6e-a0fe-b4eabcaeaa51}'],
 "; "
 )
 ),
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{f56371d2-87b6-4f6e-a0fe-b4eabcaeaa51}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 )
 }
 )
 },
 width: "WIDE"
 )
 }
 )
 },
 style: "NONE",
 shape: "SEMI_ROUNDED",
 padding: "MORE"
 )
 }
 ),
 a!wizardStep(
 label: "Location",
 contents: {
 a!cardLayout(
 contents: {
 a!gridLayout(
 label: "Location",
 labelPosition: "COLLAPSED",
 instructions: "Enter locations for the post job",
 headerCells: {
 a!gridLayoutHeaderCell(label: "Location"),
 a!gridLayoutHeaderCell()
 },
 columnConfigs: {
 a!gridLayoutColumnConfig(width: "NARROW_PLUS"),
 a!gridLayoutColumnConfig(width: "ICON")
 },
 rows: a!forEach(
 items: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'],
 expression: a!gridRowLayout(
 id: fv!index,
 contents: {
 a!textField(
 value: fv!item['recordType!{ba213b7b-b6ea-4bb2-bafc-e0717f2a0e4e}.fields.{f7c76f4f-6417-40e6-b6a3-47a2cf7315e4}'],
 saveInto: fv!item['recordType!{ba213b7b-b6ea-4bb2-bafc-e0717f2a0e4e}.fields.{f7c76f4f-6417-40e6-b6a3-47a2cf7315e4}'],
 characterLimit: 255,
 showCharacterCount: false
 ),
 a!imageField(
 images: a!documentImage(
 document: a!iconIndicator(icon: "REMOVE"),
 altText: "Remove Row" & char(32) & fv!index + 1,
 link: a!dynamicLink(
 value: fv!index,
 saveInto: {
 a!save(
 ri!deletedLocationRecords,
 if(
 a!isNotNullOrEmpty(ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'][save!value]['recordType!{ba213b7b-b6ea-4bb2-bafc-e0717f2a0e4e}.fields.{1f09a335-8419-4f2d-a33a-c2043528b38d}']),
 append(ri!deletedLocationRecords, ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'][save!value]),
 ri!deletedLocationRecords
 )
 ),
 a!save(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'],
 remove(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'],
 save!value
 )
 )
 }
 )
 ),
 size: "ICON"
 )
 }
 )
 ),
 height: "AUTO",
 addRowLink: a!dynamicLink(
 label: "Add Row",
 value: 'recordType!{ba213b7b-b6ea-4bb2-bafc-e0717f2a0e4e}'(),
 saveInto: a!save(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'],
 append(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'],
 save!value
 )
 )
 ),
 shadeAlternateRows: false,
 borderStyle: "LIGHT",
 rowHeader: 1
 )
 },
 style: "NONE",
 shape: "SEMI_ROUNDED",
 padding: "MORE"
 )
 }
 )
 },
 primaryButtons: a!buttonWidget(
 label: if(
 ri!isUpdate,
 "Save",
 "Create"
 ),
 submit: true,
 style: "SOLID",
 showWhen: fv!isLastStep,
 validate: true
 ),
 secondaryButtons: a!buttonWidget(
 label: "Cancel",
 value: true,
 saveInto: ri!cancel,
 submit: true,
 style: "LINK",
 validate: false
 ),
 showButtonDivider: true
)

Shubham Aware · Answer

The error occurs because the variable in value and saveInto is not a List of Text. For a multiple dropdown, ensure the variable is a list and multiple: true is set.

Varun Teja Gurrapu · Answer

Hi skzahed_09 , Please check any null values are being stored in the saveInto Variable you've configured, handle the null condition. One more issue may be like the rule input data type is not an array. If both doesn't work, can you please put your code, inorder to address exact issue?

Shubham Aware · Answer

You can store multiple text values in a record field either by: 1. Saving them as a separator string in one text field (quick but not ideal). 2. Using a one-to-many relationship with a child table (best practice for scalability and querying). Try this as for your understanding. a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!multipleDropdownField(
 choiceLabels: {
 "Medical Insurance",
 "Vision Insurance",
 "Dental Insurance",
 "Pension Plan",
 "Paid Maternity Leave",
 "Paid Paternity Leave",
 "Commuter Benifits",
 "Disability Insurance"
 },
 choiceValues: {
 "Medical Insurance",
 "Vision Insurance",
 "Dental Insurance",
 "Pension Plan",
 "Paid Maternity Leave",
 "Paid Paternity Leave",
 "Commuter Benifits",
 "Disability Insurance"
 },
 label: "Benifits",
 labelPosition: "ABOVE",
 placeholder: "--- Select Benefits ---",
 value: if(
 a!isNullOrEmpty(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}']
 ),
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}'],
 split(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}'],
 "; "
 )
 ),
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 )
 }
)

Shubham Aware · Answer

You might be missing somewhere. 
 I would suggest going to an earlier version when you shared this code, collapsing the columnLayout, and paste the code below to replace it. 
 a!columnLayout(
 contents: {
 a!multipleDropdownField(
 choiceLabels: {
 "Medical Insurance",
 "Vision Insurance",
 "Dental Insurance",
 "Pension Plan",
 "Paid Maternity Leave",
 "Paid Paternity Leave",
 "Commuter Benifits",
 "Disability Insurance"
 },
 choiceValues: {
 "Medical Insurance",
 "Vision Insurance",
 "Dental Insurance",
 "Pension Plan",
 "Paid Maternity Leave",
 "Paid Paternity Leave",
 "Commuter Benifits",
 "Disability Insurance"
 },
 label: "Benifits",
 labelPosition: "ABOVE",
 placeholder: "--- Select Benefits ---",
 value: if(
 a!isNullOrEmpty(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}']
 ),
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}'],
 split(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}'],
 "; "
 )
 ),
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 )
 }
)

Varun Teja Gurrapu · Answer

It won't work as the multiple dropdown selects multiple values and your record field is not an array, It refers one to many relationship between the values in variable and record field. In-order to achieve this you need to create a local variable, Save the value in local variable and then in submit button you need to iterate the multiple dropdown values into rule input. For detailed explanation, Refer - docs.appian.com/.../Multiple_Dropdown_Component.html or you can just append with ";" or "," into single field as typecasting them to single text. This will surely work!!! Let me know if you still face the issue.

Varun Teja Gurrapu · Answer

Can you try this code? this is just appending all the options into single field as text a!localVariables(
 local!benefits,
 {a!wizardLayout(
 titleBar: a!headerTemplateSimple(
 title: if(
 ri!isUpdate,
 "Update Post Job",
 "Add New Job"
 ),
 secondaryText: if(
 ri!isUpdate,
 "Update details for the post job",
 "Enter details of the job posting"
 ),
 titleColor: "STANDARD",
 stampIcon: ""
 ),
 isTitleBarFixed: true,
 backgroundColor: "#fbfbfb",
 steps: {
 a!wizardStep(
 label: "Details",
 contents: {
 a!cardLayout(
 contents: {
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!textField(
 label: "Company Name",
 labelPosition: "ABOVE",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{c08fdd20-8d7d-4d7b-87b9-5b77cddf1ae0}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{c08fdd20-8d7d-4d7b-87b9-5b77cddf1ae0}'],
 characterLimit: 255,
 showCharacterCount: false,
 required: true
 )
 }
 ),
 a!columnLayout(
 contents: {
 a!textField(
 label: "Skills Needed",
 labelPosition: "ABOVE",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{2a4a6efb-1880-4885-9769-657d9a0d3d7a}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{2a4a6efb-1880-4885-9769-657d9a0d3d7a}'],
 characterLimit: 255,
 showCharacterCount: false,
 required: true,
 marginAbove: "LESS"
 )
 }
 )
 }
 ),
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!dropdownField(
 choiceLabels: {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12},
 choiceValues: {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12},
 label: "Min. Experience (Yrs)",
 labelPosition: "ABOVE",
 placeholder: "--- Select Experience ---",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{3233cbf5-b9ea-425b-89de-87ca9f43de61}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{3233cbf5-b9ea-425b-89de-87ca9f43de61}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 ),
 a!columnLayout(
 contents: {
 a!dropdownField(
 choiceLabels: {"Full-TIme", "Part-Time", "Contract", "Internship"},
 choiceValues: {"Full-TIme", "Part-Time", "Contract", "Internship"},
 label: "Job Type",
 labelPosition: "ABOVE",
 placeholder: "--- Select Job Type ---",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{25d8c2b9-a722-4827-9a7d-576007cf1ec8}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{25d8c2b9-a722-4827-9a7d-576007cf1ec8}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 )
 }
 ),
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!dropdownField(
 choiceLabels: {"On-Site", "Remote", "Hybrid"},
 choiceValues: {"On-Site", "Remote", "Hybrid"},
 label: "Remote",
 labelPosition: "ABOVE",
 placeholder: "--- Select Remote ---",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{a5c53423-da0f-45a2-9bd2-2632c0d6fd2d}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{a5c53423-da0f-45a2-9bd2-2632c0d6fd2d}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 ),
 a!columnLayout(
 contents: {
 a!dropdownField(
 choiceLabels: {"IT Services and IT Consulting", "Professional Services"},
 choiceValues: {"IT Services and IT Consulting", "Professional Services"},
 label: "Industry",
 labelPosition: "ABOVE",
 placeholder: "--- Select Industry ---",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{209d8ba4-7627-472e-84a3-92a0e38177c0}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{209d8ba4-7627-472e-84a3-92a0e38177c0}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 )
 }
 ),
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!dropdownField(
 choiceLabels: {"Information Technology", "Management", "Manufacturing", "Engineering", "Other"},
 choiceValues: {"Information Technology", "Management", "Manufacturing", "Engineering", "Other"},
 label: "Job Function",
 labelPosition: "ABOVE",
 placeholder: "--- Select Job Function ---",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{deb3b8e4-e17f-4a87-b5eb-3dc96637c3fa}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{deb3b8e4-e17f-4a87-b5eb-3dc96637c3fa}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 ),
 a!columnLayout(
 contents: {
 a!dropdownField(
 choiceLabels: {"Software Engineer", "Development Specialist", "Technical Specialist", "Operational Specialist", "Lead Technician", "Lead Associate", "Automation Specialist", "Technical Architect"},
 choiceValues: {"Software Engineer", "Development Specialist", "Technical Specialist", "Operational Specialist", "Lead Technician", "Lead Associate", "Automation Specialist", "Technical Architect"},
 label: "Title",
 labelPosition: "ABOVE",
 placeholder: "--- Select Title ---",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{c9d3f040-1296-443d-9ba0-f85ab5bdf9d0}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{c9d3f040-1296-443d-9ba0-f85ab5bdf9d0}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 )
 }
 ),
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!multipleDropdownField(
 choiceLabels: {"Medical Insurance", "Vision Insurance", "Dental Insurance", "Pension Plan", "Paid Maternity Leave", "Paid Paternity Leave", "Commuter Benifits", "Disability Insurance"},
 choiceValues: {"Medical Insurance", "Vision Insurance", "Dental Insurance", "Pension Plan", "Paid Maternity Leave", "Paid Paternity Leave", "Commuter Benifits", "Disability Insurance"},
 label: "Benifits",
 labelPosition: "ABOVE",
 placeholder: "--- Select Benefits ---",
 value: local!benefits,
 saveInto: local!benefits,
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 ),
 a!columnLayout(
 contents: {
 a!multipleDropdownField(
 choiceLabels: {"Career Growth and Learning", "Work-Life Balance", "Environment Sustainability"},
 choiceValues: {"Career Growth and Learning", "Work-Life Balance", "Environment Sustainability"},
 label: "Commitment",
 labelPosition: "ABOVE",
 placeholder: "--- Select Commitments ---",
 value: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{f56371d2-87b6-4f6e-a0fe-b4eabcaeaa51}'],
 saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{f56371d2-87b6-4f6e-a0fe-b4eabcaeaa51}'],
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
 }
 )
 }
 )
 },
 width: "WIDE"
 )
 }
 )
 },
 style: "NONE",
 shape: "SEMI_ROUNDED",
 padding: "MORE"
 )
 }
 ),
 a!wizardStep(
 label: "Location",
 contents: {
 a!cardLayout(
 contents: {
 a!gridLayout(
 label: "Location",
 labelPosition: "COLLAPSED",
 instructions: "Enter locations for the post job",
 headerCells: {
 a!gridLayoutHeaderCell(label: "Location"),
 a!gridLayoutHeaderCell()
 },
 columnConfigs: {
 a!gridLayoutColumnConfig(width: "NARROW_PLUS"),
 a!gridLayoutColumnConfig(width: "ICON")
 },
 rows: a!forEach(
 items: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'],
 expression: a!gridRowLayout(
 id: fv!index,
 contents: {
 a!textField(
 value: fv!item['recordType!{ba213b7b-b6ea-4bb2-bafc-e0717f2a0e4e}.fields.{f7c76f4f-6417-40e6-b6a3-47a2cf7315e4}'],
 saveInto: fv!item['recordType!{ba213b7b-b6ea-4bb2-bafc-e0717f2a0e4e}.fields.{f7c76f4f-6417-40e6-b6a3-47a2cf7315e4}'],
 characterLimit: 255,
 showCharacterCount: false
 ),
 a!imageField(
 images: a!documentImage(
 document: a!iconIndicator(icon: "REMOVE"),
 altText: "Remove Row" & char(32) & fv!index + 1,
 link: a!dynamicLink(
 value: fv!index,
 saveInto: {
 a!save(
 ri!deletedLocationRecords,
 if(
 a!isNotNullOrEmpty(ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'][save!value]['recordType!{ba213b7b-b6ea-4bb2-bafc-e0717f2a0e4e}.fields.{1f09a335-8419-4f2d-a33a-c2043528b38d}']),
 append(ri!deletedLocationRecords, ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'][save!value]),
 ri!deletedLocationRecords
 )
 ),
 a!save(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'],
 remove(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'],
 save!value
 )
 )
 }
 )
 ),
 size: "ICON"
 )
 }
 )
 ),
 height: "AUTO",
 addRowLink: a!dynamicLink(
 label: "Add Row",
 value: 'recordType!{ba213b7b-b6ea-4bb2-bafc-e0717f2a0e4e}'(),
 saveInto: a!save(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'],
 append(
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}'],
 save!value
 )
 )
 ),
 shadeAlternateRows: false,
 borderStyle: "LIGHT",
 rowHeader: 1
 )
 },
 style: "NONE",
 shape: "SEMI_ROUNDED",
 padding: "MORE"
 )
 }
 )
 },
 primaryButtons: a!buttonWidget(
 label: if(
 ri!isUpdate,
 "Save",
 "Create"
 ),
 submit: true,
 style: "SOLID",
 saveInto: {
 a!save(ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}'],
 tostring(local!benefits))
 },
 showWhen: fv!isLastStep,
 validate: true
 ),
 secondaryButtons: a!buttonWidget(
 label: "Cancel",
 value: true,
 saveInto: ri!cancel,
 submit: true,
 style: "LINK",
 validate: false
 ),
 showButtonDivider: true
)})

chaliki · Answer

a!localVariables(
 local!save,
 a!multipleDropdownField(
 choiceLabels: { 1, 2, 3, 4 },
 choiceValues: { 1, 2, 3, 4 },
 labelPosition: "ABOVE",
 placeholder: "--- Select Experience ---",
 value: local!save,
 saveInto: {
 local!save,
 a!save(ri!save, joinarray(local!save, ";"))
 },
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )
) 
 Please go through that code, hope you will fix your error.

Shubham Aware · Answer

You need to create rule input name called &ldquo;save&rdquo; as string and array.

yasaswinir216812 · Answer

a!multipleDropdownField(
 label: "City",
 placeholder: "select city",
 choiceLabels: { "Mumbai", "Hyb", "Chennai", "westBengal" },
 choiceValues: { "Mumbai", "Hyb", "Chennai", "westBengal" },
 value: ri!city,
 saveInto: ri!city
) 
 
 Can you please go through that code?

Mike Schmitt · Answer

skzahed_09 said: can you please give a brief about what i did wrong and what you did to rectify that error 
 As far as I can see, Shubham's answer merely splits the (plaintext, default concatenated) values your multiple dropdown saves (all at once) into the single record value entry, and splits them on the ";" (semicolon character) to create a "value" that's actually an array (which is what the multiple dropdown expects). 
 This (or some other solution) is necessary here because without doing that, the multiple dropdown is expecting to see an array of values but instead just sees a plaintext string consisting of different "benefit" entries cobbled together, and it has no way of knowing which "benefit" entries that cobbled-together string implies. 
 I have my own thoughts on storing everything as a cobbled-together string and splitting on semicolon, namely that it relies on Appian's inherent default behavior of joining a text array with semicolon (and a space) when concatenating multiple entries, and this might not always be the same. Secondly, it means you're storing an arbitrary amount of text entry data all in single fields - which can work, in limited cases, but definitely has weaknesses. 
 I would suggest, at the very least, if you want to store a package of multiple entries in a single field of a single record row, wrap that array up in a JSON string first, since JSON is a consistent and predictable format maintained independently of Appian. It would work similar to the above code example but would avoid using a parsing system quite as arbitrary as splitting on the semicolon character.

Mike Schmitt · Answer

For example, please consider the following stand-alone approach that replaces the multiple dropdown's behavior that just splits a value on semicolon, with the JSON approach: 
 a!localVariables(
 
 local!selection: "",
 /* this will serve as the stand-in for the record field:
 ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}']
 */
 
 local!benefits: { "Medical Insurance", "Vision Insurance", "Dental Insurance", "Pension Plan", "Paid Maternity Leave", "Paid Paternity Leave", "Commuter Benifits", "Disability Insurance" },
 
 a!multipleDropdownField(
 choiceLabels: local!benefits,
 choiceValues: local!benefits,
 label: "Benifits",
 labelPosition: "ABOVE",
 placeholder: "--- Select Benefits ---",
 value: a!fromJson(a!defaultValue(local!selection, "[]")),
 /*value: if(
 a!isNullOrEmpty( local!selection ),
 local!selection,
 split( local!selection, "; " )
 ),*/
 saveInto: {
 a!save(
 local!selection,
 a!toJson(save!value)
 )
 },
 searchDisplay: "AUTO",
 required: true,
 validations: {}
 )

)

Error in Multiple Dropdown

Top Replies