# Generate a PDF from database items

**URL:** <https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109>\
**Category:** Component Requests\
**Tags:** media-document, backlog\
**Created:** [April 15, 2020, 4:21pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109 "2020-04-15T16:21:22Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![PaulDJ87](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@PaulDJ87](https://forum.adalo.com/u/PaulDJ87)\
**Post date:** [April 15, 2020, 4:21pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/1 "2020-04-15T16:21:22Z")

</div>

A feature that allows you to generate a PDF which is populated with data from the app. Possible uses would be for generating an invoice or making a certificate with the users name and date created on it.

---

<div class="post-metadata">

**Author:** ![Dim](https://avatars.discourse-cdn.com/v4/letter/d/ebca7d/32.png) [@Dim](https://forum.adalo.com/u/Dim)\
**Post date:** [April 20, 2020, 3:41pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/2 "2020-04-20T15:41:33Z")

</div>

I would love for them to allow us to send emails too! e.g. Create the pdf and send it via the customers email. What do you think about this Paul Jepson ?

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [April 20, 2020, 3:52pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/3 "2020-04-20T15:52:46Z")

</div>

Good idea, Paul! I can see powerful use case for this.

* * *

_Originally posted by: [gregoryalbritton+canny@gmail.com](mailto:gregoryalbritton+canny@gmail.com)_

---

<div class="post-metadata">

**Author:** ![bartoszkrawczyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bartoszkrawczyk/32/38708_2.png) [@bartoszkrawczyk](https://forum.adalo.com/u/bartoszkrawczyk)\
**Post date:** [May 3, 2020, 12:27pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/4 "2020-05-03T12:27:53Z")

</div>

It’s important must have for many apps. I should be on top of the list.

---

<div class="post-metadata">

**Author:** ![mischelle](https://avatars.discourse-cdn.com/v4/letter/m/3e96dc/32.png) [@mischelle](https://forum.adalo.com/u/mischelle)\
**Post date:** [May 14, 2020, 3:28am UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/5 "2020-05-14T03:28:00Z")

</div>

Very good idea Paul, and I think this should be a basic function of any application. This should be a priority, as it can also be used for creating reports etc.

---

<div class="post-metadata">

**Author:** ![Dim](https://avatars.discourse-cdn.com/v4/letter/d/ebca7d/32.png) [@Dim](https://forum.adalo.com/u/Dim)\
**Post date:** [May 16, 2020, 5:38pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/6 "2020-05-16T17:38:09Z")

</div>

Mischelle: I think this and custom reports should be a priority!

---

<div class="post-metadata">

**Author:** ![ajbirdseye](https://avatars.discourse-cdn.com/v4/letter/a/3e96dc/32.png) [@ajbirdseye](https://forum.adalo.com/u/ajbirdseye)\
**Post date:** [June 11, 2020, 7:03pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/7 "2020-06-11T19:03:17Z")

</div>

I have been needing this feature for a long time, an easy way to print from a adalo

---

<div class="post-metadata">

**Author:** ![bakerofideas](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bakerofideas/32/209_2.png) [@bakerofideas](https://forum.adalo.com/u/bakerofideas)\
**Post date:** [August 5, 2020, 12:42am UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/8 "2020-08-05T00:42:40Z")

</div>

Hopefully, this get’s completed asap. Very important feature and one of the reasons why I let my subscription go. I do plan on renewing it in the near future though.

---

<div class="post-metadata">

**Author:** ![Dim](https://avatars.discourse-cdn.com/v4/letter/d/ebca7d/32.png) [@Dim](https://forum.adalo.com/u/Dim)\
**Post date:** [November 4, 2020, 5:41pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/9 "2020-11-04T17:41:10Z")

</div>

Will this be in the works soon? Can’t wait for this I need it for my app and doing it with api is very hard because I need 2 tables on the pdf.(customer info and invoice lines)

---

<div class="post-metadata">

**Author:** ![dhavalwathare](https://avatars.discourse-cdn.com/v4/letter/d/e9c0ed/32.png) [@dhavalwathare](https://forum.adalo.com/u/dhavalwathare)\
**Post date:** [November 16, 2020, 3:03pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/10 "2020-11-16T15:03:27Z")

</div>

I could build a paid web service for this.  
Steps you would take to use this :

1. Setup an HTML template (load your own, or select one)
2. Send your apikey + template id + data to fill, as a GET / POST custom action request to my service.
3. My service returns the pdf download link.  
Anyone interested ? Reply to this comment

---

<div class="post-metadata">

**Author:** ![Dim](https://avatars.discourse-cdn.com/v4/letter/d/ebca7d/32.png) [@Dim](https://forum.adalo.com/u/Dim)\
**Post date:** [November 16, 2020, 5:35pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/11 "2020-11-16T17:35:33Z")

</div>

Dhaval Wathare: How would it work for multiple lines on a documents? Like an invoice. could the post request be able to handle this?

---

<div class="post-metadata">

**Author:** ![dhavalwathare](https://avatars.discourse-cdn.com/v4/letter/d/e9c0ed/32.png) [@dhavalwathare](https://forum.adalo.com/u/dhavalwathare)\
**Post date:** [November 17, 2020, 2:08pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/12 "2020-11-17T14:08:15Z")

</div>

Dim: A post request by itself can definitely handle multiple records, provided adalo can compose it into one single JSON data. This would be the preferred way of running the service. But as of now I think thats a limitation to Adalo’s magic text (it doesn’t let you iterate). Let me know if you can think of a way to do it this way.  
Meanwhile, a workaround is to use custom lists and countdown timers to iterate over line items and send multiple get/post requests with a common reference id.  
This can be done.

---

<div class="post-metadata">

**Author:** ![Dim](https://avatars.discourse-cdn.com/v4/letter/d/ebca7d/32.png) [@Dim](https://forum.adalo.com/u/Dim)\
**Post date:** [November 17, 2020, 2:57pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/13 "2020-11-17T14:57:55Z")

</div>

Dhaval Wathare: So I was thinking every time we create an invoice line we could do an update request. I think this would be difficult to manage on your part though… There’s a risk that my update will only replace other invoice lines instead of adding them. Also the subtotal would need to be updated following that. Which would need another update request. All my invoices have and ID so it wouldn’t be hard to post info to the right invoice.

---

<div class="post-metadata">

**Author:** ![dhavalwathare](https://avatars.discourse-cdn.com/v4/letter/d/e9c0ed/32.png) [@dhavalwathare](https://forum.adalo.com/u/dhavalwathare)\
**Post date:** [November 18, 2020, 3:47am UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/14 "2020-11-18T03:47:05Z")

</div>

Dim: Invoice line items can also have their own id. The service can be intelligent enough to replace them when the id’s match, appending them otherwise. While the totals get recalculated on each update. Once you’re done, a request to finalise can be sent, which will then build the pdf and send back a download link.  
My concern would be more on the economics. What kind of volume of invoicing are you looking at ? how frequently ?  
Also, no one else has commented so far. So seems like there’s no demand for this.

---

<div class="post-metadata">

**Author:** ![Dim](https://avatars.discourse-cdn.com/v4/letter/d/ebca7d/32.png) [@Dim](https://forum.adalo.com/u/Dim)\
**Post date:** [November 19, 2020, 3:24pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/15 "2020-11-19T15:24:52Z")

</div>

Dhaval Wathare: Yeah I think people want an adalo component and not deal with setting up and API

---

<div class="post-metadata">

**Author:** ![dhavalwathare](https://avatars.discourse-cdn.com/v4/letter/d/e9c0ed/32.png) [@dhavalwathare](https://forum.adalo.com/u/dhavalwathare)\
**Post date:** [November 20, 2020, 2:22am UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/16 "2020-11-20T02:22:42Z")

</div>

Dim: Should be doable too. Same thing internally, except I abstract everything behind a component. End user only sees a button like (or wtev else) component to attach to a database collection + filtering options. Click the button, get the pdf  
Still there needs to be some demand to invest time into this.

---

<div class="post-metadata">

**Author:** ![Cacoreasa](https://avatars.discourse-cdn.com/v4/letter/c/958977/32.png) [@Cacoreasa](https://forum.adalo.com/u/Cacoreasa)\
**Post date:** [December 28, 2020, 1:28pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/17 "2020-12-28T13:28:59Z")

</div>

Dhaval Wathare: Hello, i need this ASAP, How can I contact you?

---

<div class="post-metadata">

**Author:** ![dhavalwathare](https://avatars.discourse-cdn.com/v4/letter/d/e9c0ed/32.png) [@dhavalwathare](https://forum.adalo.com/u/dhavalwathare)\
**Post date:** [December 29, 2020, 3:33am UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/18 "2020-12-29T03:33:42Z")

</div>

Carlos Argueta: Hi Carlos, there doesn’t seem to be much demand for this, so not pursuing it as a service. But if you still need a bespoke solution, please DM your requirements / usecase specifics to me on twitter (@DhavalW).

---

<div class="post-metadata">

**Author:** ![martinkasozi](https://avatars.discourse-cdn.com/v4/letter/m/e8c25b/32.png) [@martinkasozi](https://forum.adalo.com/u/martinkasozi)\
**Post date:** [March 19, 2021, 9:31am UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/19 "2021-03-19T09:31:58Z")

</div>

Dhaval Wathare: Hi Dhaval Wathare, I am interested in doing this for my application. I need help accomplishing this service. Can we talk?

---

<div class="post-metadata">

**Author:** ![gskachkov](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/gskachkov/32/17594_2.png) [@gskachkov](https://forum.adalo.com/u/gskachkov)\
**Post date:** [May 25, 2023, 9:01pm UTC](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109/20 "2023-05-25T21:01:56Z")

</div>

I’ve developed PDF file generator component to generate PDF within Adalo App. No need to use external service for Generation of the PDF. You can find it in Adalo Marketplace.

Demo Video [https://youtu.be/8lncArl2UT0](https://youtu.be/8lncArl2UT0)

Demo Application [PDF Generator & Previewer Demo App](https://previewer.adalo.com/421cebdf-ad98-46af-ae38-4a9b673abdf3)

It can be installed on [Adalo Component Marketplace](https://itsmi.store/components) as well

[Next page](https://forum.adalo.com/t/generate-a-pdf-from-database-items/64109.md?page=2)
