Skip to main content
  • EN

Hi, 

I have a workbench that processes data of X number of rows. At the conclusion I would like to send an email to summarise what was done. I would love something like:

 

Hi Ben, 
 
We have just updated the table with 32 new rows.
 
Here is a summary of the data added:
 
ASSET ID | NAME | DOB
 
150 | Ben | 02/02/1992
 
151 |Tony | 01/01/2001
 
....
 
....
 
183 | Michelle | 03/03/1983

I have added a statistics calculator to my workbench, this is currently able to give me the summary (total number of rows) to include in the opening sentence, but I am not sure how to add the 32 rows to the email, formatted as a table.

 

I know this has to be such a simple task, I just cant work out how to do it!

 

Thank you.

 

 

 

 

Multiple ways to do this, I use an Aggregator to merge multiple rows into one.

Multiple ways to do this, I use an Aggregator to merge multiple rows into one.

I am not sure the aggregator will work as I am wanting to include the list of items in the final email. Could the aggregator still achieve this list?

I am not sure the aggregator will work as I am wanting to include the list of items in the final email. Could the aggregator still achieve this list?

Not sure if I understand what you mean, but I think yes. You can always use Group By to keep original attributes. Attached workbench demonstrating this.

 

AggregatorSample(2021)

You should be able to create a html table with the HTML Report Generator which can be included within the email

You should be able to create a html table with the HTML Report Generator which can be included within the email

True, but I then you need to create the entire email body in the HTMLReportGenerator, not the table only.

True, but I then you need to create the entire email body in the HTMLReportGenerator, not the table only.

This is the method i would use, create the table, then extract just the table content into an attribute to use in the email body

 

image

True, but I then you need to create the entire email body in the HTMLReportGenerator, not the table only.

Nice thanks, learned something new today. :)

You should be able to create a html table with the HTML Report Generator which can be included within the email

+1 for the HTMLReportGenerator way.

I am not sure the aggregator will work as I am wanting to include the list of items in the final email. Could the aggregator still achieve this list?

Thanks heaps for the reply, this did work for me!

True, but I then you need to create the entire email body in the HTMLReportGenerator, not the table only.

Thanks again for the suggestion provided, it is working great.

I am just wondering if there is a simple way for me to add a header row to my HTML table, for inclusion in my final email?

 

The above solution you provided generates output that looks like the following, you will note it does not have any column headers. I am trying to work out how to add these but I am not having much luck!

 

image 

This is the current configuration, as you can see there is only one "column name" field to populate, so its not really set up for this exact situation.

image

Reply


Community Stats

30,162
Posts
114,483
Replies
37,810
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.