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
Hi buddy welcome to the forumFor inserting code, please use the following feature:This supports the readability very much
Your code is really hard to read and understand.
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?
To the content:my personal basic rule for using "value" and "saveinto" as part of save logics:Scenario a)
a!dynamicLink( value: "myExampleValueString", saveinto: ri!variableToSaveInto )
a!dynamicLink( saveInto:{ a!save( target:ri!variableToSaveInto, value: "myExampleValueString" ) } )
you currently have a wild mix of Value and saveintoin my mind.I recommend not using the "save!value" with functions. Especially the older ones without a! (like append())have trouble on regular basis to deal with save!value properly.So try it with the second option
addRowlink: a!dynamicLink( label: "Add Row", saveInto: { a!save( target: ri!bookingFSSC, value: append( ri!bookingFSSC, '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() ) ) ) } ) ,
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.