Hi all,
I am creating a website for a group of golf courses and am trying to come up with a strategy for displaying the different scorecards.
Each course will have it's own page and the scorecard will be a block on that page. The problem is that each course has a different number of tee positions with different names that must be shown. (see example data below)
Do you think I should;
a) Create a content type (CCK) with the max number of tee positions (6) with a different field for each one (ex. tee1hole1, tee1hole2, tee2hole1, tee2hole2, etc) and find a way to hide fields that have no data
b) create one content type for the scorecard to hold the information that does not repeat like course name, numbers for men's and ladies par and handicap and then create another for tees that would reference the scorecard node
or
c) Do something entirely different
I had considered using a graphic for each but they want to be able to update the card to reflect the days tee position.
Thanks for your help
Course Name
HOLE RATE/SLOPE 1 2 3 4 5 6 7 8 9 OUT 10 11 12 13 14 15 16 17 18 IN TOTAL
GOLD 71.6/131 435 157 485 320 398 383 493 160 390 3221 537 175 506 189 393 410 347 389 370 3316 6537
BLUE 69.8/121 400 147 455 305 376 356 470 157 377 3043 503 142 495 158 377 379 320 367 345 3086 6129
WHITE 68.0/116 369 133 436 275 359 325 455 142 366 2860 464 142 454 148 358 346 301 320 327 2860 5720
HDCP 5 15 3 13 7 11 1 17 9 4 18 2 16 12 6 14 8 10
PAR 4 3 5 4 4 4 5 3 4 36 5 3 5 3 4 4 4 4 4 36 72
RED 69.5/122 309 113 405 255 288 285 400 131 311 2497 397 119 401 114 327 248 277 298 273 2454 4951
LADIES PAR 4 3 5 4 4 4 5 3 4 36 5 3 5 3 4 4 4 4 4 36 72
LADIES HDCP 5 17 1 13 9 11 3 15 7 4 18 2 16 8 10 14 6 12
Comments
Matrix module may help here
My initial thoughts would be to use the matrix CCK module to represent a tee/hole matrix for each course.
I had looked at the matrix
I had looked at the matrix module briefly but didn't really understand it's usage. Will it format delimited data into tables?
matrix
It will give you a grid for a user to input and maintain the data, not extract fields from delimited data.
Data entered into the matrix would be stored in a custom cck table.
I'd install that module and give it a go.
matrix
It will give you a grid for a user to input and maintain the data, not extract fields from delimited data.
Data entered into the matrix would be stored in a custom cck table.
I'd install that module and give it a go.
thanks
I've been looking at the matrix module and it seems right except for one thing, on some of the courses, the names of the tee positions are different. Is there a way to dynamically assign the left column or not show the labels for rows?
not show the labels for rows
> not show the labels for rows
theming would be one way, but how would you know when the names of tee positions are different? at what point in data entry? then would you have some field to store that info in the CCK node type?
Hi bazzaboy, Basically, for
Hi bazzaboy,
Basically, for each course there are 3-5 sets of tees. One course may have names like Blue, White and Red while another may have Championship, Men's and Woman's.
The only way I can think of is to define the rows as Tee 1, Tee 2 etc. and have the first column called something like Tee Name where the name could be entered. Then I'll have to go through the theme to try to hide the Tee 1, Tee 2 labels.
Maybe I would be better off trying to create 1 cck field for each item but that seems like it would be incredibly complex.
sounds like you need a 5 x 19 matrix
row one being the labels, then the next 18 being the details per tee/label.
problem with that is letting users enter the row one values, select list would be better to control possible values.
Maybe instead could have 5 fields which are select list default value being 'not used', that way the user must select values from the set. Or if there are only so many possible sets just list them, 'blue,white,red','championship etc'. This still leaves a problem with validating the input.
Barry