Skip to main content
September 23, 2021
Question

How to display the attachments stored in a folder in interface.

  • September 23, 2021
  • 8 replies
  • 0 views

Hi everyone,

I have the requirement to display the attachments stored in a folder, whose unique names are present in database. I would like to provide a link to user in such a way that the name is displayed in the interface and when user clicks over it, the attachment gets downloaded.

Thank You.

    8 replies

    mikes0011
    Brainy
    September 23, 2021

    Here's an example interface that assumes you're starting with a folder / folder ID containing documents, and displays each one as a consecutive link in a single Rich Text Display Field - this can be rearranged in any number of different ways depending on your particular need.

    a!localVariables(
      
      local!documents: getdocumentsfromfolder(
        rootFolder: ri!folder,
        recursiveSearch: false()
      ),
      
      a!boxLayout(
        label: "Documents",
        contents: {
          a!richTextDisplayField(
            value: {
              a!forEach(
                local!documents,
                {
                  a!richTextItem(
                    text: {
                      a!richTextIcon(icon: "file-o"),
                      " ",
                      document(fv!item, "name"),
                      ".",
                      document(fv!item, "extension")
                    },
                    link: a!documentDownloadLink(
                      document: fv!item
                    )
                  ),
                  char(10)
                }
              )
            }
          )
        }
      )
    )

    result:

    The Expression Guru
    September 28, 2021

    Thanks Mike, 

    I would like to get the name from database and only matching name document should be displayed at each row. Could you please help me on this.

    richardm900458
    September 28, 2021

    1.) what do you mean by "name from database"? Are you storing document names in a DB?
    2.) "Only matching name document" -> This means, you want to search all documents for a document with a specific name and if it matches, you want to display it and make it available?