CiviCRM Community Forums (archive)

Hi,
I am needing to create a new custom field that is an option list or drop-down where the values in the list are pulled from a different table/subquery?
Is this possible to do, if so, how?

Thanks!

Well here's the case, and maybe you can tell me what you think... and any new concepts this idea would introduce.

- Consider an event that is something like participating at a camp.
- Assume possible participant roles to be either a camper or a counselor
- Upon initial registration for the event, whether as a camper or counselor, the participant status should be set to pending...
- Pending status means there is an action to follow by the administrator, in this case it would be the camp registrar, to determine the final selection of who is actually going to attend and participate at the camp

So I think CiviCRM can easily take it to this point, correct?

Here's part 2... the interactive part where someone managing the event would solidify the participants and roles, and pair campers to counselors...

- First step, finalize the list of participants of campers and counselors... simply setting the participant status for the event to "confirmed" or something similar
- You then would have two types of participants registered under the same event, but now it is critical for those to be linked in order to finalize the event so that campers can be assigned counselors, and vice versa.
- As an example, all registered participants to the event having role = Camper, should have a corresponding field automatically created that defines the set relationship of the camper to a counselor for the event... this is more or less a type of relationship
- The same requirement would be true for counselors, except they could have multiple campers assigned to them

The only way to achieve the above thing would be by having dynamic field elements that can driven by custom rules/workflows based on simple to define guidelines!

Even though the example is specific, I would think the need for non-profit organizations to have a feature like this would be extremely value added. Getting an event up and running is one thing, but actual management and operating of that event efficiently requires there to be some basic enhanced features like this.


Lobo - can you tell me whether this idea has been proposed in the past, and if so, what the general thinking/feedback for it has been?

I personally think the concept is simple and generic enough where a basic design of this feature could be implemented - if it were sponsored and had the backing/support of the community.

Do you think others would agree?

Great... just so I know, when is the best time to get on IRC for chatting about this?

jeeks - they have short days in California. was that meant to be 4am to 10 pm? 

short days do rock