Hi, I’m looking to create airtable for youth football (soccer) team I’m coaching. I want to keep stats about number of games each player had, number of goals and assists they had.
I have a table with all my players in separate rows, and a table with games they played. In the latter one I need a column with goal scorers. I have used Link function to link player name which then is counted against each name showing a number. So that works fine, as long as each player scored only once in a game or had one assist. But if my striker had a hat-trick I’m not able to link his name 3 times in a cell… Is there any other way to do it?