FileMaker me?

February 7, 2007 12:59 PM

FilemakerFilter: I need some database help, because I am a n00b. My FIRST robotics team is creating a database of teams at our regional event, for scouting...

...but I've never used FileMaker before.

Each round of the robotics competition has six randomly selected teams playing on two alliances

For each match, I want six computers in the stands, each with a person collecting data on one team that match.

Right now, I have a set of fields set up that have data on each match as follows:

Team # the person is scouting
Who their alliance partners are
color of that alliance (red/blue)
who the opposite alliance is (3 team #s)
a bunch of checkboxes and dropdowns that define the abilites of the robot you're watching
text comment field
win/loss/tie dropdown

I want to be able to have six computers simultaneously be entering data into this form over a network, match by match, and then be able to pull up a summary view from a 7th machine that will sort the data by showing a list of team #s, what matches they played in, and their ability data from each match.

my filemaker database file can be found here:

http://www.cheapfilehost.com/file.php?file=d8dd2740e6562d25bfbee444b5a6edc3

and a diagram of what i'm trying to do here:
http://img248.imageshack.us/img248/6572/diagramww2.jpg

Thanks for your help...

posted by weaponsgradecarp to computers & internet (8 comments total)

Some other teams have done this before, but I couldn't say whether or not they used filemaker. I'll bet that someone on the Chief Delphi forums can point you in the right direction.
posted by kc8nod at 2:29 PM on February 7, 2007

I've been on delphi...no one has replied yet, hence my other source of all knowledge, MeFi :)
posted by weaponsgradecarp at 2:32 PM on February 7, 2007

I tried to download your database file, but got a 404 not found.
posted by jazon at 3:01 PM on February 7, 2007

weird...i'll repost
posted by weaponsgradecarp at 3:36 PM on February 7, 2007

New link for .fp7 download

http://rapidshare.com/files/15434822/match_data.fp7.html
posted by weaponsgradecarp at 4:02 PM on February 7, 2007

IS this what you want to do:
Flikr ScreenShot
posted by jazon at 4:27 PM on February 7, 2007

What I did was move the match information up into the Sub Summary by Match # area and drew a background behind it to differentiate it from the match # strip.

I can send you the modified file if you want... my contact info is in my profile
posted by jazon at 4:30 PM on February 7, 2007

(and to close out the thread, I did send the file and weaponsgradecarp was very happy).
posted by jazon at 10:44 AM on February 8, 2007