Curious if anyone has any suggestions or can help us….
Looking for help with creating customizable multipage PDF reports from our Airtable data!
Currently we’re using Google Docs to create a report, each with it’s own master header, with a varying amount (2-50) of cues (records), each cue needing it’s own group header and each having it’s own set of specific data (10-20 columns). Usually they run anywhere from 2-10 pages long. Our recipients need it in this format. We’d love to have it be aesthetically easy to read, with customizable color coding.
Printing as PDF directly from Airtable isn’t working due to formatting, grid spacing, longer descriptions getting cut off, and inadequate headers. Page Designer isn’t working due to only having 1 record per page (even 2 doesn’t work if I “halve” the printing dimensions), and I suspect the same would happen with a Zap, that without the Sheet adjusting for these ranges, that formulas wouldn’t work - for context, sometimes 1 project (report) has 8-20 episodes, and each episode has 1-30 cues, and each cue can have 2-8 songs… that is a ton of range, so set dimensions for each record just causes excessive blank space, like in the case where there’s only 2. Does that make sense?
Since we’re a small company, monthly subscriptions to pricey report-creating software (like Formstack) is not ideal. But really open to any solutions that could get us away from copying and pasting all this data from Airtable to Google Sheets!