How do I add Profile Tags and other database fields to my Attendees & hours report?

As of now, this information can easily be exported from Vome and then imported into an Excel spreadsheet (attached on this article) which generates the information you need! 

To accomplish this, you will need to generate your Attendees & Hours Report, and Vome Database.

This is how it works:

1. Login to Vome and visit the Reports page from the left-hand side of your page

2. Click on the Attendees & Hours report

3. Configure the file as you need to by changing the date range

Please note that if you use any filters (other than the date range) on the view, you must select the rows before exporting it. To do this, simply click the checkbox on the top left of your screen to select all of your rows from your filtered results. Then, when you can click the Export button, it will show an additional option labeled Export selected rows.

4. Click Export > Export all rows OR Export selected rows (this will download the report for you).

Now it's time to download your Vome Database..

5. Visit the Database page using the left-hand side navigation

6. Click Export > Export all rows (this will download the database for you).

Now it's time to plug these reports into the attached excel file!

7. Download the excel file attached on this support article

8. On the first tab of the spreadsheet, you will see a tab labeled Attendees & hours report, you are able to Paste the entire exported Attendees & Hours report there. As of now, we put sample data there, which you should delete and replace with your real data.

To do this, simply open the Vome report that you exported in step 4. Click on the headers and drag your mouse to copy the entire sheet. Then once it is copied, you can return to the impact value workbook to paste it inside of the "Attendees & hours report" sheet (sheet #1). 

9. On the second tab of the spreadsheet, you will see a tab labeled Database export, you are able to Paste the entire exported Vome Database there. As of now, we put sample data there, which you should delete and replace with your real data

Voila! You will see the a tab labeled Summary Insights, which shows you hours logged by tag. 

If you have any questions or need help setting this up, do not hesitate to submit a ticket from the support portal to let us know!

• Related Articles

• What is the difference between "Profile Tags" and "Custom Fields" in the database?

  The Pro plan only offers Profile Tags as a way to customize your database. You cannot import profile tags but can only assign them during the import process or once profiles are in your database. A profile tag can be anything you need it to be. It is ...

• How do I add custom tags to each of my opportunities for reporting purposes?

  As of now, this information can easily be exported from Vome and then imported into an Excel spreadsheet (attached on this article) which generates the information you need! We know this can be super helpful when needing to tag your opportunities in ...

• How should I format my fields to successfully upload them to my database?

  You can use the format below for each type of field to ensure a successful import. There is a template that you can download attached to this article. Please note that you can only create and import custom fields using the Enterprise plan. Title Type ...

• How can I mass assign tags from the database?

  1. Go to the Database 2. Select one or more volunteer records 3. Click on the black down arrow next to the right of "# records selected" 4. Click on Assign tags Tags are useful for classifying your volunteer list however you would like to! A ...

• How do I calculate the total number of hours scheduled for upcoming shifts?

  As of now, this information can easily be exported from Vome and then imported into an Excel spreadsheet (attached on this article) which generates the information you need! We know this can be super helpful when running events on Vome : ) To ...