Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Table with summary information

174 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a table, and I made a view with some grouping.
Screen_Shot_2021-07-23_at_5_37_09_PM

The schema of the table is [Survey, Question, Category, Person, Response]

Now I want to be able to extract the table with those groups and summary statistics and use that elsewhere in another part of my workflow, outside Airtable.
The API allows filtering, but not grouping it seems. How does one accomplish this?

Another option is somehow I can make the summary statistics into their own view/table? so it would look like [Survey, Category, Average Response]? Then I can query for that table and read those records and use them where I need them.

smiles

1 Reply 1

Hi @nRhythm - welcome to the Airtable community!

You could use a service we built, Sync Inc, to do this. We’ll replicate your Airtable base to a Postgres database in real-time. Then you can use SQL (including GROUP BY) to quickly recreate this view and summary analytics.

Would be more than happy to walk you through it - just shoot me a DM :slightly_smiling_face: