Hello everyone,
At TypeFlow, I built a way to generate cross-tabulation tables (pivot tables) directly from Airtable linked records - no formulas, no scripts, no manual formatting.
You pick a linked record field as your data source, set a row field, a column field (any single select), and choose Count or Sum. TypeFlow reads the single select options from Airtable and generates the
columns dynamically. Add a new option in Airtable, it appears in the next document automatically.
It also supports grouped column headers - two levels of columns for more complex breakdowns. For example, Male/Female on top, then race categories underneath.
Here's a quick demo with two real use cases:
-
A garment supplier with a size-quantity grid (sizes as columns, styles as rows)
-
An HR compliance report with 191 employees grouped by occupational level, race, and gender
Our doc: https://www.typeflow.us/help/document-generation/pivot-tables
Our website: https://www.typeflow.us/
The table is generated inside your PDF, ready to send.
Happy to answer any questions.