Reporting: should I do this with Pivot or Page block

To say that Airtable reporting is limited would be a grotesque understatement.

You might look at this:

You too can make dashboards: How to visualise your Airtable data in Google...

We’ve written a guide on how you can combine two free tools to centralise and visualise your data.

Reading time: 7 min read

Taking this as a basis, I created a series of formatted pivot tables and presentation tools that auto-update 4 times a day for my client.

Process:

• Create a view with the data


• Write a Google script that extracts the data and schedule that script to run 4 times a day


• The script includes updating pivot tables based on the data - Google Sheet’s has more options for multiple column/row groupings.


• The script takes pivot table data and updates a couple other sheets specific to (and shared with) my client’s clients and sends out email updates.

This took a bit to setup - but once in place was a significantly more robust reporting solution for a number of reasons.

Matthew_Moran wrote:

To say that Airtable reporting is limited would be a grotesque understatement.

You might look at this:

You too can make dashboards: How to visualise your Airtable data in Google...

We’ve written a guide on how you can combine two free tools to centralise and visualise your data.

Reading time: 7 min read

Taking this as a basis, I created a series of formatted pivot tables and presentation tools that auto-update 4 times a day for my client.

Process:

• Create a view with the data


• Write a Google script that extracts the data and schedule that script to run 4 times a day


• The script includes updating pivot tables based on the data - Google Sheet’s has more options for multiple column/row groupings.


• The script takes pivot table data and updates a couple other sheets specific to (and shared with) my client’s clients and sends out email updates.

This took a bit to setup - but once in place was a significantly more robust reporting solution for a number of reasons.

It should be noted: I am playing with Google Data Studio - but for now just use sheets natively. Google Data Studio was an extra/unnecessary step and seemed only able to refresh data every 12 hours. I haven’t played with it enough to know whether that can be modified.

Thanks Matthew for the link and info! Currently just experimenting with Airtable, saved the link in case I’m gonna need it. I already had the feeling that reporting was not really Airtables thing.