how to store array of files in appian

I'm  trying to store array of files in database since it does not picks blob as a datatype any work around would be much appreciated.

  Discussion posts and replies are publicly visible

Parents Reply Children
  • Yes I have used the file upload for the multi-doc. I am able to upload multiple files in a local array and display on the screen I am having difficulty to upload it into database. I am sharing my code might help you understand what I have done and then you'll have a clear understanding of what to recommend to me. Following is the code.

    /*the file upload part*/
    a!fileUploadField( 
            label: "UPLOAD FILE",
            labelPosition: "ADJACENT",
            target: cons!P_XYZ_POINTS_TO_DOCS_FOLDER,
            maxSelections: 10,
            value:  
            /*local!docsList*/
            /*ri!userRequest['recordType!{20eafdce-4cae-46cf-982b-f8f20745d009}P_XYZ_REQUEST.fields.{43660766-6686-47e3-b5b2-1035686940b5}requesteddoc']*/
            local!docsList,
            saveInto: 
            /*local!docsList*/
            /*ri!userRequest['recordType!{20eafdce-4cae-46cf-982b-f8f20745d009}P_XYZ_REQUEST.fields.{43660766-6686-47e3-b5b2-1035686940b5}requesteddoc']*/
            local!docsList,
            validations: {}
          ),
    /*the button that will upload in recordtype.*/
    a!buttonWidget(
                label: "UPLOAD",
                value: local!docsList,
                saveInto: /*a!save(*/
                  /*ri!userRequest['recordType!{20eafdce-4cae-46cf-982b-f8f20745d009}P_XYZ_REQUEST.fields.{43660766-6686-47e3-b5b2-1035686940b5}requesteddoc'],*/
                  /*save!value*/
                /*)*/
                a!forEach(
                  items: local!docsList,
                  expression: a!save(
                    ri!docs['recordType!{10edbd5a-0ae8-47a9-bda2-f80cd3efc550}P_XYZ_DOC.fields.{ad42aed6-1664-4257-97f8-1c06e7f5604b}reqDoc'],
                    save!value
                  )
                ),
                style: "NORMAL"
              )