Hi, I'm working on adding game schedules to a calendar for a high school. Each game event on the calendar includes an embedded map showing where the game is being played.

I'm hoping to be able to create a CCK field that provides a drop-down list of about 20 schools so I can just pick the appropriate one for that game.

Any suggestions would be appreciated; I know that there's an in-development module called GMap Addons that's supposed to include a CCK field which looks promising, but it's not compatible with Drupal 6.22 yet.

Comments

SurajHo’s picture

SurajHo commented

Hi, I don't know if you've found a solution yet, but I've had the exact same problem for the same situation. I solved it with a bit of a work around. What I did is the following:

- I show all the games that are to be played and have been played in a View ("game schedule" View) which shows fields like "home team", "guest team", "score", etc. which are taken from the corresponding nodes.
- These nodes are of a content type "game".
- One of the CCK fields of this content type is a node reference (with a select list widget)
- This node reference references to a content type "Sportsgymnasium" (or do not know the exact translation of the Dutch word of "Sporthal", as we do not have school sports competitions). But in your case you could call your content type "School"
- This content type only consists of a Title and an Embed Google Maps field
- With this "School" content type you make a node for every school
- Now when you create a new node of content type "game", the select list of the node reference field consists of all the nodes of content type "school"
- Then in your "game schedule" view, you add the node reference field under "Fields" and now you have a neat and clear game schedule with a link to the google map of the school the game is held.

Brainwrap’s picture

Brainwrap commented

SurajHo--thanks so much for the workaround; I'll give it a shot and will let you know how it works out! Very clever.