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!