Awesome, thanks for this. What I’m going to be trying to do is create a PDF of a user’s form submissions (rows) over a specified date period (so the PDF would need to find multiple rows dynamically based on a date range and user email).
make sheet for PDF on separate spread sheets, it will be much easier, and import range data to it
Yes, that script I just shared could easily be adapted to do that. There’s actually a companion helper function which iterates through the sheet and decides which rows need to have PDF’s generated. It then calls this function for each qualifying row.
Feel free to reach out if you decide to use it and need some help.
PS. If I was doing this for myself, I’d just use Integromat
then you will not be able to do cool tricks with it… lol
did you tried my link?
I’m also considering going that route. The PDF portion of the process isn’t 100% necessary, it’s more of a nice to have, so I’m trying to see if I can make it work without ongoing costs.
I’ll definitely reach out if I need a hand! Thanks!
if you don’t need PDF, you can make email body look almost like PDF, like in my example
That’s a good point too. Something to consider for sure, especially because it would likely reduce the size of the email too. The cool thing with a PDF is that it’s going to present the same for everyone, regardless of email client or device they’re using. My concern is with folks that are using an email that can’t render the output or HTML nicely. May seem rare, but in my organization, it’s not uncommon to find people with plain text emails only.
PDF is hosted by link… so it doesn’t take much
First time exploring script. By Set trigger you refeting to google sheet right.
no, to script triggers, that will go of when sheets are edited
I’ve shared this before somewhere in the forum but in regards to PDF creation, we use this and it works well with some of our Glide apps. It’s not free, but it’s been reliable thus far.
https://workspace.google.com/marketplace/app/document_studio/429444628321
Yes, you have. In this very same thread
hahaha I prefaced it for that reason I guess! My bad!
thanks Uzo, will give it a try.
- The user sends text / image from JotForm.
(JotForm can be replaced with Glide.) - Store data in G spreadsheet.
- Generate PDF with GAS and send the PDF as an attachment to the user by email.
And …
A postcard-sized item like this will be delivered to the user.
Will this work upon Glide form submission?
The pdf generation @Darren_Murphy built for me is designed to work on form submission, via the “on change” trigger.
Yes, that’s (sortof) correct. It’s using an onChange() trigger, which means it will fire when Glide makes any change to the Google Sheets.
I’m doing well with almost correct advice this morning. I’m glad you are there to clear up the mess I am making