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.
Discussion posts and replies are publicly visible
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?
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: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}benifits'], saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}benifits'], searchDisplay: "AUTO", required: true, validations: {} ) } ),This was my code for the particular multiple dropdown field i was facing issues.Is there anything wrong in the code ?
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: {} ) } ) } )
There was this error saying there was an unmatched close bracket i tried but all the closed brackets were correctly close. Is there any other error iam missing.
You've missed one of the brace, try to debug checking each brace's scope
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: {} ) } ) } )
I did try the process you mentioned but unfortunately the error still exists.
Can you share full code here.
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}IP Post Job.fields.{c08fdd20-8d7d-4d7b-87b9-5b77cddf1ae0}companyName'], saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.fields.{c08fdd20-8d7d-4d7b-87b9-5b77cddf1ae0}companyName'], 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}IP Post Job.fields.{2a4a6efb-1880-4885-9769-657d9a0d3d7a}skillsNeeded'], saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.fields.{2a4a6efb-1880-4885-9769-657d9a0d3d7a}skillsNeeded'], 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}IP Post Job.fields.{3233cbf5-b9ea-425b-89de-87ca9f43de61}minExperience'], saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.fields.{3233cbf5-b9ea-425b-89de-87ca9f43de61}minExperience'], 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}IP Post Job.fields.{25d8c2b9-a722-4827-9a7d-576007cf1ec8}jobType'], saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.fields.{25d8c2b9-a722-4827-9a7d-576007cf1ec8}jobType'], 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}IP Post Job.fields.{a5c53423-da0f-45a2-9bd2-2632c0d6fd2d}remote'], saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.fields.{a5c53423-da0f-45a2-9bd2-2632c0d6fd2d}remote'], 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}IP Post Job.fields.{209d8ba4-7627-472e-84a3-92a0e38177c0}industry'], saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.fields.{209d8ba4-7627-472e-84a3-92a0e38177c0}industry'], 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}IP Post Job.fields.{deb3b8e4-e17f-4a87-b5eb-3dc96637c3fa}jobFunction'], saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.fields.{deb3b8e4-e17f-4a87-b5eb-3dc96637c3fa}jobFunction'], 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}IP Post Job.fields.{c9d3f040-1296-443d-9ba0-f85ab5bdf9d0}title'], saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.fields.{c9d3f040-1296-443d-9ba0-f85ab5bdf9d0}title'], 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: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}benifits'], saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.fields.{0774c72a-97f4-4ec1-a160-b5eaba2af359}benifits'], 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}IP Post Job.fields.{f56371d2-87b6-4f6e-a0fe-b4eabcaeaa51}commitment'], saveInto: ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.fields.{f56371d2-87b6-4f6e-a0fe-b4eabcaeaa51}commitment'], 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}IP Post Job.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}location'], expression: a!gridRowLayout( id: fv!index, contents: { a!textField( value: fv!item['recordType!{ba213b7b-b6ea-4bb2-bafc-e0717f2a0e4e}IP Location.fields.{f7c76f4f-6417-40e6-b6a3-47a2cf7315e4}location'], saveInto: fv!item['recordType!{ba213b7b-b6ea-4bb2-bafc-e0717f2a0e4e}IP Location.fields.{f7c76f4f-6417-40e6-b6a3-47a2cf7315e4}location'], 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}IP Post Job.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}location'][save!value]['recordType!{ba213b7b-b6ea-4bb2-bafc-e0717f2a0e4e}IP Location.fields.{1f09a335-8419-4f2d-a33a-c2043528b38d}locationId']), append(ri!deletedLocationRecords, ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}location'][save!value]), ri!deletedLocationRecords ) ), a!save( ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}location'], remove( ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}location'], save!value ) ) } ) ), size: "ICON" ) } ) ), height: "AUTO", addRowLink: a!dynamicLink( label: "Add Row", value: 'recordType!{ba213b7b-b6ea-4bb2-bafc-e0717f2a0e4e}IP Location'(), saveInto: a!save( ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}location'], append( ri!record['recordType!{7d604f1b-53e2-4718-9165-019b6ea8667a}IP Post Job.relationships.{8a15ce41-acd6-46bc-b355-1fcc53a222db}location'], 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)This is my full code.
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 )})
"Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = 4QM6U] : An array of components cannot contain a form layout, wizard layout, or column layout. Received a wizard layout at index 1."
This was the error that i faced after i ran the above code.
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 )
Yes this code worked perfectly. Thank you for your guidance. If you don't mind can you please give a brief about what i did wrong and what you did to rectify that error.
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.