Sending Links to Reports

Prev Next

It is possible to configure an email action that sends an email to a recipient with a link to download a report so that the user does not need to go to the Reporting Module and manually run the task.

Configuration


  • Create a report template.

  • Select the module that is a target for creating combinations for export, and the needed fields

  • In the filter section, add Filter by e.g. Campaign field

Campaign - is equal to - {filterValue}

{filterValue} - is a dedicated keyword to be replaced with the actual value when generating the report

Note: only one filterValue placeholder can be used in the current implementation

  • Configure the Email action on the Batch Combinations event in the module that is a target for creating combinations

  • In the message body, use the formula to generate a link to the report

$tools.report( templateId, 'filterValue', 'customNamePrefix' )

for example:

#set( $customValue = "$tools.fetchFirst().fieldValue( 'Campaign' )" ) 
#set( $customName = "$tools.fetchFirst().fieldValue( 'Campaign Number' )_$tools.fetchFirst().fieldValue( 'Campaign' )_$date.get('yyyy-M-d H:m:s')" ) 
${SiteUrl}/<worker>$tools.report( 26, $customValue, $customName)

This will generate a link and apply a custom name to the report. e.g.: "40772_ESPECIAL VERANO - CITY_2019-03-15 12:45:34.xslx"

The report will contain the records filtered by campaign name, i.e., clock numbers related to the campaign they were created for.