add row link giving error while clicking

Certified Associate Developer

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

Parents
  • 0
    Certified Lead Developer

    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?

  • 0
    Certified Associate Developer
    in reply to Stefan Helzle

    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

  • 0
    Certified Senior Developer
    in reply to salinis

    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': {}
                )
              )
            )
            
    


    your choiceLabels and choiceValues of the dropdown are referencing the local.
    You are doing an update on that local, which updates the Id. So you have an ID value für your choice values but still no label..
    The question would be: why do you want to update the id at and "addrowlink"?

Reply
  • 0
    Certified Senior Developer
    in reply to salinis

    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': {}
                )
              )
            )
            
    


    your choiceLabels and choiceValues of the dropdown are referencing the local.
    You are doing an update on that local, which updates the Id. So you have an ID value für your choice values but still no label..
    The question would be: why do you want to update the id at and "addrowlink"?

Children
No Data