Apr 22, 2019 12:11 PM
Is it possible to display data from multiple records on a single page in this block?
Mar 18, 2020 09:34 PM
To print a list of records in the Page block you need two tables. Call them the Parent table and the Child table. One Parent record links to many Child records. (Or all child records!) The page block is set to show records from the Parent table. Drag the linked field (it shows what records in the Child table are linked to this Parent record.) into the page space and a table of linked records will appear. You can then select what Child table fields appear in the page table. You can also rearrange their order of appearance (using the drag texture on each field listed on the left.) In the Child table you can filter and sort, then save that as a view. I add a “Print” Check Box field in the Child table so I can also uncheck a record I don’t want to print but is impossible to separate out of the filtered mix. The “Print” checkbox is one of the filtered fields. Save as many filtered views as you need to for different reports. Divisions, dates, names, etc.
Agree that the Page block needs lots of work. I grew up on Filemaker and their layout tools for printing are light years ahead of Airtable. Too many work-arounds in Airtable to be elegant. The FM feature I miss the most is the ability for cells and rows of records to remove unused space when printing. Oh well, no free lunch.
Apr 23, 2020 10:15 AM
That’s the fix, thank you!
May 09, 2020 03:16 AM
I am also interested in this because I need to do two things:
a) Print a Total Amount of all transactions in the header
b) Print the least of all the transactions
The solution offered solves problem B but not problem A
May 07, 2022 02:32 PM
I’m trying to do something similar only I’m trying to print on Avery envelope labels and want to show records on each label box. I can put an image in to get the layout proper but it still doesn’t help me with the current configuration.
Aug 05, 2022 10:04 PM
Are there any other Airtable extensions that allow custom formatting of elements from a list of records?
Nov 10, 2022 07:12 AM
This is the solution, thanks!
Jun 07, 2023 02:29 PM
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!
Jul 31, 2023 08:35 AM
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!
Jun 05, 2024 02:12 AM - edited Jun 07, 2024 10:09 AM
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: