Hello, Looking for a method to count records in another table. In this case, I have a table with part numbers and their associated product. In another table, I want to count for each product, how many parts are in it by counting the part numbers from the first table. TYIA
Solved
Count records in another table
Best answer by Vivid-Squid
Airtable being a database first, works a little differently than a spreadsheet. Since Parts and Products are separate concepts with unique metadata, they should be in separate tables. Then you link those records and you can use the native airtable features to count.
Hi @Alex_Ma,
You have the parts linked to the products? In the products table add a Count field to count the linked parts.
@Vivid-Squid Parts and Products are in 1 table. and I’d like to do the count in another table.The first image is what’s in table 1. The second is what I want to show in the 2nd table where I’m trying to figure out the formula for the # Parts column. Thanks
Airtable being a database first, works a little differently than a spreadsheet. Since Parts and Products are separate concepts with unique metadata, they should be in separate tables. Then you link those records and you can use the native airtable features to count.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.