May thanks Marcoā¦super useful
This is awesome, i need to make data dynamic ā example: I use
Hi @Loqode,
Many thanks for your work, that is absolutely awesome and functionnal.
However, if I well understand, the document is only generated when we click on āDownloadā, right ?
Would it be possible to generate the file and give it back to Glide ? This way we could email it ?
Many thanks for your reply, Iāll try to find how to do waiting your potenteil answer !
Cheers,
At the moment, youāre correct, thatās how itās setup.
But the new āUpload Fileā integration is opening a lot of doors!
Hereās a quick loom I filmed a week ago explaining it to a student of mine:
I have setup an API that allows you to generate PDFs, and you can now save them directly thanks to the Upload File integration. But you can use any api that does this.
You may even be able to save binary files and skip the apis altogether ā¦
I will experiment and get back to you!
@Loqode my client has reported an issue where the downloaded file isnāt recognised as a PDF. I can reproduce in both safari and chrome on MacOS 15.3 and 15.3.1. It is working as expected on iOS.
I have isolated it to when the filename contains a ā.ā which isnāt ideal as people tend to use it in versioning. For example, āFilename V2.1ā breaks, but āFilename V2ā works fine.
I have found that manually adding the .pdf extension to the broken files fixes the issue.
In the meantime, we will avoid naming files with a period.
I havenāt tested on Windows, etc. Any suggestions regarding Glide configuration to resolve? Otherwise, hopefully this is an easy fix on your end.
Cheers
Hi, did you ever work out how to print multiple rows perhaps from another table? Iām looking for how to do that.
Have you tried using JSON to combine the info together before processing that to a HTML string?
Hi Thinh
I have no idea what JSON is But I googled and see it is javascript. I have no idea how to program so I suspect that is out of my scope so maybe I canāt do what I hoped to do. But thank you for responding to my questionā¦ appreciate that.
Thank you
JSON is a data format, JavaScript is a programming language
I have run into this issue many times with clients using my software DocsAutomator. I think itās a bug in Glide that only the Glide team can fix at this point.
@Rupert, my client is reporting it to be special characters in general causing issues. Same for you?
Many thanks for your your effort on helping us. this plugin indeed works fine. but since iām using the free plan we are not allowed to use web embed.instead i had to use a button and its action is to open that url you have provided. but it seems that once the link is opened i need to refresh the page before the data is loaded and this has to be done everytime. is there any fix?
Hi, sorry for the slow reply but had a few things happening. So Iāve watched the Glide youtube on JSON but still donāt really understand how I would use it for creating PDFs to list all the medical data for one specific cat. Would I create a JSON object in the Medical table with all the info I need and then somehow get the PDF to read all the JSON fields in the MEdical table to only list thoses in the PDF that match the cats name in the Cats table? I assume this because JSON objects only seem possible for the table you are creating the column inā¦ unless Iāve completely missed something. If you could maybe please point me in the right direction I will keep trying to nut this out
What do you mean by āGlide YouTube on JSONā? Can you link the video?
The premise of generating a PDF that takes info from possibly mutliple rows is a JSON, and then I usually use JavaScript to process that JSON into multiple line items in the PDF.
DocsAutomator does it automatically, you just need to pass the JSON and write the right template in your docs.
PDFMonkey uses Liquid to loop through the JSON to generate HTML for the PDF.
If youāre doing it yourself and not the third-party solutions above, you have to process it using JavaScript.
Thanks for replying. The youtube is this: https://www.youtube.com/watch?v=rkDy89qcCT4
So Iām figuring that I likely wont be able to make a PDF that pulls from multiple tables in the free version (unless DocsAutomator is free and can do that which I will have a look) as I donāt know javascript. Something to add to do once we raise the money to pay for paid version.
Just think of it that itās just a way for you to consolidate data in a structured way. If youāre able to use relations + lookups/joined list to pull data from different tables, you should be able to have a complete JSON for your own need.
Check the docs here:
And the video about line items.
@Rupert Should be able to help you more via the DocsAutomator chat once you gets to it.
Thanks. I will have a read and watch as keen to learn more.
Docs Automator is not available on the free plan I believe.
Yeah, I take it thatās the direction youāre heading to once you raise some money.
Most definitely. They have seen the immense benefit just in the little bit Iāve done already for them. And when Iāve outlined what the paid version can offer in the area of PDF from multiple tables and automation and scheduling they were super keen. Just had a few vet emergencies come in that we need to pay first.