Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Tutorial Steps

  1. In runtime, navigate to the userview UI menu that contains your desired datalistlist, e.g: Datalist Inbox, CRUD, etc.

    Image RemovedImage Added

  2. At the bottom right corner of the userview UI menu, look for the export the export links that you require, and copy the link.
    The datalist list attachment can be in formats of CSV, Excel, XML, or PDF.

  3. In the Email Tool, go to Attachments tab.
    Paste the link into the Path column in the Files property, then name the file in File Name column to your preference.

    See here for more info about email attachment configuration: Email Tool - Configure Email Attachments

    Image RemovedImage Added

Dynamically Filter Records in Datalist Attachment

Tip
iconfalse

You can use Hash Variable & Datalist Filter's URL request parameter in the email attachment Files URL path to dynamically filter records in the datalist list attachment.

Using the default Expenses Claims app as an example:

Use Case Scenario : Dynamically filter the records in My Inbox list to only show expenses claims that is submitted by the current logged in user, as a PDF attachment in email tool.

The URL path to download a PDF format of My Inbox list without any filtering looks like: 
http://localhost:8080/jw/web/userview/expenseclaim/home/_/myin?6578706f7274=1&d-944469-e=5

Now if we want to filter the results in the datalist list attachment via "Submit By" datalist list filter, first we need to determine the datalist list filter's URL request parameter in the filter's properties, which is d-944469-fn_claimant in this case.

Then, we can now append the filter's url request parameter along with its value or hash variable to the URL path, so the URL path should now look like:
http://localhost:8080/jw/web/userview/expenseclaim/home/_/myin?6578706f7274=1&d-944469-e=5&d-944469-fn_claimant=#currentUser.username#

Image RemovedImage Added


Download Demo App

  1. APP_email_datalist_attachment_kb.jwa Requires Joget DX version 7.0.26 containing the latest fixes for file attachments in Email Tool.


Related Tools