CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • How to empty custom data fields after event
Pages: [1]

Author Topic: How to empty custom data fields after event  (Read 315 times)

tobbe

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.16
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.73
  • PHP version: PHP 5
How to empty custom data fields after event
March 11, 2014, 04:06:00 am
Hi all!

I have some custom fields where I ask about food allergies. According to Finnish law about keeping registers I have to destroy all documentation about allergies after the event, but since it is stored in an electronic form, and I still would like to keep attendance records electronically, erasing the event afterwards is not an option.
I did search the forum, but did not find anything relating to this...

To sum it up, what I want is the following:
  • Participant registers, enters info, allergies etc.
  • Event happens
  • Erase custom fields regarding allergies
  • Retain everything else

I guess I could go in manually and edit the filed afterwards, but with more that 30 attending, and many events, I would like to avoid that.

Thanks for any suggestions!

Tobbe

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: How to empty custom data fields after event
March 11, 2014, 04:38:10 am
It sounds like you still want the custom fields as you have more events coming that use those same fields.

If that is so, you should create a profile containing the relevant custom fields.

Assuming they are participant custom fields, go to Event>Find Participants and search for the participants of your event.
Choose All XX recordsand Batch Update Participants via Profile from the actions list.
Select the profile you created for this purpose and follow the instructions on the profile update screen.


If the custom fields are contact fields not participant fields you will need to use advanced search, specifying the event and showing results as contacts, rather than Find Participants.

 



tobbe

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.16
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.73
  • PHP version: PHP 5
Re: How to empty custom data fields after event
March 11, 2014, 05:04:13 am
Hi

Yes! Your method for batch update participants via profile works like a charm!
Sorry to have left out relevant info, but I'm still very new to CiviCRM and all it's hidden secrets.


I wish it could be automated so it would do it by itself when the event is over, but one can dream, right?

Thanks!

Tobbe
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • How to empty custom data fields after event

This forum was archived on 2017-11-26.