Create monthly PDF report for each table and send email with the PDFs

Hi, sorry I need help for this one.

I have been looking at this document: https://support.google.com/appsheet/answer/11541779 but I have to admit I dont understand since it is not working for me.

The app is some kind of Audit app where we do an audit of some employees to catch up if they're are doing good. The authorities require at any given time we can provide a printed paper of the audits.

I have 7 tables of which I would like to create a monthly report.
I want to create a monthly report for table: Xray, one for CMD, one for, DGR etc.

My plan was to create the bot as scheduled to run the last day in month around 11:45pm
My dream is that it generates 1 PDF file pr. table, where each PDF shows records for the current month.

Example of Xray table:
01.png

The other 6 tables that needs a PDF file as well is exactly the same, just with different 'questions'

Until now I have tried playing around, but nomatter what I do, it never generates the PDF when I use scheduled.

I try set the Schedule by hour just to make the creation go faster

02.png

Here is just simple PDF creation

03.png

In this template not all questions are present I know. I dont want to play around with correct design until the PDF is actually created. 
I really dont understand how to use these Start end End expressions?

04.png

0 8 1,711
8 REPLIES 8
Top Labels in this Space