The App enters a daily task based on activity performed. At the end of the month, I will like to have a PDF report with all these tasks captured in a report.
Is there a way in Glide to do this or I will need API ?
Hi,
I was about to post same question.
Iām using Glide Tables and I cannot figure how to export all the items to Make and how to generate a new document (report) with all the fields, based on a template.
I will follow your post.
Thank you
I usually construct a HTML/CSS template in PDFMonkey beforehand.
In that template, I define my variables and have a plan on structuring the data accordingly in Glide.
Then, in Glide, I create a button to trigger a webhook in Make. That webhook payload will contain all the variables I have constructed in PDFMonkey.
Then, in Make, I add a PDFMonkey node to generate the PDF based on the input data. I get the resulting document URL, use a HTTP module to download it and upload it to Google Drive.
Finally, I get the Google Drive link back to Glide using Glideās API.
I was asking because I think you can get away from relying on a button click in the app, and instead using Make to search the Sheet rows you want to send to the report, but gotta take into account that I donāt know about your data structure.
As for me, this is a little bit complicated
My ideea is to export in Make with a Webhook all the records as a Joined List.
Then, with an Iterrator to split that Joined List into āXā records.
An then, in some way, to write all those separated records into a single Google Doc Template (each record as a row) ā¦ but i donāt know how to do this last part of the scenario
Not something that Iāve tried. Until now, Iāve always used Apps Script to generate PDF from a GDoc template, so anything like that Iāll do programmatically.
I wonder if this use case could be a good candidate for the pure Glide method that weāve been discussing with Jeff?
I have a solution for my pdf report:
In my glide table, I have a template column, with all the information i need for my report. And those info are already spaced as a row for my report. Then i used a joined list in order to be able to export the info with a webhook to Make.
Once there, I used an Itterator in order to split the info and obtain my future report rows