Help

Football/Soccer data recording

Topic Labels: Automations
6250 19
cancel
Showing results for 
Search instead for 
Did you mean: 
Dan_Halliwell
4 - Data Explorer
4 - Data Explorer

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

19 Replies 19
Dan_Halliwell
4 - Data Explorer
4 - Data Explorer

Hopefully this is closer for when you look. I am presuming a lot of this is ‘Linked to another record’ and selecting the ‘Players’ to add them in. I think I understand all the separation tabs and then links but I am still struggling as to where I can accurately record Player A who scores 4 goals in one game and 4 in another game and so on to then have an overall total in the ‘Interfaces’ section.

image
image

Hopefully this will help you @Dan_Halliwell

It gives an overview of structure of the base and how the tables should connect to best be able to capture the data you need.

What it doesn’t show is how you can most easily input the data… the best thing is to get an understanding of the structure and then look at who enters the data and how

Soccer Team video explainer

and here is the layout (schema) of this base

image

Hi Russell,

This is superb and can’t thank you enough. I have seen the links and excited to look at this later on. The video will be superb so thanks again. Will let you know how I get on.

Many thanks

Hi Russell,

How would you be fixed for a Teams Call?

Hi - I may struggle on this. I am trying to fit I. These comments on commutes etc.

I don’t really do consulting work but happy to help with any specifics

Hi,

Completely understand and apologies for requesting. I have copied a lot over now but needed to go through each page and each column setup to ensure I had the correct code and function in place. I just thought it might be quicker if I shared my screen and we quickly went through it rather than going back and forth as I am sure this is not what you expected. Really do appreciate your help with this. The team will be made up

No worries and happy to help (otherwise I wouldn’t be here) - just this is the practical best way for me to do it.

Fire away further questions - or I can share the prototype I set up … the challenge is that your needs will no doubt be a little different to what I have understood they may evolve.

Best of luck

Hi Russell,

You are superb! if you would mind sharing me the base so I can configure it too as I can then see how the coding works on the formula. This would be amazing and thanks again.

Many thanks

Dan

Russell_Findlay
8 - Airtable Astronomer
8 - Airtable Astronomer

here you go

Airtable - Sports Team

if you copy the base then you can see what you wish to use.

Hi Russell,

Sorry for the delay in getting back. I wonder if i ask if you would be willing to jump on a teams call for me to explain the setup and see how you think this would look. I must admit my learning style is physically doing it and given the requirement i need i suspect this would be easier to discuss live time. Would this be OK with you? Could save lots of explaiming too but naturally only if you are happy to.

Best
Dan