EXport Airtable Records in a Custom PDF Report

Any updates regarding to this? It´s THE killer feature that we´re missing so much in my office. We really need to be able to sumarize data in Page Designer. Would be hugely apreciated!

2 Likes

Hi @Alexandre_Co I am on a Pro account and could action some printouts for you to demonstrate what the results look like. Would this help?

Sure! Any help is welcome. Thanks.

Would you like to send me an invite to the table or a copy of the table so I can create it for you? stonestreetproductions@gmail.com

Hi Oli, sorry for the delay. I think it would be ok if you invite me. But before you have all this trouble, you should know that I already have access to page designer. What I actually need is Page Designer to compile data from a table, instead of only one record. Otherwise, it has no use in my office and we will sadly have to stick with Excel. Not even the print page option is being able to handle our needs. Thanks a lot anyway.

1 Like

@Alexandre_Co, what you’re asking for is currently a big giant hole in Airtable’s feature set. As you said, there’s currently no way to print a NICE LOOKING report containing multiple records (esp large tables with lots of fields and records). I’ve been wanting to find the time to experiment with using the API to pull data from one of my own views into an html page, and create a printable table that way. But haven’t gotten to it yet.

You can see more info here:

2 Likes

Very interesting, Ben! I have a bit of experience in Wordpress and I´m definetly going to take Airpress for a spin. Jquery Data Tables are looking good too. I just found some Wordpress plugins for Data Tables, which could be handy. I´ll let you know if I get to something like we need. Thanks a lot for your reply.

I actually had a little time this weekend to launch a basic wordpress site and install the Airpress and Tablepress (datatables) plugins. But couldn’t figure out the php necessary to dynamically pull a set of records (and their field data) to build a new table in Tablepress. I’ve got a msg in to @Chester_McLaughlin, to see if I can get more info.

I’m looking for something similar. Any update?

I’ve primarily used Airpress in shortcode mode, with reasonable success. (I think my life would have been easier had I not decided to teach myself WordPress, Divi, Airtable, and Airpress all in the same project.) I ended up running a modified version of Airpress (I added code to generate a numeric loop counter, giving me item numbers when an Airpress call returned multiple records) — something I subsequently must have forgotten, as I evidently attempted to upgrade the plugin a while back, and in doing so broke the site. Guess I should fix that…

In any case, last I worked with it, the shortcode-driven version of Airpress was acceptably robust for report generation, but for data entry and update one still needed to program to the Airpress API directly. That doesn’t appear to have changed in subsequent updates.

Tried out the beta from the coworker’s account as well yet didn’t figure out with the customization of the reports. Whatever I was doing, afterwards I got pdf with all the correct data yet with confused places and formatting, so I was editing them manually with this tool https://ds11.pdffiller.com Now I have no access to that account as well as looking for something with the features similar to the ones of Airtable. Can anyone tell me if they have that issue fixed so far?

Ever get this figured out? I can’t get it to work either :frowning:

Javier, we’ve put our particular project on indefinite hold. But before that happened, I had a chance to talk to Chester. My understanding is that AirPress and Tablepress don’t work well together. Chester has built some custom plugins (for his clients) that allow you to use specific features from DataTables to display and/or interact with data from AirTable, on a Wordpress page. Once that’s done, styling is as simple as writing CSS. But given the number of variables, I don’t think there’s an out-of-the-box solution available. Someone would have to build the plugin from scratch (Chester, or you, or another programmer). I don’t think any of it is super-difficult, but definitely requires a fair understanding of PHP, the Airtable API, and Wordpress (or whatever platform you’re building on).

This would be a nice-to-have. In the mean time my workaround is to use the Airtable API to pull the records, populating them in an HTML template, and then generating the PDF with https://www.api2pdf.com. Works fine, but you have to have some basic coding knowledge in order to do it.

I agree with BeninDallas and Alexandre_Co. It is astonishing to me that there is no way to get a report out of Airtable. This should have been a feature included in version 1.0. My base is for people doing research. It is easy for me to put data in, very difficult for researchers to get data out. I don’t want them to see or have access to the entire base, or even one table at a time. They need to ask a question – filters work – and get information and print it out in a report. That is not yet possible.

5 Likes

I use https://www.reportbin.com/, it’s pretty flexible since you can design the reports using HTML. The downside is you do have to know HTML, though they have an offer to do that for a fee. The interface is pretty basic, but you should be fine with some basic understanding of Airtable to fill in the infor they need.

2 Likes

Hey thanks for the mention Patrick. I’m Sam from ReportBin, we’re still working on the interface, so expect it to be better with time. Please don’t hesitate to contact me if you need any help.

@all: contact me and mention you’re from Airtable Community, I’ll work with you to design your reports for free in exchange for feedback :slight_smile:

3 Likes

Chiming in! I need to prepare multiple-record reports.

1 Like

Hi… I think I have a solution… It’s possible to make it through google sheets and airtable integration.
If it’s interesting for someone, I can explain how to do it.

1 Like

@SDOK_Blog : It’s pretty easy to integrate AT and Google Sheets through Zapier. The problem is that the AT API does not support an “updated record” event, so Zapier will only sync NEW records between the two platforms. This is useless to me, since the whole point of a project status report is to get the LATEST “status” (that is, updated field data) of an EXISTING “project” (aka, record). Do you have a solution for this?

1 Like