CiviCRM Community Forums (archive)

if i had to guess, some custom code and tables along with civicrm might help out quite nicely.

The scores / dates / other info can be kept in a multi-record custom group (or an activity with custom data)

you can then build a custom batch input form to enter these values for a group and expose this form to the captains

lobo

I'll be happy to share the results - I'll probably have to do undergo some "personal growth" to figure out how to do the things mentioned, but with you and Lobo commenting, I think I can stumble through this. I'll report back when I come up for air. Thanks for the pointers.

Rick

i think the suggestion from X was that if you have the fields on Participant Record - one row - then the golfer would participate in 40 events in a year - 40 Participant records = 40 rows

I would probably have gone down the Activity route but with the same intended outcome.

Namely, one item (Activity or Participant record) for each 'tournament'

Then you should be able to wrangle your table out of Views of Custom Report

hope that helps a bit

Hi,

Not sure it's what you did already, but you should add the custom fields to the participant, not to the event.

X+

Just continuing with setting up scoring, etc. for weekly golf tournaments for lots of folks.

Since this is my first attempt at designing custom input and output forms, requiring custom queries from the civi db, and even though everyone else may already know this, I didn't. It might be helpful for the next newbie who tries something like this.

So a couple of key Civi database tables this has generated or modified are:

civicrm_custom_group - now has another record for the Individual_Scoring custom field group, which extends participant in a golf tournament

civicrm_custom_field - now has records for each of the fields I've set up for this custom group

civicrm_value_individual_scoring_3 A new table that contains the actual values for each field for each participant for each tournament

I think the next step will be to do a query that joins that last table with contact and tournament tables and selects rows for   a particular tournament for individual score info, with columns for name, tournament date, gross score, net score, points, etc. That would be the reporting function, and then I need to make some sort of data input form with the same stuff, but with the ability to edit and fill in some of the columns.

Lobo's post refers to this as a Custom Batch Input Form, and X suggests custom ajax edit in place code, or using slickgrid, so I'll report back when I've figured out what all that means and how best to do this.

I'm only able to spend a small amount of time on this one item, so I'm keeping a bit of a log of the steps here, both to jog my memory as well as to allow others to follow along. Later I'll produce a brief end to end summary. 

Also, even though I started this with the idea of using profiles for data entry, I'm not positive profiles will be involved, so maybe after this is complete (and if it's useful) Dave or Don can tell me where I should re-post this.

See, that's what this community is all about!

X knows what I want to do, I tell everyone how I think I should do it, and then X tells me the smart way to do it. Thanks Xavier. I'll pay back by posting the synopsis!!