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
Jul 28, 2020 10:24 AM
Hi! I have 2 tables - one with a long list of individual clients, and another listing “teams”, which the clients belong to.
The client table has 2 fields: “Team” & “meal preference”.
I want to summarise the meal preference data in the Team table table, organised to show the total number of each meal preference for each team.
I have set up a pivot table block, which does summarise this, but I don’t know how I can pul this info into the “Team” table.
Any assistance greatly appreciated!
Jul 28, 2020 11:38 AM
For each meal preference, create a Count field in the Team
table which only counts the linked clients
if preference = x