Answers.Body: <p>I would recommend you to create custom field associated along with participant record - where you can also specify the Event type </p>
  
  <p>Once you have created the custom field as per your requirement then try to create a new profile for the participant custom fields </p>
  
  <p>Then you can add the created profile against Event </p>
  
  <p>Also while creating the custom field make it searchable so you can view the column in the report </p>
  
  <p><a href="https://i.sstatic.net/NamoG.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/NamoG.png" alt="enter image description here"></a></p>
  
  <p>I guess this helps !!!</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-14T08:10:44.607Z
Answers.Text: Many thanks for your answer. I am not sure if I understand you correctly. Sorry, but I am still pretty new to CiviCRM and haven't grasped full understanding of how all functionality works and links together.
Answers.UserDisplayName: TonV
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-14T08:11:07.483Z
Answers.Text: What I think you are telling me is following: 
  
  1. Create custom field set
   Administer -> Customize Data and Screens -> Custom Fields -> Add Set of Custom Fields
  
  Associate custom fields with Participant record:
  Used For:
   Participants
   Participants (Event Name)
   Participants (Event Type)
   Participants (Role)
  
  I am not sure wich option to select and what the difference of those 4 options is.
Answers.UserDisplayName: TonV
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-14T08:11:15.203Z
Answers.Text: 2. Create a new profile for custom fields from step 1 above
  I do not understand how I could create a profile from the newly created Custom Filed Set in step 1
  
  3. Add created profile to Event
  Wouldn't know where and how to do so. I guess it should be done on the Info and Settings tab of the Event, right? However, I don't see such a possibility on that screen.
  
  
  When we implement the above, how would we be able to list the total time spent for each trainer on trainings in a certain time period?
  
  
  I really value your sharing of information. Many thanks in advance.
Answers.UserDisplayName: TonV
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-17T08:24:08.637Z
Answers.Text: Hi @TonV - did you manage to find the way or do you need step by step process for the same ?
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-17T09:17:33.457Z
Answers.Text: Hi @Ramesh - Haven't figured it out yet. Some extra pointers would definitely help. Thank you!
Answers.UserDisplayName: TonV
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-17T10:33:22.977Z
Answers.Text: ok then let me do the same against Civi Demo and will send you the link please check this before demo site gets refreshed -
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-17T10:43:06.390Z
Answers.Text: Custom Field Example : http://dmaster.demo.civicrm.org/civicrm/admin/custom/group/field?reset=1&action=browse&gid=7
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-17T10:44:08.860Z
Answers.Text: Profile participant Event Time:    http://dmaster.demo.civicrm.org/civicrm/admin/uf/group?reset=1
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-17T10:44:32.407Z
Answers.Text: Included in Event : http://dmaster.demo.civicrm.org/civicrm/event/manage/settings?reset=1&action=update&id=3
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-17T12:23:18.770Z
Answers.Text: Hi @Ramesh, Thank you so much for explaining ! Really helpful.
Answers.UserDisplayName: TonV
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-17T12:24:34.057Z
Answers.Text: Would the last one 'Included in Event' mean that the participant will see the Event Time field on his/her registration form when signing up?
Answers.UserDisplayName: TonV
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-17T12:59:55.320Z
Answers.Text: Yes - if you don't want the participant to view. Then, you don't want to add in the Event - still you need to add the time manually
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-13T15:15:10.463Z
Answers.LastActivityDate: 2016-05-17T10:53:53.800Z
Answers.LastEditDate: 2016-05-17T10:53:53.800Z
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Answers.Body: <p>Take a look at <a href="https://civicrm.org/extensions/civivolunteer" rel="nofollow">CiviVolunteer</a> which has options for recording time involvement. It may not suit your needs but worth understanding what it offers.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-13T21:58:24.217Z
Answers.LastActivityDate: 2016-05-13T21:58:24.217Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>I would create custom Activities for both the trainer and participants, for example, Training- Making Sock Puppets, with the Trainer as Assigned for the Activity and the participant as With (i.e., the 'target' of the Activity). Then, every Participant in the training Event who actually attends and completes the training can be updated via Actions as having completed the Activity - depending on the person's Event role (trainer or participant).  </p>
  
  <p>UPDATE - There is a way to aggregate Activities - via Grouping and Sorting in Reports - using the Extended Activities report, installed using  Eileen's excellent Extended Reports extension at <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport" rel="nofollow">https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport</a> . The extension has been recently updated. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-14T02:38:48.830Z
