Football/Soccer data recording

Dan_Halliwell · ‎Jul 31, 2022

Hi all,

I am seeking help with a base that records football data that I am a coach for.
I currently have a Base with two tabs. One is for all the players names, positions, address and general emergency contact information.
The second tab is the ‘Games’ tab. Here I record the team playing, Date/Time, Location, Type of Game (Tournament/League), Home or away option, who was in the team (Attendance) score and who scored. I am having huge issues trying to get the data to add up the goal scorers when they score more than 1 or 2 goals and how to best record that so it can show a total on an interface.

Is there anyone able to help please, happy to jump on a teams call to discuss if this helps. Airtable support are scratching their heads at this one at the moment or would seem to over complicate the system.

Thanks in advance

ScottWorld · ‎Jul 31, 2022

Welcome to the community, @Dan_Halliwell !

You can’t do what you want to do with only 2 tables.

You would need a 3rd table to create a many-to-many relationship. Here is Airtable’s guide on creating a many-to-many relationship:

Dan_Halliwell · ‎Jul 31, 2022

Hi Scott,

Thanks for your reply, very much appreciated. I will give this ago, limited knowledge and experience and I say so fingers crossed but will give it a go.

Thanks again

Dan

Dan_Halliwell · ‎Jul 31, 2022

Hi Scott,

Really Struggling to figure this out if I am honest. I might be over complicating it.

How would it be best to record a squad of 20 players, who will either be a Team A, B or C on a particular date as the teams change weekly, to then capture how many goals they scored each game. E.g. Today we had 2 x Teams of 8 players. Each team played 5 different teams and I recorded the result and goal scorers.

Is this possible to then capture on a 3rd tab that is easily configurable to recorded certain data against each player?

Best Regards
Dan

Dan_Halliwell · ‎Jul 31, 2022

This is what I am working off at the moment. you can see from each game I record the goal scorers. I have had to produce additional columns to record a single players 1st, 2nd and 3rd goal as I can only select one player at a time per column and was the only way I could capture that they scored more than 1 goal in that game.

I would love to include other recordable data such as Red/Yellow cards, substituted or not etc

Best Regards

Dan

Russell_Findlay · ‎Jul 31, 2022

I think @ScottWorld ’s solution will work fine here

You want three tables (at least)

Players
Fixtures
Appearances

The appearances table will be what is called a junction table - and is a combination of player and fixture

So if

You have a player, called Dan,
Playing in the game on Sunday of the 1st team vs Manchester United (easiest to call this Fixture 1) that will be an appearance -

and it is against that appearance that you will create fields for goals scored, yellow cards etc.

You may wish to create other tables to help you create the fixtures or tk summarise data by Team … but this is optional.

Making good use of forms / views and interfaces will help you make this an easy tool to use.

Best of luck.

ScottWorld · ‎Jul 31, 2022

Thanks, @Russell_Findlay! :grinning_face_with_big_eyes: :raised_hands:

Dan_Halliwell · ‎Jul 31, 2022

Thanks Russell very much appreciated. I think I get that and will see if I can implement that. It’s just getting it all to work together I guess, sounds easy reading your explanation ha but will give it a good go.

Many thanks

Russell_Findlay · ‎Jul 31, 2022

Not quite - I can show you an outline tomorrow.

But in short your fixture should link to the player appearance and not the player.

Then the player appearance will have a number field for goals … etc

Dan_Halliwell · ‎Jul 31, 2022

Thanks Russell, really appreciate your input. Once I see where and how I will memorise that but struggling to see how it will all then link in to the Interface in the correct way. Thanks again for your help