Answers.Body: <p>Hmm I think you should be OK but carefully....and make sure you are not hit by any of the VALUE_SEPARATORS?</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-09T11:04:58.433Z
Answers.Text: Thanks Erik, I'd seen that some of the options will need separators in place, is there guidance anywhere on how to handle these?
Answers.UserDisplayName: Craig Almond
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-09T11:14:26.330Z
Answers.Text: I think I have only done that in code, not directly in SQL....let me see
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-09T11:15:34.083Z
Answers.Text: Check this one: https://civicrm.stackexchange.com/questions/20515/what-character-is-value-separator
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-10T12:10:18.043Z
Answers.Text: Will do (or at least I'll ask Jade to). Thanks Erik!
Answers.UserDisplayName: Craig Almond
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-08T17:13:44.583Z
Answers.LastActivityDate: 2020-01-08T17:13:44.583Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>I've got a site where custom data has been created for Particpant records.</p>
  
  <p>And the fieldsets have been made available for all event types.</p>
  
  <p>The site in question relies heavily on segmenting events by type, and some of the participant fieldsets are not applicable/suitable for some event types</p>
  
  <p>However the empty fieldsets are appearing in the confirmation emails for the events they are not appropriate for and causing confusion to end users.</p>
  
  <p>So...My question is...
  am I safe updating the values in the civicrm custom group tables for the fields
  EXTENDS ENTITY COLIUMN ID
  and
  EXTENDS ENTITY vALUE
  for the relevant data sets</p>
  
  <p>I guess this is the reverse of the question asked here
  <a href="https://civicrm.stackexchange.com/questions/21500/can-i-change-settings-for-a-custom-field-set-for-participants-without-losing">Can I change settings for a custom field set for participants without losing any data?</a></p>
  
  <p>Can anyone advise me of any potential pitfalls?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-09-21T12:50:09.377Z
Comments.Text: I'd say that this is actually a bug. Fields should only display on the confirmation email when they have been used on the event registration form. I can't see a use case for any other behaviour.
Comments.UserDisplayName: Graham
Tags: <custom-fields>
Title: Updating Custom Data Fieldset Settings via php my admin
ThreadText: # Updating Custom Data Fieldset Settings via php my admin
  
  (Asked by: username_0 on 2020-01-08)
  
  I've got a site where custom data has been created for Particpant records.
  
  And the fieldsets have been made available for all event types.
  
  The site in question relies heavily on segmenting events by type, and some of the participant fieldsets are not applicable/suitable for some event types
  
  However the empty fieldsets are appearing in the confirmation emails for the events they are not appropriate for and causing confusion to end users.
  
  So...My question is...
  am I safe updating the values in the civicrm custom group tables for the fields
  EXTENDS ENTITY COLIUMN ID
  and
  EXTENDS ENTITY vALUE
  for the relevant data sets
  
  I guess this is the reverse of the question asked here
  [Can I change settings for a custom field set for participants without losing any data?](https://civicrm.stackexchange.com/questions/21500/can-i-change-settings-for-a-custom-field-set-for-participants-without-losing)
  
  Can anyone advise me of any potential pitfalls?
  
  **Tags:** custom-fields
  
  > **Comments:**
  > **username_1**: I'd say that this is actually a bug. Fields should only display on the confirmation email when they have been used on the event registration form. I can't see a use case for any other behaviour.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2020-01-08. Score: 1 | Accepted answer
  
  Hmm I think you should be OK but carefully....and make sure you are not hit by any of the VALUE\_SEPARATORS?
  
  > **Comments:**
  > **username_0**: Thanks Erik, I'd seen that some of the options will need separators in place, is there guidance anywhere on how to handle these?  
  > **username_2**: I think I have only done that in code, not directly in SQL....let me see  
  > **username_2**: Check this one: https://civicrm.stackexchange.com/questions/20515/what-character-is-value-separator  
  > **username_0**: Will do (or at least I'll ask Jade to). Thanks Erik!  
  
  ---
  
  