FileMaker me?
February 7, 2007 12:59 PM Subscribe
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...
...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...
Response by poster: 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
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
posted by jazon at 3:01 PM on February 7, 2007
Response by poster: 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
http://rapidshare.com/files/15434822/match_data.fp7.html
posted by weaponsgradecarp at 4:02 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
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
posted by jazon at 10:44 AM on February 8, 2007
This thread is closed to new comments.
posted by kc8nod at 2:29 PM on February 7, 2007