Answers.Text: I think the data structure is the most ideal - but I'm not sure how you'd meet the requested reporting requirements for this with out-of-the-box Civi.  I don't think you can aggregate the time spent per event if the time is stored in activities.
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-14T08:15:36.663Z
Answers.Text: As far as I understand it would be possible to aggregate time spent stored in activities (Duration) using the Case Time Spent Report. So it would be possible to generate totals for training hours per trainer. I am not sure if it is possible to do so for Events
Answers.UserDisplayName: TonV
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-15T00:56:00.283Z
Answers.Text: Jon you're right about Civi out of the box not doing aggregates for Activities. I do an Activity report weekly for membership signups as an Activity which I create by exporting to Excel to sort and do counts. Adding a Pivot Table type report template for Activities built into Civi would be a big plus for me.
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-23T19:55:56.287Z
Answers.Text: See my update in the answer above. Duration (time) is a field in an Activity. However, there is not (yet) an option in Extended Activities reports to Group or Sort by Duration.
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-13T17:50:02.160Z
Answers.LastActivityDate: 2016-05-23T19:48:51.587Z
Answers.LastEditDate: 2016-05-23T19:48:51.587Z
Answers.UserDisplayName: Joe McLaughlin
Body: <p>One of the activities of our organization is providing workshops etc. to the public. In order to facilitate all processes involved I have setup a coupe of events in CiviCRM. Each event represents a certain course, training or workshop. Next I have added participants (contacts) to those events with the role of Attendee. The event/workshop also requires one or more trainers so I added trainers (contacts) with the role of Trainer to the event/workshop. A requirement is that we have an overview/summary of each event showing who is involved in a certain event/workshop (e.g. who is/are the trainer(s), people taking care of logistics, participants, etc).</p>
  
  <p>We would like to track the training time spent for each trainer and also to be able to generate a report listing e.g. the training name, date, training time spent and also the total training time for each trainer per (selectable) period (e.g. from/to date).
  What would be the best way to record the training times for each trainer? Could or should this be done in the event itself (e.g. custom fields) or should we add activities to each assigned trainer and aggregate activity durations? Any other solutions to accomplish this?</p>
  
  <p>Many thanks in advance for your kind attention.</p>
  
