# Export a PDF By filter

**URL:** https://community.glideapps.com/t/export-a-pdf-by-filter/72291
**Category:** Ask for Help
**Created:** [April 3, 2024, 8:27pm UTC](https://community.glideapps.com/t/export-a-pdf-by-filter/72291 "2024-04-03T20:27:09Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![shmuel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shmuel/32/59198_2.png) [@shmuel](https://community.glideapps.com/u/shmuel)
#### Post date: [April 3, 2024, 8:27pm UTC](https://community.glideapps.com/t/export-a-pdf-by-filter/72291/1 "2024-04-03T20:27:09Z")

</div>

I have a table with data of clients.  
I want to export a PDF file every month (using [PDF.CO](http://PDF.CO)). By filter: month of birth of that customer.  
The file will include:  
Background picture  
the name of the customer  
Thus, each file will contain all the pages of the month, and each page will show a different customer’s name.

I would appreciate help, even for a fee, on how to do it using GlideApp, [PDF.CO](http://PDF.CO) and MAKE

Thank you  
Shmuel

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 3, 2024, 11:53pm UTC](https://community.glideapps.com/t/export-a-pdf-by-filter/72291/2 "2024-04-03T23:53:28Z")

</div>

Do you mean there’s only one PDF to generate, containing all customers who have a birthday on that month?

---

<div class="post-metadata">

### Author: ![shmuel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shmuel/32/59198_2.png) [@shmuel](https://community.glideapps.com/u/shmuel)
#### Post date: [April 5, 2024, 7:31am UTC](https://community.glideapps.com/t/export-a-pdf-by-filter/72291/3 "2024-04-05T07:31:10Z")

</div>

True and accurate. Thanks 🙂

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 5, 2024, 11:40pm UTC](https://community.glideapps.com/t/export-a-pdf-by-filter/72291/4 "2024-04-05T23:40:11Z")

</div>

Theoretically I think what you need to do is:

- Create a math column in your user profiles table: YEAR(D)\*10^2+MONTH(D) with D being the birthday of users. Let’s call this “Birthday Month”.

- Create another math column in your user profiles table: YEAR(N)\*10^2+MONTH(N) with N being the “now” value. Let’s call this “Current Month”.

- Add a template column and build your HTML snippet of each “page” there.

> [@shmuel](#):
>
> Background picture  
> the name of the customer  
> Thus, each file will contain all the pages of the month, and each page will show a different customer’s name.

- Use a query column to query all users who have a birthday in the current month with the filter being: “Birthday Month” equals this row \> Current Month.

- Use a joined list column to join the HTML snippets on top of that query and then use a webhook action to send that snippet to Make, process it in a [PDF.co](http://PDF.co) module.

The only thing I’m not quite sure is if [PDF.co](http://PDF.co) allows you to add custom CSS. You mentioned each page would show a customer, so something like page-break-before: always would work.
