Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 15, 2020 04:12 AM
Hello everyone,
Sometimes I feel the need to print my Airtable table records physically on paper (A4, A5 or even A6), while controlling every formatting and styling aspect (i.e; multiple records on 1 page, formatted as a table X by Y, or a list, controlling the font attributes, the border attributes, rounded corners, background colours,…).
Printing possibilities by default in Airtable are a little to basic. I’m on the Airtable free plan, but even the Page Designer App won’t stretch that far, I guess…
So I think the only way to get it exactly as I want is, is to go through the API, extract the records I need and position them and style them.
But how do I start with the API ? Which tools do I really need ? I read something about airtable.js and also node.js and npm…all very new to me. I’m not afraid to dive in new technology, but I need a starting point. My data in Airtable is mainly personal inventory, like movies, books, games,… There is no need to build a public website, it is only for my personal use.
Anyone who has tried this before and can point me out how to start ?
Many thanks…
PS For a good understanding, before I started to use Airtable, I used raw XML files as my data container, then I transformed it with XSLT in to HTML, and with the proper CSS I was able to print it exactly as I wanted it.
I could use the JSON files form Airtable, convert it to XML and continu from there as before, but I don’t think this is the right way. If I want to change this setup I want to do it with the contemporary tools out there in the market and leaving out XML and XSLT.
Dec 15, 2020 10:16 AM
A pro workspace is $20/month or $240 per year. That is a lot of money for some people, especially people with more time than money. On the other hand, sometimes time is money. If you like robust code-based solutions with full control, it might be worth the $240 for the time that you would save in development of both this and other projects. Also, keep in mind that Airtable already extended the deadline for when scripting would become paid once, and they might do it again. (It originally was going to expire back in September, but was pushed out to March.)
You could also try for a Creator Plan as mentioned here and here. I don’t know if this plan exists anymore or if is is possible to request at all, but it provided pro benefits to a workspace with a single collaborator.
Dec 15, 2020 11:00 AM
I’m not sure if the financial outcome is any better, but this post is somewhat relevant to @Eric_Goldman’s comments. I hadn’t considered some of the advantages to using a SQL [following] database until over in that thread, but I suspect Syn Inc might have a free tier making it possible to avoid the scripting block while shaping your data for pretty advanced reporting and all without relearning a lifetime of XSLT. :winking_face:
Dec 16, 2020 01:52 AM
Thank you Eric, Bill for your thoughts on other relational db’s, that might have a better backbone structure for making reports (if I may summarise these thoughts like this).
This might be a solution for sure, but personally, as I’m very happy with Airtable storage for data today, and JSON is the format it supports through the API, on first thoughts, it sounds a bit overkill to bring the data over to a SQL db, only for better formatting and printing.
But as I’m eager to learn, I’ll certainly take a look at this approach :winking_face:
Dec 16, 2020 04:30 AM
Yes, this seems a bit like turning off a light switch with a wrecking ball, but thinking it through I have these observations.
Dec 17, 2020 11:42 PM
Hey @Eric_Goldman, @Bill.French
As I said before I’m eager to learn new things :grinning_face_with_big_eyes: so I gave this a shot.
I have to make a trade off between going further in this direction versus the effort of setting up a JS framework, working with the API, and create the report manually.
Thank you both for sharing your thoughts and opening my eyes in that direction.
Dec 18, 2020 12:42 AM
Hey @Michel_Billiau
Any chance PDF MONKEY works for you maybe? Using Integromat you can connect Airtable and Pdf Monkey to generate your data in PDF and style them as you want.
Dec 18, 2020 01:47 AM
I was going to mention Integromat too. It’s a great app and it helps to automate your process.
Mary Kay