An error occurred while evaluating expression: record['recordType!****.fields.{***}files']:AC!record.files (Expression evaluation error: RECORD NAME can only be indexed into using square brackets or the index function) (Data Outputs)

hello everyone 

I have this issue while testing my process Model .how can i solve it please ! 

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    COuld you share your code? seems that you are indexing the record type in a wrong way

  • a!localVariables(
      local!file,
      local!success,
    
      a!formLayout(
        label: "Create account",
        contents: {
          a!cardLayout(
            contents: {
              a!sideBySideLayout(
                items: {
                  a!sideBySideItem(
                    item: a!richTextDisplayField(
                      labelPosition: "COLLAPSED",
                      value: {
                        "Home ",
                        a!richTextIcon(
                          icon: "chevron-right"
                        ),
                        " Create account",
                        char(10),
                        a!richTextItem(
                          text: {
                            " !"
                          },
                          size: "LARGE"
                        )
                      }
                    )
                  )
                },
                alignVertical: "MIDDLE"
              )
            },
            height: "AUTO",
            style: "#8A220C",
            padding: "MORE",
            marginBelow: "NONE",
            showBorder: false
          ),
          a!columnsLayout(
            columns: {
              a!columnLayout(
                contents: {
                  a!textField(
                    label: "Nom ",
    
                    labelPosition: "ABOVE",
                    instructions: "",
                    helpTooltip: "",
                    placeholder: "donner votre nom ",
                    value: ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{0399793e-a303-4fd2-8a2f-6136b4bbdf6e}Nom'],
                    saveInto: ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{0399793e-a303-4fd2-8a2f-6136b4bbdf6e}Nom'],
                    refreshAfter: "UNFOCUS",
                    characterLimit: 4000,
                    required: true(),
                    align: "LEFT",
                    inputPurpose: "NAME"
                  ),
                  a!checkboxField(
                    choiceLabels: {"Merci de donner votre nom correct, similaire à celui de la carte d'identité nationale.
    
    
    
    
    
    
    "},
    choiceValues: {1},
    label: "",
    labelPosition: "",
    saveInto: {},
    validations: {}
                  ),
                  a!textField(
                    label: "Prénom ",
                    labelPosition: "ABOVE",
                    instructions: "",
                    helpTooltip: "",
                    placeholder: "donner votre aprenom",
                    value: ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{d3d0014e-232c-49de-a780-8c9ce646de70}prenom'],
                    saveinto: {
                      ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{d3d0014e-232c-49de-a780-8c9ce646de70}prenom']
              
                    },
                    /*cons!PBY_STORE_MAIL},*/
                    characterLimit: 4000,
                    required: true()
                  ),
                  a!integerField(
                    label: "Numero Portable ",
                    labelPosition: "ABOVE",
                    placeholder: "donner votre numéro de téléphone",
                    value: ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{34b4df1b-b528-4766-9de7-a42bf38ed3c4}NumeroPortable'],
                    saveInto: ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{34b4df1b-b528-4766-9de7-a42bf38ed3c4}NumeroPortable'],
                    required: true()
                  ),
                  a!textField(
                    label: "Email ",
                    labelPosition: "ABOVE",
                    instructions: "",
                    helpTooltip: "",
                    placeholder: "donner votre adresse email",
                    value: ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{09ad7c2a-2301-40cd-a353-6fc234434574}Mail'],
                    saveInto: {ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{09ad7c2a-2301-40cd-a353-6fc234434574}Mail']},
                    /*cons!PBY_STORE_MAIL},*/
                    characterLimit: 4000,
                    required: true()
                  ),
                  a!dateField(
                    label: "Date De Naissance",
                    labelPosition: "ABOVE",
                    value: ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{ea2a0583-3445-4dd1-b9bf-b090658729ce}DateDeNaissance'],
                    saveInto: ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{ea2a0583-3445-4dd1-b9bf-b090658729ce}DateDeNaissance'],
                    required: true
                  ),
    
                  a!textField(
                    label: "Nationalite",
                    labelPosition: "ABOVE",
                    value: ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{b649be61-fdb6-4034-b24a-0cdf9d874e50}Nationalite'],
                    saveInto: ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{b649be61-fdb6-4034-b24a-0cdf9d874e50}Nationalite'],
                    characterLimit: 255,
                    required: true()
                  ),
                  /*a!textField(*/
                  /*label: "Sexe",*/
                  /*labelPosition: "ABOVE",*/
                  /*value: ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{42ae35ee-dc97-411c-bcb7-4b0aac8ac8ca}Sexe'],*/
                  /*saveInto: ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{42ae35ee-dc97-411c-bcb7-4b0aac8ac8ca}Sexe'],*/
                  /*characterLimit: 255,*/
                  /*required: false*/
                  /*),*/
                  a!sectionLayout(
                    contents:{
    
                      a!columnsLayout(
                        a!forEach(
                          items:local!file,
                          expression: a!columnLayout(
                            contents: {
                              if(
                                a!isNullOrEmpty(local!file),
                                a!richTextDisplayField(
                                  value: {
                                    a!richTextItem(
                                      text: " aucune documents n'est téléchargé"
                                    )
    
    
                                  }
                                ),
                                a!cardLayout(
                                  contents: {
                                    a!imageField(
                                      images: a!documentImage( 
    
                                        document: fv!item
                                      )
                                    )
    
                                  }
                                )
                              )
                            }
                          )
                        )
    
                      )
                    },
                  ),
                  a!fileUploadField(
                    label: "justificatif de domicile",
                    labelPosition: "ABOVE",
                    value: local!file,
    
                    saveinto: {
                      local!file, ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{33974cb9-8489-4709-afd2-d96a35ec07c6}files']
    
                        /*if(ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{33974cb9-8489-4709-afd2-d96a35ec07c6}files'])*/
                        
                      
    
                    },
                    
                    target: cons!PBYDocs,
                    required: true,
                    /*validations: a!localVariables(*/
                      /*local!invalidExtensions: difference(upper(fv!files.extension), "PDF"),*/
                      /*if(*/
                        /*length(local!invalidExtensions) > 0, */
                        /*"le type des fichiers doit etre en PDF. Supprimer: " & */
                        /*index(fv!files, "name", wherecontains(local!invalidExtensions, upper(fv!files.extension)), {}), */
                        /*""*/
                      /*)*/
                    /*),*/
    
                    placeholder: "ajouter vos documents ici",
                    /*target: fv!row['recordType!PMSO Speaker.fields.folder'],*/
                    
                  ),
                  a!cardLayout(
                    contents: {
                      a!richTextDisplayField(
                        labelPosition: "COLLAPSED",
                        value: {
                          a!richTextIcon(
                            icon: "info-circle",
                            color: "ACCENT"
                          ),
                          " Vous devez télécharger une version .PDF lisible d'un document fournissant une preuve de votre nom légal et de votre domicile actuelle !"
    
                        }
                      )
                    },
                    height: "AUTO",
                    style: "#f3f5f9",
                    padding: "STANDARD",
                    marginBelow: "STANDARD"
                  )
                },
                width: "MEDIUM"
              ),
              a!columnLayout(contents: {
                a!columnsLayout(
                  columns: {
                    a!columnLayout(
                      contents: {a!cardLayout(
                        contents: {
                          a!sideBySideLayout(
                            items: {
                              a!sideBySideItem(
                                item: a!stampField(
                                  labelPosition: "",
                                  text: "1",
                                  backgroundColor: if(
                                    not(isnull(ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{0399793e-a303-4fd2-8a2f-6136b4bbdf6e}Nom'])),
                                    "#8A220C", 
                                    "#cccccc" 
                                  ),
                                  size: "TINY"
                                ),
                                width: "MINIMIZE"
                              ),
                              a!sideBySideItem(
                                item: a!richTextDisplayField(
                                  labelPosition: "COLLAPSED",
                                  value: {
                                    a!richTextItem(
                                      text: {
                                        "Nom et prénon valide"
                                      },
                                      color: "STANDARD",
                                      size: "MEDIUM"
                                    )
                                  }
                                )
                              )
                            },
                            alignVertical: "MIDDLE",
                            marginBelow: "STANDARD"
                          ),
    
                          a!cardLayout(
                            contents: {},
                            height: "AUTO",
                            padding: "EVEN_LESS",
                            marginBelow: "NONE",
                            showBorder: false
                          ),
                          a!sideBySideLayout(
                            items: {
                              a!sideBySideItem(
                                item: a!stampField(
                                  labelPosition: "COLLAPSED",
                                  text: "2",
                                  backgroundColor: if(
                                    not(isnull(ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{ea2a0583-3445-4dd1-b9bf-b090658729ce}DateDeNaissance'])),
                                    "#8A220C", 
                                    "#cccccc" 
                                  ),
                                  contentColor: "STANDARD",
                                  size: "TINY"
                                ),
                                width: "MINIMIZE"
                              ),
                              a!sideBySideItem(
                                item: a!richTextDisplayField(
                                  labelPosition: "COLLAPSED",
                                  value: {
                                    a!richTextItem(
                                      text: {
                                        "date de naissance valide"
                                      },
                                      color: "STANDARD",
                                      size: "MEDIUM"
                                    )
                                  }
                                )
                              )
                            },
                            alignVertical: "MIDDLE",
                            marginBelow: "STANDARD"
                          ),
                          a!cardLayout(
                            contents: {},
                            height: "AUTO",
                            padding: "EVEN_LESS",
                            marginBelow: "NONE",
                            showBorder: false
                          ),
                          a!sideBySideLayout(
                            items: {
                              a!sideBySideItem(
                                item: a!stampField(
                                  labelPosition: "COLLAPSED",
                                  text: "3",
                                  backgroundColor: if(
                                    not(isnull(ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{34b4df1b-b528-4766-9de7-a42bf38ed3c4}NumeroPortable'])),
                                    "#8A220C",
                                    "#cccccc" 
                                  ),
                                  contentColor: "STANDARD",
                                  size: "TINY"
                                ),
                                width: "MINIMIZE"
                              ),
                              a!sideBySideItem(
                                item: a!richTextDisplayField(
                                  labelPosition: "COLLAPSED",
                                  value: {
                                    a!richTextItem(
                                      text: {
                                        "vérifier votre boite mail "
                                      },
                                      color: "STANDARD",
                                      size: "MEDIUM"
                                    )
                                  }
                                )
                              )
                            },
                            alignVertical: "MIDDLE",
                            marginBelow: "STANDARD"
                          ),
                          a!cardLayout(
                            contents: {},
                            height: "AUTO",
                            padding: "EVEN_LESS",
                            marginBelow: "NONE",
                            showBorder: false
                          ),
                          a!sideBySideLayout(
                            items: {
                              a!sideBySideItem(
                                item: a!stampField(
                                  labelPosition: "COLLAPSED",
                                  text: "4",
                                  backgroundColor: if(
                                    not(a!isNullOrEmpty(local!file)), 
                                    "#8A220C", 
                                    "#cccccc" 
                                  ),
                                  contentColor: "STANDARD",
                                  size: "TINY"
                                ),
                                width: "MINIMIZE"
                              ),
                              a!sideBySideItem(
                                item: a!richTextDisplayField(
                                  labelPosition: "COLLAPSED",
                                  value: {
                                    a!richTextItem(
                                      text: {
                                        "vos documents sont bien téléchargés",
                                        a!richTextIcon(
                                          icon: "grin-beam"
                                        )
                                      },
                                      color: "STANDARD",
                                      size: "MEDIUM"
                                    )
                                  }
                                )
                              )
                            },
                            alignVertical: "MIDDLE",
                            marginBelow: "STANDARD"
                          )
                        },
                        height: "AUTO",
                        padding: "NONE",
                        marginBelow: "NONE",
                        showBorder: false
                      )},
                      width: "MEDIUM"
                    )
                  }
                )
              })
            }
          )
        },
        buttons: a!buttonLayout(
          primaryButtons: {
            a!buttonWidget(
              label: if(ri!isUpdate, "Save", "inscrire"),
              submit: true,
              style: "SOLID",
              validate: true,
              color: "#8A220C",
              onSuccess: a!save(
                local!success, 
                a!submitUploadedFiles(),
                a!save(
                  ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{33974cb9-8489-4709-afd2-d96a35ec07c6}files'],
                  fields: {
                    files: local!file
                  }
                )
              ),        
              /*onSuccess: a!save(*/
              /*local!success, */
              /*a!submitUploadedFiles()*/
              /*),*/
    
              onError: a!save(
                local!success, 
                false
              )
            )
          },
          secondaryButtons: {
            a!buttonWidget(
              label: "Annuler",
              value: true,
              saveInto: ri!cancel,
              submit: true,
              style: "OUTLINE",
              validate: false(),
              color: "#8A220C"
            )
          }
        ),
        skipAutoFocus: false
      ))

    Thanks for your response. While testing the interface, I've confirmed that all fields in my record are successfully updated with the user's input. However, when I test my process model, it doesn't seem to function as expected.

  • 0
    Certified Lead Developer
    in reply to yassyass
    doesn't seem to function as expected

    What exactly do you mean with this?

    BTW, is that interface a process start form? If yes, why do you use a!submitUploadedFiles()?

  • no it's not the start of my process model , the start of my process model is a home page . this interface is used as the second user input task in my process model

  • 0
    Certified Lead Developer
    in reply to yassyass

    OK. Then submitUploadedFiles also makes no sense. This function is meant to support file upload OUTSIDE a process context.

  • Thanks for answering me! But even if I put it as a comment in my code, I still have the same error.

  • 0
    Certified Lead Developer
    in reply to yassyass

    The error message indicates a problem in the node configuration on data outputs, rather than in the interface code.

  • Does this mean there is a configuration problem in the process model?

  • 0
    Certified Lead Developer
    in reply to yassyass

    I assume. AC!record.files should more look like AC!record[recordtype!YOUR_TYPE.fields.files].

    Check the documentation on how to reference record fields: https://docs.appian.com/suite/help/24.1/reference-records.html

  • If the problem were related to referencing record  in my interface code, then it would show an error while executing the interface. However, this is not the case. The error only occurs when I click on the button 'inscrire' in my process model. Therefore, I believe the problem lies within the process model.

    Otherwise, thank you for the documentation.

  • 0
    Certified Senior Developer
    in reply to yassyass

    Issue is looking like in the below code as you can see, save inside another save function is not valid:

    a!save(
    local!success,
    a!submitUploadedFiles(),
    a!save(
    ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{33974cb9-8489-4709-afd2-d96a35ec07c6}files'],
    fields: {
    files: local!file
    }
    )
    ),

  •      /*onSuccess: a!save(*/
                /*local!success, */
                /*a!submitUploadedFiles(),*/
                /*a!save(*/
                  /*ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{33974cb9-8489-4709-afd2-d96a35ec07c6}files'],*/
                  /*fields: {*/
                    /*files: local!file*/
                  /*}*/
                /*)*/
              /*),        */
              /*onSuccess: a!save(*/
              /*local!success, */
              /*a!submitUploadedFiles()*/
              /*),*/
    /**/
              /*onError: a!save(*/
                /*local!success, */
                /*false*/
              /*)*/
            )
    i put all this part as a comment in my interface and i still have the same error

Reply
  •      /*onSuccess: a!save(*/
                /*local!success, */
                /*a!submitUploadedFiles(),*/
                /*a!save(*/
                  /*ri!record['recordType!{72596258-c9fb-4f4f-a5b7-d2eeb5d31c00}PBY accounts.fields.{33974cb9-8489-4709-afd2-d96a35ec07c6}files'],*/
                  /*fields: {*/
                    /*files: local!file*/
                  /*}*/
                /*)*/
              /*),        */
              /*onSuccess: a!save(*/
              /*local!success, */
              /*a!submitUploadedFiles()*/
              /*),*/
    /**/
              /*onError: a!save(*/
                /*local!success, */
                /*false*/
              /*)*/
            )
    i put all this part as a comment in my interface and i still have the same error

Children
No Data