add row link giving error while clicking

Question

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

Richard Michaelis · Answer

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
) or Scenario b) 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()
 )
 )
 )
 }
)
,

add row link giving error while clicking

Top Replies