Developing basketball stats program with shot chart

[PSYHUB]

I want to create a "shot chart" for a basketball scoring and stats program in Filemaker. I'd like to create fields that when clicked on enter the player number and indicate by a change in format (e.g. bold vs plain, bordered vs. not, etc) whether the shot was made or missed, and transfer the appropriate data into the players scoring line (2pts or 3pts). Is this possible in Filemaker? Does anyone have ideas about how this could best be accomplished? This type of shot chart is not uncommon, but I have never seen one in a Filemaker application.

 

[marty1452]

Yes this is possible. Scripting and graphics are going to be required.

How do you picture your screen layout? Can you hand draw this and fax it to me at 435-635-6914?

Or post more details on the operation as you see it.

Marty

 

[PSYHUB]

Thanks for your response.

My thought is I would draw a half court diagram including the 3pt arc (touching the top of the key as it does in High School and College). I would like to have team player lists on both sides of this half court diagram with the players currently in the game sorted to the top of the list. The process would be: Click on a player name when they shoot, then on the court at the location where the shot is taken. The player's number needs to appear on the court where the shot was taken from. Each shot would be recorded in his or her stat column as an attempt. A third step would be to click on a make or miss button that would either add points to the column and change the text color (eg. to red from black) or do nothing, indicating made and missed shots from each player at specific locations on the court. Obviously, if beyond the 3pt arc they would add 3 pts to the stats column. These shots could then be selected by quarter, half, or game in a shot-chart report.

I've played with this some by creating a similar court diagram and using multiple text fields (small two-character fields) set side by side like bricks covering the entire diagram. I am thinking I will also need to create multiple transparent buttons that will overlay these fields and set in motion a script transfering the active player's number to this field while also updating the stats file after the make or miss button is pushed. Am I on the right track or is there a better way?

 

[marty1452]

This is all possible with scripts. You could click on the player, a script writes their name to a name field, then push the graphic button in the shot zones which copies the shot location to a shot field, then, pressing the hit or miss button which is scripted to locate the players record, using a setfield command it registers the shot zones and the hit or miss and maybe resets the values to zero.

Do you have questions about structuring your database to make all of this work or just the scripting?

Tell me about your plans for structuring this. How many databases and what are their names?

Will you track more than one team?

Let me know.

Marty