Author Topic: Ability to reassign custom data fields to other custom data groups (Read 1817 times)

Andrew_Mallis · February 10, 2009, 02:22:11 pm

When Creating Profiles, especially in early stage layout, it common to assign custom data to the wrong group.
It is equally common to decide after the fact that fields should instead be moved to another group.

While this can be achieved by editing the 'civicrm_custom_field' and changing the 'custom_group_id' it would be preferable to have a way to do this in the UI somehow.

In the edit field window, a field with a dropdown of available custom data groups could allow this.

Dave Greenberg · February 10, 2009, 07:20:07 pm

Andrew - If you are using SQL to change the group which a custom field belongs to, a caveat.... When custom fields are added to a custom group that we also modify the DB schema - adding a corresponding column to the civicrm_value_* table which will store the values for that group.

Kurund Jalmi · February 10, 2009, 10:32:47 pm

Also note that in civicrm_value_* table we have "entity_id" column which is usually foreign key reference to group type. So if you have created custom group of type "Contact" and now you want to change it to "Contribution", then you will have to change foreign key reference from contact id to contribution id.

So to avoid complications, IMO creating fresh custom group would be better solutions..

Kurund

CiviCRM Community Forums (archive)

News:

Author Topic: Ability to reassign custom data fields to other custom data groups (Read 1817 times)

Andrew_Mallis

Ability to reassign custom data fields to other custom data groups

Dave Greenberg

Re: Ability to reassign custom data fields to other custom data groups

Kurund Jalmi

Re: Ability to reassign custom data fields to other custom data groups