Author Topic: How to change the 'used for' field on a Custom fieldset from Contacts (Read 992 times)

peverist · January 02, 2011, 11:50:32 pm

I am setting up a new CiviCRM and created a custom field set with a lot fields only to realise I set the 'Used For' field to Contacts instead of Individual - these fields don't apply to Household or Organisation. When I try to change it in the custom fieldset settings, the field is not open for update even though other custom field sets I have created using other values can be changed.
Does anyone know why the Used For field can't be changed if initially set to Contacts?
I am assuming it may be because a record using these custom fields has been created - yet I have deleted the only contact that used the new fields and it still can't be updated.

Alternatively, is there an easy way to copy the fields from the existing fieldset to a new fieldset then I'll delete the original?

Thanks
Phil

Yashodha Chaku · January 03, 2011, 12:38:07 am

peverist :

Quote

I am assuming it may be because a record using these custom fields has been created - yet I have deleted the only contact that used the new fields and it still can't be updated.

To avoid complications we do NOT allow changing of Used For field custom fields once created. Your best/safest bet is to to delete the old one and start afresh with a new custom group with the correct custom group settings.

However, you could also run the following SQL ( though not a recommended approach) :

Code: [Select]

UPDATE civicrm_custom_group SET extends = 'Individual' WHERE civicrm_custom_group.id = x
where x is the primary id of the custom group that you need to change.

HTH
-Yashodha

CiviCRM Community Forums (archive)

News:

Author Topic: How to change the 'used for' field on a Custom fieldset from Contacts (Read 992 times)

peverist

How to change the 'used for' field on a Custom fieldset from Contacts

Yashodha Chaku

Re: How to change the 'used for' field on a Custom fieldset from Contacts