Help

Re: Print a list with Page Designer

Solved
Jump to Solution
365 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Danilo_Crenna
5 - Automation Enthusiast
5 - Automation Enthusiast

Page Design is really useful but I can't do a seemingly simple thing.
I have a list (view of a table) and I want to layout it and print it in PDF with Page Designer but I can't find a way.
It seems you can only print a single record at a time.
Can you tell me if there is a way?
Thank you
Danilo

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Ah, try:
1. Create a new table called "For Page Designer" or something and create a linked field to your main table
2. Link all of the relevant records to a single record in "For Page Designer"
3. In Page Designer, use that one record in "For Page Designer" that's linked to all the relevant records, then use the linked field in your design and you'll end up with this:
Screenshot 2024-03-15 at 11.24.57 AM.png
And here's the data set up!
Screenshot 2024-03-15 at 11.25.08 AM.png

Screenshot 2024-03-15 at 11.25.25 AM.png

 

 

   

See Solution in Thread

7 Replies 7
ScottWorld
18 - Pluto
18 - Pluto

Unfortunately, that is not possible with Page Designer if you're looking for an actual document that produces a list of records with column headers, a header at the top of the page, a footer at the bottom of the page, etc.

You can sort of hack it by setting your "page size" to a very short height, and then when it comes time to print, you can set a normal "paper size". But what that's doing is repeating the exact same page for each record — and you're telling Airtable to squeeze all the individual pages onto a single piece of paper.

However, even if that hack works, it still can't be automated, and you still have to manually generate the PDF and then manually email the PDF or manually insert the PDF into Airtable (or whatever you'd like to do with the PDF).

In general, you will typically need to turn to an external document creation app if you would like to automatically create PDF files for list of records.

Here are a couple of options for you:

1. One of the most popular PDF creation tools for Airtable is DocuMint. This can be automated natively or by using Make’s DocuMint automations.

2. Another popular tool is Docs Automator, which integrates with Google Docs.

3. However, you can choose ANY document creation app that you would like, and automate the PDF creation process by using Make’s automations & integrations. You can even use good old fashioned Google Docs, Microsoft Word, or Microsoft Excel. If you've never used Make before, I’ve assembled a bunch of Make training resources in this thread.

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld

TheTimeSavingCo
18 - Pluto
18 - Pluto

Ah, try:
1. Create a new table called "For Page Designer" or something and create a linked field to your main table
2. Link all of the relevant records to a single record in "For Page Designer"
3. In Page Designer, use that one record in "For Page Designer" that's linked to all the relevant records, then use the linked field in your design and you'll end up with this:
Screenshot 2024-03-15 at 11.24.57 AM.png
And here's the data set up!
Screenshot 2024-03-15 at 11.25.08 AM.png

Screenshot 2024-03-15 at 11.25.25 AM.png

 

 

   

One of the problems with that approach is that you would need to pre-set the linked record field to a maximum height on the document, meaning that there is a maximum number of linked records that can print.

Also, I'm not sure how elegantly Airtable would handle page breaks.

For example, what happens to text that falls across a page break?

Also, I'm assuming that Airtable wouldn't allow a bunch of empty lines at the end to create multiple blank pages at the end, but I'm not 100% sure about that.

Thank you.
I was afraid it was the only solution while staying inside Airtable

DocuMint can be a solution although I believe it is still necessary to prepare the data as TheTimeSavingCo recommends.
Thank you

No, you wouldn’t need to prepare the data in that way when using 3rd-party tools.

Great! ! Thank you very much