hi all,,, i have an editable grid interface in which when i choose a dropdown value for "subsidiary" field, the other 2 fields(businessunit and objectamount) will get autopopulated values..i need to add multiple rows also,,but when clicking on add row button,,iam getting error message like this:
Expression evaluation error [evaluation ID = a5ba0:92723] in rule 'i2cemea_editablegridbookingfssc' (called by rule 'i2cemea_genericwriteoffform') : An error occurred while executing a save: Expression evaluation error at function 'append' [line 123]: Insert is not supported for I2CEMEA FSSC Booking Info types
CODE:
a!localVariables( local!Subsidiary: if( a!isNullOrEmpty(ri!companyCode), 'recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account'(), rule!I2CEMEA_QR_getMWGLAccount(companyCode: ri!companyCode,processType: ri!processType).data ), local!bussinessUnitorObjectAccount: if( a!isNullOrEmpty( ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{1c7cbdcb-b142-4683-8ab5-84e21b870dff}subsidiary'] ), 'recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account'(), rule!I2CEMEA_QR_getMWGLAccount( Id: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{1c7cbdcb-b142-4683-8ab5-84e21b870dff}subsidiary'] ).data ), a!gridLayout( headerCells: { a!gridLayoutHeaderCell(label: "Subsidiary"), a!gridLayoutHeaderCell(label: "Object Account"), a!gridLayoutHeaderCell(label: "Business Unit"), a!gridLayoutHeaderCell(label: "Amount"), a!gridLayoutHeaderCell(label: "Profit Center/Franchise") }, columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 3), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 3), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 3), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 3), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 3) }, rows: a!gridRowLayout( contents: { a!dropdownField( choiceLabels: local!Subsidiary['recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{90fa0177-5daf-4fea-af31-9ec00aa0fd09}subsidiary'], choiceValues: local!Subsidiary['recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{aff2fcf2-4cc6-4c20-a751-e485a96e63b0}id'], label: "", placeholder: "--Select Subsidiary--", value: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{1c7cbdcb-b142-4683-8ab5-84e21b870dff}subsidiary'], saveInto: { ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{1c7cbdcb-b142-4683-8ab5-84e21b870dff}subsidiary'], a!save( ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{0443f6fa-d1cb-4935-aeb7-a81c3d9346a1}objectAccount'], save!value ), a!save( ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{ecb49374-f33c-4a0d-8732-e2bff5a632b2}businessUnit'], save!value ) }, required: true, requiredMessage: "Please Enter Subsidiary" ), a!dropdownField( choiceLabels: local!bussinessUnitorObjectAccount['recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{08d1c248-83de-42ca-8a06-c09bb4d8329c}objectAccount'], choiceValues: local!bussinessUnitorObjectAccount['recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{aff2fcf2-4cc6-4c20-a751-e485a96e63b0}id'], label: "", placeholder: "--Select Object Account--", value: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{0443f6fa-d1cb-4935-aeb7-a81c3d9346a1}objectAccount'], saveInto: { ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{0443f6fa-d1cb-4935-aeb7-a81c3d9346a1}objectAccount'], a!save( ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{ecb49374-f33c-4a0d-8732-e2bff5a632b2}businessUnit'], save!value ) }, required: true, requiredMessage: "Please Select Object Account" ), a!dropdownField( choiceLabels: local!bussinessUnitorObjectAccount['recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{9145b4cf-971d-4eee-aa6d-475f715df38e}businessUnit'], choiceValues: local!bussinessUnitorObjectAccount['recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{aff2fcf2-4cc6-4c20-a751-e485a96e63b0}id'], label: "", placeholder: "--Select Business Unit--", value: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{ecb49374-f33c-4a0d-8732-e2bff5a632b2}businessUnit'], saveInto: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{ecb49374-f33c-4a0d-8732-e2bff5a632b2}businessUnit'], required: true, requiredMessage: "Please Enter Business Unit" ), a!textField( label: "", value: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{40f6b35c-19a5-4ed0-ba7e-6e22266c73df}amount'], saveInto: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{40f6b35c-19a5-4ed0-ba7e-6e22266c73df}amount'], characterLimit: cons!I2CEMEA_CONS_CHARACTER_LIMIT_16, validations: if( rule!I2CEMEA_validationNumericalValue( value: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{40f6b35c-19a5-4ed0-ba7e-6e22266c73df}amount'] ), "", "Please enter numerical value " ) ), a!textField( label: "", value: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{2639569a-0373-4f0f-a571-56978697c428}profitCenterFranchise'], saveInto: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{2639569a-0373-4f0f-a571-56978697c428}profitCenterFranchise'], characterLimit: cons!I2CEMEA_CONS_CHARACTER_LIMIT_20 ) } ), addRowlink: a!dynamicLink( label: "Add Row", value: 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info'( 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{d7b2b208-4556-4cb0-9c3f-4b7b725e3084}fsscId': null(), 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{1c7cbdcb-b142-4683-8ab5-84e21b870dff}subsidiary': null(), 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{0443f6fa-d1cb-4935-aeb7-a81c3d9346a1}objectAccount': null(), 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{ecb49374-f33c-4a0d-8732-e2bff5a632b2}businessUnit': null(), 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{40f6b35c-19a5-4ed0-ba7e-6e22266c73df}amount': null(), 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{2639569a-0373-4f0f-a571-56978697c428}profitCenterFranchise': null() ), saveInto: { a!save( ri!bookingFSSC, append(ri!bookingFSSC,save!value) ) } ), rowHeader: 1 ))
Discussion posts and replies are publicly visible
Typically you would want to display multiple rows of data, but I do not see any a!foreach() in that "rows" parameter.
Then, is that rule input a multiple aka a list?
Hi Stefan,
I have modified the code again but getting error while clicking on add row button,,attached the code and error screenshot ...
a!localVariables( local!Subsidiary: if( a!isNullOrEmpty(ri!companyCode), 'recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account'(), rule!I2CEMEA_QR_getMWGLAccount(companyCode: ri!companyCode,processType: ri!processType).data ), local!bussinessUnitorObjectAccount: { 'recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account'() }, a!gridLayout( headerCells: { a!gridLayoutHeaderCell(label: "Subsidiary"), a!gridLayoutHeaderCell(label: "Object Account"), a!gridLayoutHeaderCell(label: "Business Unit"), a!gridLayoutHeaderCell(label: "Amount"), a!gridLayoutHeaderCell(label: "Profit Center/Franchise"), }, columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 3), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 3), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 3), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 3), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight: 3), }, rows: a!forEach( items:ri!bookingFSSC, expression:a!gridRowLayout( contents: { a!dropdownField( label: "", placeholder: "--Select Subsidiary--", choiceLabels: local!Subsidiary['recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{90fa0177-5daf-4fea-af31-9ec00aa0fd09}subsidiary'], choiceValues: local!Subsidiary['recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{aff2fcf2-4cc6-4c20-a751-e485a96e63b0}id'], value: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{1c7cbdcb-b142-4683-8ab5-84e21b870dff}subsidiary'][fv!index], saveInto: { ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{1c7cbdcb-b142-4683-8ab5-84e21b870dff}subsidiary'][fv!index], a!save( ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{0443f6fa-d1cb-4935-aeb7-a81c3d9346a1}objectAccount'][fv!index], save!value ), a!save( ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{ecb49374-f33c-4a0d-8732-e2bff5a632b2}businessUnit'][fv!index], save!value ), a!save( local!bussinessUnitorObjectAccount, a!update( data:local!bussinessUnitorObjectAccount, index:fv!index, value:if( a!isNullOrEmpty( ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{1c7cbdcb-b142-4683-8ab5-84e21b870dff}subsidiary'][fv!index]), 'recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account'(), rule!I2CEMEA_QR_getMWGLAccount( Id: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{1c7cbdcb-b142-4683-8ab5-84e21b870dff}subsidiary'][fv!index] ).data ) ) ) }, required: true, requiredMessage: "Please Enter Subsidiary", ), a!dropdownField( label: "", placeholder: "--Select Object Account--", choiceLabels: local!bussinessUnitorObjectAccount['recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{08d1c248-83de-42ca-8a06-c09bb4d8329c}objectAccount'][fv!index], choiceValues: local!bussinessUnitorObjectAccount['recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{aff2fcf2-4cc6-4c20-a751-e485a96e63b0}id'][fv!index], value: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{0443f6fa-d1cb-4935-aeb7-a81c3d9346a1}objectAccount'][fv!index], saveInto: { ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{0443f6fa-d1cb-4935-aeb7-a81c3d9346a1}objectAccount'][fv!index], a!save( ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{ecb49374-f33c-4a0d-8732-e2bff5a632b2}businessUnit'][fv!index], save!value ) }, required: true, requiredMessage: "Please Select Object Account", ), a!dropdownField( label: "", placeholder: "--Select Business Unit--", choiceLabels: local!bussinessUnitorObjectAccount['recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{9145b4cf-971d-4eee-aa6d-475f715df38e}businessUnit'][fv!index], choiceValues: local!bussinessUnitorObjectAccount['recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{aff2fcf2-4cc6-4c20-a751-e485a96e63b0}id'][fv!index], value: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{ecb49374-f33c-4a0d-8732-e2bff5a632b2}businessUnit'][fv!index], saveInto: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{ecb49374-f33c-4a0d-8732-e2bff5a632b2}businessUnit'][fv!index], required: true, requiredMessage: "Please Enter Business Unit", ), a!textField( label: "", value: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{40f6b35c-19a5-4ed0-ba7e-6e22266c73df}amount'][fv!index], saveInto: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{40f6b35c-19a5-4ed0-ba7e-6e22266c73df}amount'][fv!index], characterLimit: cons!I2CEMEA_CONS_CHARACTER_LIMIT_16, validations: if( rule!I2CEMEA_validationNumericalValue( value: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{40f6b35c-19a5-4ed0-ba7e-6e22266c73df}amount'][fv!index] ), "", "Please enter numerical value ", ) ), a!textField( label: "", value: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{2639569a-0373-4f0f-a571-56978697c428}profitCenterFranchise'][fv!index], saveInto: ri!bookingFSSC['recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{2639569a-0373-4f0f-a571-56978697c428}profitCenterFranchise'][fv!index], characterLimit: cons!I2CEMEA_CONS_CHARACTER_LIMIT_20, ), } ) ), addRowlink: a!dynamicLink( label: "Add Row", value: 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info'( 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{d7b2b208-4556-4cb0-9c3f-4b7b725e3084}fsscId': null(), 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{1c7cbdcb-b142-4683-8ab5-84e21b870dff}subsidiary': null(), 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{0443f6fa-d1cb-4935-aeb7-a81c3d9346a1}objectAccount': null(), 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{ecb49374-f33c-4a0d-8732-e2bff5a632b2}businessUnit': null(), 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{40f6b35c-19a5-4ed0-ba7e-6e22266c73df}amount': null(), 'recordType!{0fbf9c6e-1688-429c-8e78-65237aa90cf4}I2CEMEA FSSC Booking Info.fields.{2639569a-0373-4f0f-a571-56978697c428}profitCenterFranchise': null() ), saveInto: { a!save( ri!bookingFSSC, append(ri!bookingFSSC,save!value) ), a!save( local!bussinessUnitorObjectAccount, a!update( data:local!bussinessUnitorObjectAccount, index:length(ri!bookingFSSC), value: 'recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account'( 'recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{08d1c248-83de-42ca-8a06-c09bb4d8329c}objectAccount': {}, 'recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{aff2fcf2-4cc6-4c20-a751-e485a96e63b0}id': {} ) ) ) } ), rowHeader: 1 ) )
ruleinput "bookingFSSC" is array type
The error message shows pretty clear what the issue is.while add row link
This saveinto is the core of the errormessage a!save( local!bussinessUnitorObjectAccount, a!update( data:local!bussinessUnitorObjectAccount, index:length(ri!bookingFSSC), value: 'recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account'( 'recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{08d1c248-83de-42ca-8a06-c09bb4d8329c}objectAccount': {}, 'recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account.fields.{aff2fcf2-4cc6-4c20-a751-e485a96e63b0}id': {} ) ) )
I have the feeling that the "index" at the end of lines 71/72 does not make sense.