Hi! I have setup a workflow triggered by a “Report” table, every time the report table is updated, it logs the user, date and time of report request and registers a “change” that triggers a workflow … (bare with me… I will get there!)
The purpose of it is to email the company in charge of product delivery/distribution, so the workflow I am triggering sends an excel report of each open orders individually and their data for the requested date to an email (that works fine!)
But, I also need the same workflow (on Action 2) or on a separate workflow triggered by the same “report” change, to send a summary of all orders in a word (PDF) document. The document should show basically how many items of each product are to be “delivered” total in other words I am trying to create a summary table to be sent by email.
Looking in this forum I found you can use the SUM expression. I tried, I dont get any errors, the file is just simply not delivered. My “start” statement is the same as the one in my excel report which I know already works.
Here is what I have so far