Tags: <civievent><civireport><activities><best-practice>
Title: Recording/ tracking time spent on Events
ThreadText: # Recording/ tracking time spent on Events
  
  (Asked by: username_0 on 2016-05-13)
  
  One of the activities of our organization is providing workshops etc. to the public. In order to facilitate all processes involved I have setup a coupe of events in CiviCRM. Each event represents a certain course, training or workshop. Next I have added participants (contacts) to those events with the role of Attendee. The event/workshop also requires one or more trainers so I added trainers (contacts) with the role of Trainer to the event/workshop. A requirement is that we have an overview/summary of each event showing who is involved in a certain event/workshop (e.g. who is/are the trainer(s), people taking care of logistics, participants, etc).
  
  We would like to track the training time spent for each trainer and also to be able to generate a report listing e.g. the training name, date, training time spent and also the total training time for each trainer per (selectable) period (e.g. from/to date).
  What would be the best way to record the training times for each trainer? Could or should this be done in the event itself (e.g. custom fields) or should we add activities to each assigned trainer and aggregate activity durations? Any other solutions to accomplish this?
  
  Many thanks in advance for your kind attention.
  
  **Tags:** civievent, civireport, activities, best-practice
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2016-05-13. Score: 2 | Accepted answer
  
  I would recommend you to create custom field associated along with participant record - where you can also specify the Event type
  
  Once you have created the custom field as per your requirement then try to create a new profile for the participant custom fields
  
  Then you can add the created profile against Event
  
  Also while creating the custom field make it searchable so you can view the column in the report
  
  [![enter image description here](https://i.sstatic.net/NamoG.png)](https://i.sstatic.net/NamoG.png)
  
  I guess this helps !!!
  
  > **Comments:**
  > **username_0**: Many thanks for your answer. I am not sure if I understand you correctly. Sorry, but I am still pretty new to CiviCRM and haven't grasped full understanding of how all functionality works and links together.  
  > **username_0**: What I think you are telling me is following:   1. Create custom field set  Administer -> Customize Data and Screens -> Custom Fields -> Add Set of Custom Fields  Associate custom fields with Participant record: Used For:  Participants  Participants (Event Name)  Participants (Event Type)  Participants (Role)  I am not sure wich option to select and what the difference of those 4 options is.  
  > **username_0**: 2. Create a new profile for custom fields from step 1 above I do not understand how I could create a profile from the newly created Custom Filed Set in step 1  3. Add created profile to Event Wouldn't know where and how to do so. I guess it should be done on the Info and Settings tab of the Event, right? However, I don't see such a possibility on that screen.   When we implement the above, how would we be able to list the total time spent for each trainer on trainings in a certain time period?   I really value your sharing of information. Many thanks in advance.  
  > **username_1**: Hi @username_0 - did you manage to find the way or do you need step by step process for the same ?  
  > **username_0**: Hi @Ramesh - Haven't figured it out yet. Some extra pointers would definitely help. Thank you!  
  > **username_1**: ok then let me do the same against Civi Demo and will send you the link please check this before demo site gets refreshed -  
  > **username_1**: Custom Field Example : http://dmaster.demo.civicrm.org/civicrm/admin/custom/group/field?reset=1&action=browse&gid=7  
  > **username_1**: Profile participant Event Time:    http://dmaster.demo.civicrm.org/civicrm/admin/uf/group?reset=1  
  > **username_1**: Included in Event : http://dmaster.demo.civicrm.org/civicrm/event/manage/settings?reset=1&action=update&id=3  
  > **username_0**: Hi @Ramesh, Thank you so much for explaining ! Really helpful.  
  > **username_0**: Would the last one 'Included in Event' mean that the participant will see the Event Time field on his/her registration form when signing up?  
  > **username_1**: Yes - if you don't want the participant to view. Then, you don't want to add in the Event - still you need to add the time manually  
  
  ---
  
  ### Answer by username_2 on 2016-05-13. Score: 1
  
  Take a look at [CiviVolunteer](https://civicrm.org/extensions/civivolunteer) which has options for recording time involvement. It may not suit your needs but worth understanding what it offers.
  
  
  ---
  
  ### Answer by username_3 on 2016-05-13. Score: 1
  
  I would create custom Activities for both the trainer and participants, for example, Training- Making Sock Puppets, with the Trainer as Assigned for the Activity and the participant as With (i.e., the 'target' of the Activity). Then, every Participant in the training Event who actually attends and completes the training can be updated via Actions as having completed the Activity - depending on the person's Event role (trainer or participant).
  
  UPDATE - There is a way to aggregate Activities - via Grouping and Sorting in Reports - using the Extended Activities report, installed using Eileen's excellent Extended Reports extension at <https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport> . The extension has been recently updated.
  
  > **Comments:**
  > **username_4**: I think the data structure is the most ideal - but I'm not sure how you'd meet the requested reporting requirements for this with out-of-the-box Civi.  I don't think you can aggregate the time spent per event if the time is stored in activities.  
  > **username_0**: As far as I understand it would be possible to aggregate time spent stored in activities (Duration) using the Case Time Spent Report. So it would be possible to generate totals for training hours per trainer. I am not sure if it is possible to do so for Events  
  > **username_3**: Jon you're right about Civi out of the box not doing aggregates for Activities. I do an Activity report weekly for membership signups as an Activity which I create by exporting to Excel to sort and do counts. Adding a Pivot Table type report template for Activities built into Civi would be a big plus for me.  
  > **username_3**: See my update in the answer above. Duration (time) is a field in an Activity. However, there is not (yet) an option in Extended Activities reports to Group or Sort by Duration.  
  
  ---
  
  