• State Suggested Answer
  • Replies 7 replies
  • Answers 1 answer
  • Subscribers 12 subscribers
  • Views 525 views
  • Users 0 members are here
Related Discussions
Home » Discussions » User Interface

add row link giving error while clicking

salinis
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 Senior Developer

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

Reply
  • 0
    Certified Senior Developer

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

Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.