Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Jun 29, 2020 11:24 AM
I need to create a summary table that counts the number of times an individual product shows up in a list of linked records.
For example, I have a table called “Assortments” and a table called “Fruits” that are linked. Assortment 1 has 2 apples and 2 pomegranates, while Assortment 2 has 1 apple and 2 pineapples. A third table, “Orders”, lists the assortments ordered.
How can I summarize the data from the “Orders” table into how many of each individual fruit has been ordered (X apples, X pomegranates, X pineapples)?
Solved! Go to Solution.
Jun 29, 2020 08:31 PM
Hi @MikeG,
Welcome to Airtable Community! :slightly_smiling_face:
You can do that by using a Rollup Field in the Fruits table that rolls up the assortments.
If this helps you please mark this as Solution so others can see it.
BR,
Mo
Jun 29, 2020 08:31 PM
Hi @MikeG,
Welcome to Airtable Community! :slightly_smiling_face:
You can do that by using a Rollup Field in the Fruits table that rolls up the assortments.
If this helps you please mark this as Solution so others can see it.
BR,
Mo