Is it possible to display data from multiple records on a single page in this block?
+1Justin_Barrett wrote:
Another option is to build a “page” in Page Designer that’s just big enough for a single record. In a test, I made a custom record size that’s 927 x 20 pixels. I arranged the fields that I wanted in that space, then printed the page. In the page printing dialog, I set the page size to Letter. For the Record Layout option, I got acceptable results with both “In a grid” and “In a list,” though the former put a little more padding between records. The only downside is that you can’t add a header with this method.
One thing to keep in mind is that while it’s called “Page Designer,” it’s really not meant for designing a page full of records. It’s meant for designing the layout of a single record, a point emphasized by the fact that the Settings dialog for Page Designer says “Record Size”, not “Page Size.” Via the linking option that @Regan_Marshall mentioned, you can pull multiple records from other tables and sorta-kinda work around that, but it feels to me that some of the frustration that people are encountering stems from misunderstanding the block’s intended purpose, a purpose somewhat muddied by its name IMO.
I managed to make this (sort of) work using your instructions, and a custom size that's just 40 pixels high, so it creates one long row. Thanks!
+10Regan_Marshall wrote:
You may need to create another table that links to each of the records you want to display on the single block.
Once you add a field to page designer that is a Link to record field with multiple records enabled, you’ll get the option for Table, List and Inline. You can add and sort records just below this. Formatting is limited but better than nothing.
Your option is much better than the "record size vs page size" manipulation that others have suggested. Less work and you can have a header as well.
I'll explain it a bit more:
1. Make a new table
2. Set the 2nd column to "link to another record"
3. Add all your records from the other table into one record in this table and have it lookup all the fields you need.
4. Go to page designer and insert the primary field of that record, choose between table, list and inline (choose table).
5. Stretch the page designer field as much as needed to display all the records of your original table, then add all the lookup fields and stretch widthwise to accommodate.
6. All done. You're an Airtable Wiz!
Hi! If you need a tool similar to Page Designer but capable of including all records in one document, you also can try Plumsail Documents. This extension allows for comprehensive document creation with multiple records on one page. You will need:
- Create a document generation process in Plumsail Documents, preparing the template beforehand. The template can be in any format, from PDF to DOCX, XLSX, or PPTX, making it easy to customize.
- Install the Plumsail Documents extension from the Airtable marketplace and configure the extension button.
- Match the template fields in Plumsail Documents with the fields from the Airtable table. You can copy tokens from Airtable and put them into a table row or bullet point.
- Generate documents by clicking the extension button.
Check out this guide on How to print multiple Airtable records on one page and include them in one document. The photo above is taken from it.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.