Print 2 pages per sheet of a document generated with Google App Script
I made a Script that searches for certain PDFs in my email. Then it generates a consolidated document thanks to the PDFApp library and saves it in My Google Drive.
Now I want another document to be generated from that Consolidated PDF document that will help me save paper for printing. And it involves taking the CONSOLIDATED document and printing it in PDF 2 pages per sheet. Thus, if the CONSOLIDATED document is 10 pages, in the new document it will only be 5 pages. I want to do that with Google App Script and I can’t.
I think using https://pdf-lib.js.org/ I could do it, but I’m a newbie and I don’t know how to use that library. Yes, I was able to use the PDFApp library because that library has the script id which I included in the Library and it worked, but https://pdf-lib.js.org/ I don’t know how to use it. Or do you have any idea how I could do it?
Why does my code pulls complete source data into the main sheet upon updating data in the source sheet
I have three source spreadsheets and I managed to consolidate data into a master sheet, but my aim is to see to see to it, whenever data is update or new row is added in any of the source spreadsheets, the master sheet must get updated as well. The current script pulls up all the data into the main sheet along with updated data or new rows added in the source sheet. Also, the trigger won’t run. I have set up onEdit function, Event – From spreadsheet