Count all occurrences of String in Columns

[Ted_Charles_Bro]

Hello all, new to Airtable.

Trying to do something that would be pretty simple in sheets or excell.

I want to count the number of occurrences a string appears in a column. Say, equipment in inventory, and counting the number of times that gear appears in the table to compare the number used to the number in inventory.

In theory, I would love something like the “Count” column below. Where the name is the record, gear and quantity are referenced from another table.

Name | Count | Gear  | Quantity
item1| 2     | apple | 2
item2| 1     | orange| 1
item3| 2     | apple | 2

Any suggestions would be greatly appreciated!

[TheTimeSavingCo]

Hey Ted, is something like this what you’re looking for?

I’ve also put it together here. To view the setup, duplicate the base by clicking the title of the base at the top of the screen, then the three horizontal dots on the right, and then the “Duplicate Base” button.

Apologies if I’ve misunderstood!