PDF report generation

[abarbour]

So..... I am a little stuck.

I am trying to automate the generation of a custom PDF document and then email the resulting PDF. I can do all the front end work to get the values extracted and ready to merge... and once generated send the document....

Any suggestions for a tool for doing the mail merge / document creation that would do the report generation easily and which is easily integratable with macroscheduler?

Create an HTML report and then export to PDF?

Thanks!

[Grovkillen]

I use https://wkhtmltopdf.org/ for this exact function.

[abarbour]

Excellent! I am working on it now.... how do you call the wkhtmltopdf.exe from inside macroscheduler?

[abarbour]

Got it....just "Execute File" with the parameters passed.... Very powerful!

Thanks!

[abarbour]

Finally got this project done....
User completes google form
Google Sheets updated with answers
Macroscheduler then:
- checks for new responses
- calculates results for respondent
- sorts some data (shout out to DOS Sort!)
- creates a custom 8 page report for them (assembling multiple separate components merging in data from their responses
- converts to PDF (using wkhtmltopdf)
- emails them a copy of the report
- archives their responses
- adds their results to the benchmark data set for analysis later
Still working on:
- adds a calendar item to follow-up with the respondent to upsell them services - likely connecting via Zapier

[Grovkillen]

Regarding the calendar, you can use Google Calendar API.