Author Topic: how to model a one to many custom data type (Read 1121 times)

Michael McAndrew · January 26, 2009, 09:05:30 am

Hi there,

Does anyone have any wise words on how to model the following?

Some of the contacts in a database have (one or more) meeting rooms that they want to publicise.

I think I am right in saying that a searchable profile based on custom data would have trouble modeling contacts with more than one meeting room and wonder what the best way around this is. Is it maybe views 2 integration? And out of interest, is the ability to define a set of custom fields as 'one to many' a direction that you'd like to take the CiviCRM code in at some point? or are there some architectural problems with doing that?

Would be nice to be pointed in a right direction on this.

Thanks,
Michael

Dave Greenberg · January 26, 2009, 09:18:02 am

Michael - Civi version 2.2 includes initial support for "multiple instances of custom field values". When you create a group of custom fields - you can specify that the group of fields allows > 1 value (e.g. one contact -> many values of the custom field).

http://issues.civicrm.org/jira/browse/CRM-1527

There are some limitations in this initial implementation:
* only "Used For" = Contacts is supported (e.g. can't use this for custom fields extending Contributions, Activities or other record types)
* only "Display Style = Tab" is supported

If this seems to fit your requirement - would be very helpful if you configured this on a 2.2 install and pounded on it a bit prior to 2.2 beta.

Michael McAndrew · January 26, 2009, 09:22:51 am

Cool! - that passed me by - happy to do so

CiviCRM Community Forums (archive)

News:

Author Topic: how to model a one to many custom data type (Read 1121 times)

Michael McAndrew

how to model a one to many custom data type

Dave Greenberg

Re: how to model a one to many custom data type

Michael McAndrew

Re: how to model a one to many custom data type